Excel Short Cut Keys

*Free Microsoft Excel 2016 Beginners Course at John Academy

Keys	Description
Shift + tab	Move to previous cell on Excel sheet; move to previous option on a dialog box
Shift + F10	Opens up the right-click context menu
Ctrl + W	Close Spreadsheet
Ctrl + O	Open Spreadsheet
Ctrl + S	Save File
Ctrl + X	Cut
Ctrl + C	Copy
Ctrl + V	Paste
Ctrl + Z	Undo
Ctrl + B Ctrl + 2	Make text bold
Ctrl + I Ctrl + 3	Make text italic
Ctrl + U Ctrl + 4	Underline text
Ctrl + 5	Strikethrough text
Ctrl + 6	Show/Hide inserted design elements
Ctrl + 8	Show outlines, Create outlines
Ctrl + F	Open dialog to search the document
Ctrl + 9	Hide selected rows
Ctrl + 0	Hide selected columns
Ctrl + 1	Open format cells dialog
Ctrl + T	Create table
Ctrl + Home	Move to the beginning of a worksheet, usually cell A1
Ctrl + End	Move to the lower right corner of the used spreadsheet area
Ctrl + Shift + End	Extend selected area to the lower right corner of the used spreadsheet area
Ctrl + Left Arrow Ctrl + Right Arrow Ctrl + Down Arrow Ctrl + Up Arrow	Move to the farthest cell in the arrow direction specified, regardless of used area
PgUp	Move one viewable screen area up within a sheet
PgDn	Move one viewable screen area down within a sheet
Ctrl + PgUp Ctrl + PgDn	Navigate through the sheets in a workbook
Alt + H	View additional short cut options for the Home tab on the ribbon – displays Keys over elements on the screen. Ex. Alt + H then H opens up background color selection
Alt + N	View additional short cut options for the Index tab on the ribbon – displays Keys over elements on the screen.
Alt + P	View additional short cut options for the Page Layout tab on the ribbon – displays Keys over elements on the screen.
Alt + F	View additional short cut options for the File tab on the ribbon – displays Keys over elements on the screen.
Alt + R	View additional short cut options for the Review tab on the ribbon – displays Keys over elements on the screen.
Alt + A	View additional short cut options for the Data tab on the ribbon – displays Keys over elements on the screen.
Alt + L	View additional short cut options for the Developer tab on the ribbon – displays Keys over elements on the screen.
Alt + M	View additional short cut options for the Formula tab on the ribbon – displays Keys over elements on the screen.
Alt + W	View additional short cut options for the View tab on the ribbon – displays Keys over elements on the screen.
Alt + Y	View additional short cut options for the Help tab on the ribbon – displays Keys over elements on the screen.
Alt + Z	Share, open OneDrive saving options
Alt + Q	Activate “Tell me what you want to do” search