Advertisement:

Some shortcut keys in Excel

Discussion in 'PC Tricks, Tutorials, Softwares And Solutions' started by Babadinho, Oct 8, 2011.

Users Viewing Thread (Users: 0, Guests: 0)

    • Administrator
    • GL Senior Member
    • GL Legend
    • Guru Member

    Babadinho Administrator

    Member Since:
    Sep 19, 2010
    Message Count:
    5,083
    Likes Received:
    448
    Sponsored Links:
    [img width=128 height=107]http://i.imgur.com/J2axd.png[/img]

    Ctrl+Shift+O: To select all the cells with comments. If there are no cells with contents then you will get ‘No cells found’ message.

    Ctrl+[ : To show which are the related cells in the selected formula.

    Ctrl+] : To show the related formulas of the selected cell.

    Shift+Arrow key : The selection will be extended to one more adjacent cell.

    Ctrl+Shift+Arrow key : The selection will be extended to the last cell with data either horizontally or vertically based on your current selection.

    Shift+Home : The selection will be extended to the first cell horizontally.

    Ctrl+Shift+Home : Selection will be extended to the first cell in the worksheet.

    Ctrl+Shift+End: Selection will be extended until the last cell in the worksheet/.

    Enter: Cursor will be moved to the next cell below the current cell.

    jay-authentic Mr

    Member Since:
    Oct 1, 2010
    Message Count:
    60
    Likes Received:
    0
    Current Phone:
    Gionee s plus
    Nice post especially for th0se studying QS..

    Mike_008 Upcoming Guru

    Member Since:
    Oct 2, 2010
    Message Count:
    169
    Likes Received:
    7
    Thanx. I badly need all d shortcuts on MS-WORD.

Sponsored Links:

Share This Page