Wall Street Prep

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

The most important time-saving shortcuts for Excel 2016 for both 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

19
Leave a Reply

avatar
newest oldest most voted
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 is Windows is a necessity?

Haseeb
Haseeb

Jainam, Although the instructor in our lesson videos is on a Windows version of Excel, you can absolutely go through our courses on a Mac. You may find a shortcut here and there that Excel for Mac doesn't have, but our lessons will always show you the native/non-shortcut way of… Read more »

Joe Millman

Thanks for the article! Extremely helpful, but I can't seem to get my Mac's "fn" key to work...

Scott
Scott

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

M.Sivakumar
M.Sivakumar

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

Haseeb
Haseeb

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

Jonas Halldén
Jonas Halldén

You can add ALT+F1, quikly create a chart based on the table or range that is where the cursors is.
Also, CTRL+T seems like an obvious one, to create a table!

Sabih
Sabih

For some reason, the font increase/decrease does not work on my Mac.

Haseeb
Haseeb

Sabih,

If you are referring to the ribbon command to increase or decrease font size, then yes, you cannot use the ribbon command of Alt H F C to access the command. With Mac, you will have to use the mouse to access the ribbon. Thanks!

- Haseeb

JOSE
JOSE

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
Haseeb

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
Haseeb

Andres,

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

Best,
Haseeb

Mohamad
Mohamad

Hello Haseeb,

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

Haseeb
Haseeb

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

Chloe
Chloe

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
Haseeb

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

Christian
Christian

Hello,

I have excel 2011 for Mac. Is this outdated?

Thanks,

Christian

Haseeb
Haseeb

Christian,

Not necessarily - Excel 2011 should be fine - thanks!

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.