Excel Shortcuts

jet-shortcuts

Excel Keyboard Shortcuts

Excel has a large collection of keyboard shortcuts that you can use to simplify your everyday tasks.

Below is a list of the ones I use every time I need to do a particular action. I will list them by order of frequency starting with the ones I use the most to the other ones I use occasionally. If you can commit to learn one or two per month then at the end of the year you will have mastered at least 15 new keyboard shortcuts. Way more that the average user!

Every Day Shortcuts

Shortcut Usage
Ctrl+S Save workbook
Ctrl+W Close workbook
Ctrl+S, W Save and close workbook
Ctrl+N Create a new workbook
Ctrl+Enter Prevent activecell from moving down
Ctrl+Z Undo
Ctrl+Y Redo
Ctrl+P Print
Shift+Arrow Extend selection in the selected direction
Ctrl+Shift+Arrow Select to the extremity in the selected direction
Ctrl+1 Open the Format Cells dialog box
Alt+= Execute the AutoSUM command
Ctrl+PgDn Move to the next worksheet
Ctrl+PgUp Move to the previous worksheet
Alt+PgDn Move one full screen to the right
Alt+PgUp Move one full screen to the left

Every Other Day Shortcuts

Once you have committed to memory the keyboard shortcuts above, experiment with the ones below. If you find a use for one of them use it otherwise save your memory for something else.

Shortcut Usage
Ctrl+F2 Print preview
Alt+Enter Hard return in a cell
Ctrl+F Launch the Find command
Ctrl+H Launch the Replace command
Ctrl+* Select a region
Note:to use the * above the 8 press Ctrl+Shift+8
Ctrl+<Addition> Numeric keypad Insert new row in worksheet or new cells in selection
Make you selection with Ctrl+Shift+<arrow> before
Ctrl+<Subtraction> Numeric keypad Delete row in worksheet or cells in selection
Make you selection with Ctrl+Shift+<arrow> before
F12 Open the SaveAs command
Ctrl+G or F5 Open the Goto command then Alt+S for Special
Ctrl+<Tilde> Above the Tab key. Show/Hide formulas