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 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 Editor