EXCEL SHORTCUT KEYS

Posted by

EXCEL SHORTCUT KEYS

 FUCTION KEY  SHORTCUTS Commands Use
F1Help
F2Edit
F3Paste name
F4Repeat last action
F5Go to
F6Next pane
F7Spell check
F8Extend mode
F9Recalculate all workbook
F10Activate menu bar
F11New chart 
F12Save as
                                SHIFT KEY SHORTCUT
Shift + f1What is this?
Shift + f2 Edit cell comments
Shift + f3 Paste function into from
Shift + f4Find next
Shift + f5Find next
Shift + f6Previous pane
Shift + f8Add to selection
Shift + f9Calculate active worksheet
Shift + f10 Display shortcut menu
Shift + f11New worksheet
Shift + f12Save as
Shift + tabTo move to the previous
TabTo move the next cell
CtrlTo insert the current data
CTRL KEY SHORTCUT Command Use
Ctrl + f3Name manager
Ctrl + f4Close
Ctrl + f5 Restore down
Ctrl + f9 Minimize window
Ctrl + f10Restore down
Ctrl + f11Insert 4.0  macro sheet
Ctrl + f12Open file
Ctrl + spaceTo select the enter colon
  Ctrl + shift + 9 To unhide selected row
Shift + spaceTo select the enter row
Shift + spaceTo select the enter row 
Ctrl + enterLine break
                      ALT KEY SHORT CUT
Alt + f1 Insert chart
Alt + f2Save as
Alt+ f4Exit
Alt+f11Visual basic editor
OTHER FUNCTION KEYS   
Shift + ctrl + f6Previous workbook window
Ctrl + shift + f3Crete name by using names of row and column labels
Ctrl + shift +f12Print
Alt + shift + f1New worksheet
Alt + shift + f2Save

Leave a Reply

Your email address will not be published. Required fields are marked *