Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Keyboard Shortcuts for MS Word and MS Excel

    • 1
    • 2
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 758
    Comment on it

    Below are some general keyboard shortcuts which you can use while working on a MS Word and MS Excel.


    S.No General Shotcuts   S.No Navigation Shortcuts
    1 New file Ctrl + N   1 Move to next cell in row Tab
    2 Open file Ctrl + O   2 Move to previous cell in row Shift + Tab
    3 Save file Ctrl + S   3 Up one screen Page Up
    4 Move between open workbooks Ctrl + F6   4 Down one screen Page Down
    5 Close file Ctrl + F4   5 Move to next worksheet Ctrl + Page Down
    6 Save as F12   6 Move to previous worksheet Ctrl + Page Up
    7 Display the print menu Ctrl + P   7 Go to first cell in data region Ctrl + Home
    8 Select whole spreadsheet Ctrl + A   8 Go to last cell in data region Ctrl + End
    9 Select column Ctrl + Space   9 Data Region Left Ctrl + Left Arrow
    10 Select row Shift + Space   10 Data Region Right Ctrl + Right Arrow
    11 Undo last action Ctrl + Z   11 Data Region Down Ctrl + Down Arrow
    12 Redo last action Ctrl + Y   12 Data Region Up Ctrl + Up Arrow
    13 Exit Excel Alt + F4   13 Select Whole Data Region Ctrl + Shift + 8
    14 Spell Check F7   14 Move to Next Sheet Ctrl + Page Down
    15 Cut Ctrl + X   15 Move to Prior Sheet Ctrl + Page Up
    16 Copy Ctrl + C   16 Access Drop down menu Alt + Down/Up Arrow
    17 Paste Ctrl + V   17 Zoom in / out Ctrl + mouse scroll
    18 Find text Ctrl + F        
    19 Recalculate F9        
                 
    S.No Formatting Text In Worksheet Shortcuts   S.No Cells Formatting Shortcuts
    1 Bold toggle for selection Ctrl + B   1 Format cells Ctrl + 1
    2 Italic toggle for selection Ctrl + I   2 Select font Ctrl + Shift + F
    3 Underline toggle for selection Ctrl + U   3 Select font size Ctrl + Shift + P
    4 Strikethrough for selection Ctrl + 5   4 Format as number Ctrl + Shift + 1
    5 Change the font Ctrl + Shift + F   5 Format as date Ctrl + Shift + 3
    6 Change the font size Ctrl + Shift + P   6 Format as currency Ctrl + Shift + 4
    7 Apply outline borders Ctrl + Shift + 7   7 Format as percentage Ctrl + Shift + 5
    8 Remove all borders Ctrl + Shift + Underline        
    9 Wrap text in same cell Alt + Enter        
                 
    S.No Insert Text Automatically Shortcuts   S.No Editing/Deleting Text Shotcuts
    1 Autosum a range of cells Alt + Equals Sign   1 Delete one character to right Delete
    2 Insert the date Ctrl + ; (semi-colon)   2 Delete one character to left Backspace
    3 Insert the time Ctrl + Shift + ; (semi-colon)   3 Edit active cell F2
    4 Insert columns/rows Ctrl + Shift + + (plus sign)   4 Cancel cell entry Escape Key
    5 Insert a new worksheet Shift + F11        
                 
            S.No Highlight Cells Shortcuts
            1 Select entire worksheet Ctrl + A
            2 Select entire row Shift + Spacebar
            3 Select entire column Ctrl + Spacebar
            4 Manual select Shift + Arrow Key

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: