No Thanks

7 free financial modeling lessons!

Learn Financial Statement Modeling, M&A, LBO, DCF, Comps and essential Excel shortcuts by signing up for Wall Street Prep's free Quicklesson series. We'll email you the first lesson, "A Simple LBO Model," right now.

The 100+ Excel 2016 Shortcuts You Need to Know, Updated for Windows and Mac

Excel shortcuts are a fundamental component of efficient financial modeling. Quite simply, it’s well worth the time to learn them. Here, Wall Street Prep has compiled the most important time-saving shortcuts for Excel 2016 for both Windows and Mac.

If there are shortcuts you use all the time that you don’t see here, let us know using the comment form below and we’ll add them.

PCWindows shortcuts in blue.

MacMac shortcuts in red.

Editing PC Mac
Copy ctrl+c ctrl+c
Paste ctrl+v ctrl+v
Undo ctrl+z ctrl+z
Redo ctrl+y ctrl+y
File PC Mac
Open ctrl+o ctrl+o
New ctrl+n ctrl+n
Print ctrl+p ctrl+p
Save ctrl+s ctrl+s
Save as f12 +shift+s
Go to next workbook ctrl+tab +~
Close file ctrl+f4 ctrl+w
Close all open Excel files alt+f4 ctrl+q
Ribbon PC Mac
Show ribbon accelerator keys alt
Show/hide ribbon ctrl+f1 +opt+r
Formatting PC Mac
Format Box ctrl+1 +1
Bold ctrl+b ctrl+b
Italic ctrl+i ctrl+i
Underline ctrl+u +u
Number format ctrl+shift +! ctrl+shift +!
Percent format ctrl+shift+% ctrl+shift+%
Date format ctrl+shift+# ctrl+shift+#
Insert/edit comment shift+f2 shift+f2
Increase font size althfg +shift+>
Decrease font size althfk +shift+>
Increase decimal alth0
Decrease decimal alth9
Increase indent alth6 ctrl+m
Decrease indent alth5 +shiftm
Paste Special PC Mac
Paste Special formats ctrl+alt+vt ctrl++vt
Paste Special values ctrl+alt+vv ctrl++vv
Paste Special formulas ctrl+alt+vf ctrl++vf
Paste Special comments ctrl+alt+vc ctrl++vc
Clear PC Mac
Clear cell data delete delete
Clear cell formats althef
Clear cell comments althem
Clear all (data, formats, comments) althea
Borders PC Mac
Outline Border ctrl+shift+& ctrl+shift+&
Remove border ctrl+shift+ ctrl+shift+
Left border althbl +option+left
Right border althbr +option+right
Top border althbt +option+top
Bottom border althbo +option+bottom
Getting around a worksheet PC Mac
Move from cell to cell arrows arrows
Go to end of contiguous range ctrl+arrows +arrows
Move one screen up pgup fn+up
Move one screen down pgdn fn+down
Move one screen left alt+pgup fn+option+up
Move one screen right alt+pgdn fn+option+down
Go to cell A1 ctrl+home fn+ctrl+left
Go to beginning of row home fn+left
Go to last cell in worksheet ctrl+end fn+ctrl+right
Display the Go To dialog box f5 f5
Selecting data in a worksheet PC Mac
Select a cell range shift+arrows shift+arrows
Highlight a contiguous range ctrl+shift+arrows +shift+arrows
Extend selection up one screen shift+pgup fn+shift+up
Extend selection down one screen shift+pgdn fn+shift+down
Extend selection left one screen alt+shift+pgup fn+shift++up
Extend selection right one screen alt+shift+pgdn fn+shift++down
Select all ctrl+a +a
Data editing PC Mac
Fill down from cell above ctrl+d ctrl+d
Fill right from cell left ctrl+r ctrl+r
Find and replace ctrl+f ctrl+f
Show all constants f5altso
Highlight cells with comments f5altsc
Data editing when inside cell PC Mac
Edit the active cell (edit mode) f2 f2
While editing cell, allow use of arrow keys to create reference f2 f2
Confirm change and get out of cell enter enter
Cancel a cell entry and get out of cell esc esc
Insert line break within cell alt+enter option+enter
Highlight within a cell shift+left/right shift+left/right
Highlight contiguous items ctrl+shift+left/right ctrl+shift+left/right
Jump to beginning of cell contents home fn+left
Jump to end of cell contents end fn+right
Delete character to left backspace delete
Delete character to right delete fn delete
Accept autocomplete suggestion tab tab
Referencing a cell from another worksheet ctrl+pgup/pgdn  arrows ctrl+fn+down/up  arrows
Calculations PC Mac
Start a formula = =
Insert autosum formula alt+= +shift+t
Recalculate all worksheets f9 f9
Anchor cells (A$1$), toggle anchors (edit mode) f4 f4
Insert a function shift+f3 shift+f3
Enter array formula (edit mode) shift+ctrl+enter shift+ctrl+enter
Auditing formulas PC Mac
Inspect cell values (edit mode) f9 f9
Switch to formula view ctrl+~ ctrl+~
Select direct precedents ctrl+[ ctrl+[
Select direct dependents ctrl+] ctrl+]
Trace immediate precedents altmp
Trace immediate depedents altmd
Remove tracing arrows altmaa
Go to last cell f5 enter f5 enter
Moving inside Excel forms (format dialog, page setup, etc) PC Mac
Move forward from control to control tab tab
Moving from tab to tab ctrl+tab ctrl+tab
Move backward from control to control ctrl+shift+tab shift+tab
Move within a list arrows arrows
Activate control altunderlined letter
Toggle checkboxes spacebar spacebar
Close a dialog esc esc
Apply change enter enter
Excel Utilities PC Mac
Recalculate all worksheets f9 f9
Excel Options Dialog altto ⌘ +,
Accessing data validation altavv
Get inside a drop-down list alt+up/down option+up/down
Insert data table (must highlight cell first) altawt
Sort a data range altass shift++r
Autofilter selection altat
Insert a pivot table altnv
Insert a chart altnr
Record a macro altlr
Name a cell or cell range ctrl+f3
Zoom altwq crtl+mouse scroll
Navigating across worksheets and panes PC Mac
Jump to next worksheet ctrl+pgdn fn+ctrl+down
Jump to previous worksheet ctrl+pgup fn+ctrl+up
Change worksheet name althor
Rearrange tab order althom
Freeze pane altwff
Split screen altws
Toggle from tab, ribbon, task pane, status bar f6
Close Excel Help (and other task panes) ctrl+spacebarc
Row and column shortcuts PC Mac
Select column ctrl+spacebar ctrl+spacebar
Select row shift+spacebar shift+spacebar
Delete row(s)/column(s) ctrl+ ctrl+
Add row(s)/column(s) ctrl+shift++ ctrl+shift++
Set column width althow
Autofit column width althoi
Fit to specific row height althoh
Group rows/columns alt+shift+right alt+shift+right
Ungroup rows/columns alt+shift+left alt+shift+left
Share This
Leave a Comment

8 Comments
  1. September 26, 2017

    Chloe Boyce

    Hi,
    on a PC, when hitting alt it shows all the shortcuts to navigate through the different tabs. What would be the equivalent of that on a MAC?

    • September 26, 2017
      user headshot

      Haseeb Chowdhry

      Chloe,

      Unfortunately for a Mac, that command does not exist, but there are ways to get close to the Windows functionality:

      a) You can Enable Ctrl + Arrows by disabling Mission Control settings on your Mac by following these steps:

      1. Go to System Preferences > Keyboard.
      2. Go to “Keyboard shortcuts” tab.
      3. Click “Mission Control” in the left window.
      4. Expand the “Mission Control” tab in the right window and click off “Move left a space” and “Move right a space”

      b) You can enable Ctrl+Spacebar for highlighting columns by disabling Spotlight Search
      1. System Preferences > Keyboard.
      2. Go to “Keyboard shortcuts”s” tab.
      3. Click “Spotlight” in the left window.
      4. Disable “Show Spotlight Search.”

      Hope this helps – thanks!

  2. July 28, 2017

    Christian Barron

    Hello,

    I have excel 2011 for Mac. Is this outdated?

    Thanks,

    Christian

    • August 2, 2017
      user headshot

      Haseeb Chowdhry

      Christian,

      Not necessarily – Excel 2011 should be fine – thanks!

  3. January 19, 2017

    M.Sivakumar

    i want shortcut key for one time open more then one hided sheet

    • January 19, 2017
      user headshot

      Haseeb Chowdhry

      I don’t think there is a shortcut for that unless you build it in VBA – thanks!

  4. January 4, 2017

    Joe Millman

    Thanks for the article! Extremely helpful, but I can’t seem to get my Mac’s “fn” key to work…

    • January 4, 2017
      user headshot

      Scott McCarthy

      Hi Joe,

      By default, Mac function keys control system settings and Mission Control. To use function keys for shortcuts, you’ll need to hold down the “fn” key before you press F2, F3, etc. You can change this in System Preferences > Keyboard by checking “Use all F1, F2, etc. keys as standard function keys.” You can now use the function keys without pressing “fn.”

X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.