Wall Street Prep

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

Excel Shortcuts List

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
Turbo-charge your time in Excel Used at top investment banks, Wall Street Prep's Excel Crash Course will turn you into an advanced Power User and set you apart from your peers.
Learn More
Formatting PC Mac
Open Format dialog ctrl+1 +1
Bold ctrl+b ⌘+b
Italic ctrl+i ⌘+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 +shift+m
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
Jump to end of cell contents end
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  ctrl+l
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 option+shift+right
Ungroup rows/columns alt+shift+left option+shift+left
Comments

16
Leave a Reply

avatar
newest oldest most voted
JOSE GONZALEZ
JOSE GONZALEZ

Could I use a windows keyboard with a mac version of excel?in order to learn the windows shortcuts, which I am going to use both at work and at home

Haseeb Chowdhry
Haseeb Chowdhry

Jose,

Unfortunately not – the program itself controls the shortcuts. You need to work on a Windows version of Excel to utilize those shortcuts.

– Haseeb

Andres
Andres

Do you have all these shortcuts for German Keyboard?

Haseeb Chowdhry
Haseeb Chowdhry

Andres,

I apologize – we only publish our shortcuts in English. Take care!

Best,
Haseeb

Mohamad Kawam
Mohamad Kawam

Hello Haseeb,

Is there a shortcut that allows us to reverse the sign of the value in a cell?

Haseeb Chowdhry
Haseeb Chowdhry

Mohamad,

If you have the Boost add-in tool, you can press Ctrl Alt Shift \ to reverse the sign of a number. Hope this helps!

Haseeb

Jainam Shah
Jainam Shah

I am thinking of purchasing the Premium Package, but the demo videos are shown in Windows. I have a MacBook, will all features also work in Excel for Mac ? or windows is a necessity?

Haseeb Chowdhry
Haseeb Chowdhry

Jainam,

The videos are all conducted on a Windows machine, but we do provide Mac Excel shortcuts to help you bridge the gap. Users have been able to complete coursework on both Windows and Mac machines. Hope this helps!

Chloe Boyce
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?

Haseeb Chowdhry
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.… Read more »

Christian Barron
Christian Barron

Hello,

I have excel 2011 for Mac. Is this outdated?

Thanks,

Christian

Haseeb Chowdhry
Haseeb Chowdhry

Christian,

Not necessarily – Excel 2011 should be fine – thanks!

M.Sivakumar
M.Sivakumar

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

Haseeb Chowdhry
Haseeb Chowdhry

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

Joe Millman
Joe Millman

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

Scott McCarthy
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.