ExcelReady › Excel shortcuts cheat sheet

Windows and Mac · Printable

Excel shortcuts cheat sheet (Windows and Mac)

The 31 shortcuts that save the most time in everyday Excel work and timed Excel tests, grouped by task. Print it, or practice them right here in the drill below.

Practice in the drill

Essentials

ActionWindowsMac
CopyCtrl + C⌘ + C
CutCtrl + X⌘ + X
PasteCtrl + V⌘ + V
Paste SpecialCtrl + Alt + V⌃ + ⌘ + V
UndoCtrl + Z⌘ + Z
RedoCtrl + Y⌘ + Y
SaveCtrl + S⌘ + S
FindCtrl + F⌘ + F
Select everythingCtrl + A⌘ + A

Moving around

ActionWindowsMac
Jump to the edge of the dataCtrl + arrow key⌘ + arrow key
Go to cell A1Ctrl + Homefn + ⌃ + ←
Go to the last used cellCtrl + Endfn + ⌃ + →

Selecting

ActionWindowsMac
Select to the edge of the dataCtrl + Shift + arrow key⌘ + Shift + arrow key
Select the whole columnCtrl + Space⌃ + Space
Select the whole rowShift + SpaceShift + Space

Editing and formulas

ActionWindowsMac
Edit the active cellF2⌃ + U
Fill downCtrl + D⌘ + D
Fill rightCtrl + R⌘ + R
AutoSumAlt + =⌘ + Shift + T
Toggle absolute reference ($A$1)F4⌘ + T
New line inside a cellAlt + Enter⌥ + Return
Insert today's dateCtrl + ;⌃ + ;
Show formulas instead of resultsCtrl + `⌃ + `

Formatting

ActionWindowsMac
BoldCtrl + B⌘ + B
ItalicCtrl + I⌘ + I
UnderlineCtrl + U⌘ + U
Format Cells dialogCtrl + 1⌘ + 1
Currency formatCtrl + Shift + $⌃ + Shift + $
Percent formatCtrl + Shift + %⌃ + Shift + %

Data

ActionWindowsMac
Turn filters on or offCtrl + Shift + L⌘ + Shift + F
Create a tableCtrl + T⌃ + T

Mac shortcuts are for Excel for Mac. On some Mac keyboards you need fn for F-keys. ⌘ is Command, ⌃ is Control and ⌥ is Option.

Practice: 30-second shortcut drill

Knowing a shortcut isn't the same as using it without thinking. Click the box and press each shortcut as fast as you can.

Drill8 shortcuts

Press the shortcut for:

The five that matter most in an Excel test

  1. F4 (Mac: ⌘ + T) while typing a formula: locks a reference as $A$1, the most common test trap.
  2. Ctrl + D (Mac: ⌘ + D): copies a formula down a selected column in one go.
  3. Ctrl + Shift + arrow (Mac: ⌘ + Shift + arrow): selects a whole range instantly for SUM, SUMIFS or a lookup.
  4. Alt + = (Mac: ⌘ + Shift + T): AutoSum.
  5. Ctrl + Z (Mac: ⌘ + Z): because under time pressure, you will need it.

Test more than shortcuts

The free 10-minute test checks formulas, references, lookups and more.

Start the free test

Frequently asked questions

What are the most useful Excel shortcuts?

Copy, paste and undo, then F4 to lock references, Ctrl + D to fill down, Ctrl + Shift + arrow to select data, and Alt + = for AutoSum. Those save the most time day to day.

Do Excel shortcuts work on a Mac?

Most do, with ⌘ (Command) in place of Ctrl. A few are different, such as AutoSum (⌘ + Shift + T) and editing a cell (⌃ + U). The table lists both.

Can I print this Excel shortcuts cheat sheet?

Yes: use the Print button at the top. The page prints as clean tables without the menus and the drill.

Do Excel tests check shortcuts?

Some do directly, but mostly shortcuts matter because tests are timed. Fast selection and filling leave more time for the hard tasks.

More free Excel resources