MS Excel Shortcuts

Shortcut Key(s)Action
Alt + Shift + ATo launch a shortcuts dialog window
Shift + F10To display the context menu
Alt + Windows, OTo open an existing file in Excel app
Alt + Windows, WTo open the View tab
Alt + Windows, RTo open the Review tab
Alt + Windows, ATo open the Data tab
Alt + Windows, NTo open the Insert tab
Alt + Windows, HTo open the Home tab
Alt + Windows, FTo open the File tab
EnterTo complete the cell entry and move to the cell below
EscTo cancel the entry
DeleteTo clear the selected cell
Alt + EnterTo start a line in the selected cell
Ctrl + ZTo undo the changes
Ctrl + YTo redo the changes
Ctrl + CTo copy the selection
Ctrl + XTo cut the selection
Ctrl + VTo paste the copied contents from the clipboard
Ctrl + Alt + VTo launch ‘Paste Special’ dialog
Shift + F11To insert a new worksheet
Ctrl + KTo insert the hyperlink
Ctrl + LTo insert the table
Alt + F1To insert the chart
Ctrl + OTo open a worksheet
Ctrl + PTo print the worksheet
Alt + F2To launch the ‘Save As’ dialog
Ctrl + FTo launch the ‘Find and Replace’ dialog with the Find tab selected
Ctrl + HTo launch the ‘Find and Replace’ dialog with the Replace tab selected
Ctrl + F7To SpellCheck
Shift + F2To insert the comment
Ctrl + SpaceTo select the entire column
Shift + SpaceTo select the entire row
Ctrl + ATo select all cells in the sheet
Ctrl + Shift + LTo turn on the filtering option for the selected cell

Leave a Comment

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