Using shortcuts in Excel is considered one of the most effective methods for saving tremendous amounts of time, as well as improving your Excel skills.

Click here to download a printable version to hang in your office!

 

Click here to view Excel Shortcuts for Windows

Here are some of the most popular shortcuts for Excel for Mac users:

 

Working with rows/columns/ranges

⌃ + Space – Select the whole column

⇧ + Space – Select the whole row

‏⌘ + A – Select all (Click once to select the current range, click twice to select the entire worksheet)

⇧ + ⌃ + Arrow keys – Select a range – from the selected cell to the end of the range

⌘ + Arrow keys – Go the end of the range

⌥+ ; (Semicolon) – Select visible cell only

⌃ + – (Minus) –  Delete cells/ rows/ columns

⇧ + ⌃ + = – Insert cells/rows/columns

 

Working with Workbooks/Worksheets

⌃ + N – Open a new Workbook

⌘ + O – Open an existing Workbook

⌃ + S – Save Workbook (Or Save As, if it’s the first time you’re saving it)

Fn + F12 – Save As (Even if you already saved it!)

⌃ + P – Print

Fn + ⌘ + F4 / ⌘ + W – Close Workbook

⌘ + W – Close Excel (All workbooks)

Fn + ⇧ + F11 – Add a new Worksheet

 

Data entry

⌘ + : (Colon) – Current time

⌃ + : (Colon) – Current date

⌃ + D – Copy the cell above

⌃ + R  – Copy the cell to the left

Fn + F2 – Edit cell / view cell formula

Fn + F4 – (When editing a specific cell) Apply absolute/mixed/relative reference (For example, cell C4 will change to $C$4 – Absolute Reference)

Fn + F7 – Open the spelling tool

⌃ + E – Flash Fill – One of Excel’s greatest tools for auto-completing data based on examples from adjacent cells.

⌃ + C – Copy

⌃ + V – Paste

⌃ + X – Cut

⌃ + ⌘ + V – Paste Special

 

Formulas

⌃ + ~ (Tilde) – Shows all the formulas in the sheet

Fn + F4 – (When a cell is not being edited) Repeats the last action

⌃ + ⇧ + Enter – Apply an array formula

⌃ + T – Define range as data table

⌘ + ⇧ + T  – Quick sum

 

Navigation

⌃ + F – Find

⌃ + H – Find and Replace

Fn + ⌃ + Up / Down Arrow Keys – Navigate between sheets

⌃ + Z  – Undo last action

⌃ + Y – Redo (Ctrl + Z)

⌃ + [  – Takes you to the cell referenced by the formula

⌃ + ]  – Takes you to the cell which is affected by the current cell

Fn + F5 , then Enter (not together) – Takes you back to where you were before using ctrl + [

Fn + ⌃ + Left / Right Arrow Keys – Go to the first cell in worksheet (A1) / Go to the last cell in the used range

⌘ + Arrow Keys – Go to the last non-empty cell (Stops when you reach an empty cell)

⇧ + Arrow Keys – Select cells in the direction of the Arrow Keys (One at a time)

⌘ + ⇧ + Arrow Keys – Select cells until the last non-empty cell (Stops when you reach an empty cell)

 

Cell editing

Please note – These shortcuts will work when editing a specific cell. If you try these shortcuts when you’re not editing a cell, they will work differently!

Fn + F2 – Edit the selected cell (instead of double-clicking it)

Fn + ⇧ + F2 – Add a comment

⌥ + Enter – Line break – Start a new line in the current cell

Fn + Left Arrow Key – Go to the beginning of the current row within the cell which is being edited

Fn + ⌃ + Left Arrow Key – Go to the beginning of the edited cell

Fn + Right Arrow Key- Go to the end of the current row within the cell which is being edited

Fn + ⌃ + Right Arrow Key – Go to the end of the edited cell

Fn + F9 – Shows the result of the function/part of it (Based on what is selected)

 

Cell Formatting

Fn + ⌃ + 1 – Open Cell Formatting window

⌘ + B – Bold text

⌘ + U – Underlined Text

⌘ + I – Italic Text

⌘ + ⇧ + X – Strikethrough

 

Other important shortcuts

⌃ + ⇧ + L – Apply filtering on the current range

Fn + ⌥+ F11 – Open Visual Basic Editer