Excel Short Cut Keys

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

 

Quick Work Shortcuts

Alt + +/= Quick Sum: Highlight a column of numbers. Shortcut automatically adds in the SUM() formula.

Before:                                          After:

QuickSum1.png                QuickSum2.png

Ctrl + ; Current Date: Inserts the current date into an active cell.
Ctrl + Shift + ; Current Time: Inserts the current time into an active cell.

 

Excel VBA Resources

 

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: