Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

This blog is part of 1 Tute Sets.

Google Spreadsheet and Excel Tutorials
Tute set by sachin.joshi
10 Blogs
prev 1

  • Keyboard Shortcuts for MS Word and MS Excel

    @sachin.joshi
    Recommendations Offline Message

    • 1
    • 2
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 985
    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

    MS Office keyboard shortcuts MS Word shortcuts MS Excel shortcuts
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: