50 Excel Shortcuts You Should Know

Using Excel efficiently is an important skill. This guide will show 50 Excel shortcuts you should know. Using Excel shortcuts is faster than a mouse.

Many users use a full keyboard to use these Excel shortcuts. The full keyboard also includes a numeric keypad which is important for entering numbers in Excel.

Excel Shortcuts

Excel uses several modifier keys to perform different functions. These are great to be a proficient user of Excel.

Modifier Keys

Special KeyMacWindows
Alt / OptionAlt
Enter / ReturnEnter
Windows and Mac Modifier Keys

For a list of all the keyboard symbols, see What are the Keyboard Symbol Names?

File shortcuts

The following Excel shortcuts relate to opening, saving, and printing files.

New workbook⌘ NCtrl N
Open workbook⌘ OCtrl O
Save workbook⌘ SCtrl S
Save as⌘ ⇧ SF12
Print⌘ PCtrl P
Close workbook⌘ WCtrl F4
Quit Excel⌘ QAlt F4
File Excel Shortcuts

Data entry shortcuts

The following shortcuts allow for rapid data entry. When you enter data and hit ⏎ (Enter), Excel will save the data and move to the cell directly below.

With the following shortcuts, you can force the cell to move in any direction.

Enter and
cell down
Enter and
cell up
⇧ ⏎Shift Return
Enter and
cell right
Enter and
cell left
⇧ TabShift Tab
Data entry Excel shortcuts

Learn to use Excel shortcuts instead of the mouse or trackpad. The keyboard is mightier than the mouse!

Here is a top rated wireless keyboard with a number keypad for both Windows and Mac (Amazon affiliate link).

Editing shortcuts

The following shortcuts are used to edit in Excel. Excel shortcuts are much faster than using a mouse or trackpad to use the menu. 

You need to know Copy, Cut, Paste, and Undo. You will use them all the time.

Help⌘ /F1
Undo⌘ ZCtrl Z
Redo⌘ YCtrl Y
Copy⌘ CCtrl C
Cut⌘ XCtrl X
Paste⌘ VCtrl V
Paste Special⌃ ⌘ VCtrl Alt V
Find⌘ FCtrl F
Select All⌘ ACtrl A
Edit cell⌃ UF2
Open the
Replace dialog
⌃ HCtrl H
Bold⌘ BCtrl B
Italics⌘ ICtrl I
Underline⌘ UCtrl U
Editing Excel shortcuts

Advanced Excel shortcuts

Insert CommentFn ⇧ F2Shift F2
Add Hyperlink⌘ KCtrl K
Calculate FormulasF9F9
Absolute AddressF4F4
Repeat Last ActionF4F4
Show Formulas^ `Ctrl `
Enter Current Date⌃ ;Ctrl ;
Enter Current Time⌘ ;Ctrl Shift :
Format Cells (dialog box)⌘ 1Ctrl 1
Delete (dialog box)⌘ –Ctrl –
Insert (dialog box)⌘ +Ctrl Shift +
Flash Fill⌃ ECtrl E
AutoSum⌘ ⇧ TAlt =
Select Tab to the Right⌥ →Ctrl PgDn
Select Tab to the Left⌥ ←Ctrl PgUp
Advanced Excel shortcuts

F4: two uses

Note that F4 can do two separate but important things: 

  1. absolute address for cells in formulas
  2. repeat last action.

Some keyboards have multimedia functions for the F1-F12 keys. To use these keys as standard F1, F2, and F3 keys, combine them with the Fn key.

Selection shortcuts

The following shortcuts select entire rows, columns, or tables. These shortcuts are much faster then dragging the mouse or highlighting cells.

Select Entire Row⇧ SpaceShift Space
Select Entire Column⌃ SpaceCtrl Space
Extend Last Cell Right⌘ ⇧ →Ctrl Shift →
Extend Last Cell Left⌘ ⇧ ←Ctrl Shift ←
Extend Last Cell Up⌘ ⇧ ↑Ctrl Shift ↑
Extend Last Cell Down⌘ ⇧ ↓Ctrl Shift ↓
Top Cell⌘ ↑Ctrl ↑
Bottom Cell⌘ ↓Ctrl ↓
Left Cell⌘ ←Ctrl ←
Right Cell⌘ →Ctrl →
Selection Excel shortcuts

Format cells shortcuts

General⌃ ⇧ ~Ctrl Shift ~43650.63
Number⌃ ⇧ 1Ctrl Shift 143,650.63
Time⌃ ⇧ 2Ctrl Shift 23:07 PM
Date⌃ ⇧ 3Ctrl Shift 34-Jul–19
Currency⌃ ⇧ 4Ctrl Shift 4$43,650.63
Percent⌃ ⇧ 5Ctrl Shift 54365063%
Scientific⌃ ⇧ 6Ctrl Shift 64.37E+04
Border⌃ ⇧ 7Ctrl Shift 7Cell Border
Format cells Excel shortcuts
Scroll to Top