File Operations
Shortcut | Windows | Mac | Web |
---|---|---|---|
Create new workbook | CtrlN | ⌘N | CtrlN |
Open workbook | CtrlO | ⌘O | CtrlO |
Save workbook | CtrlS | ⌘S | CtrlS |
Save as | F12 | ⌘ShiftS | F12 |
Print file | CtrlP | ⌘P | CtrlP |
Print preview | CtrlF2 | ⌘P | |
Close current workbook | CtrlW | ⌘W | CtrlW |
Close Excel | AltF4 | ⌘Q |
Basic Editing
Shortcut | Windows | Mac | Web |
---|---|---|---|
Undo last action | CtrlZ | ⌘Z | CtrlZ |
Redo last action | CtrlY | ⌘Y | CtrlY |
Copy selected cells | CtrlC | ⌘C | CtrlC |
Cut selected cells | CtrlX | ⌘X | CtrlX |
Paste content | CtrlV | ⌘V | CtrlV |
Paste special dialog box | CtrlAltV | ⌘CtrlV | |
Find | CtrlF | ⌘F | CtrlF |
Find and replace | CtrlH | ⌘H | CtrlH |
Find next match | ShiftF4 | ||
Find previous match | CtrlShiftF4 | ||
Repeat last action | F4 | ⌘Y |
Navigation
Shortcut | Windows | Mac | Web |
---|---|---|---|
Move to next cell | Tab | Tab | Tab |
Move to previous cell | ShiftTab | ShiftTab | ShiftTab |
Move to edge of data upward | Ctrl↑ | ⌘↑ | Ctrl↑ |
Move to edge of data downward | Ctrl↓ | ⌘↓ | Ctrl↓ |
Move to edge of data left | Ctrl← | ⌘← | Ctrl← |
Move to edge of data right | Ctrl→ | ⌘→ | Ctrl→ |
Go to cell A1 | CtrlHome | ⌘Home | CtrlHome |
Go to last cell | CtrlEnd | ⌘End | CtrlEnd |
Move one screen up | PgUp | PgUp | PgUp |
Move one screen down | PgDn | PgDn | PgDn |
Move one screen right | AltPgDn | OptionPgDn | |
Move one screen left | AltPgUp | OptionPgUp | |
Go back to hyperlink | CtrlGEnter | ⌘GEnter |
Selection
Shortcut | Windows | Mac | Web |
---|---|---|---|
Select entire column | CtrlSpace | ⌘Space | CtrlSpace |
Select entire row | ShiftSpace | ShiftSpace | ShiftSpace |
Select all cells | CtrlA | ⌘A | CtrlA |
Extend selection up one cell | Shift↑ | Shift↑ | Shift↑ |
Extend selection down one cell | Shift↓ | Shift↓ | Shift↓ |
Extend selection left one cell | Shift← | Shift← | Shift← |
Extend selection right one cell | Shift→ | Shift→ | Shift→ |
Add adjacent cells to selection | ShiftClick | ShiftClick | ShiftClick |
Add non-adjacent cells to selection | CtrlClick | ⌘Click | CtrlClick |
Cancel selection | Esc | Esc | Esc |
Select array | F5AltSA | ||
Select dependents | F5AltSDL | ||
Select blank cells | F5AltSK | ||
Select column differences | F5AltSM | ||
Select precedents | F5AltSPL | ||
Select similar formatting | F5AltSTE | ||
Select similar validation | F5AltSVE | ||
Select row differences | F5AltSW |
Formatting
Shortcut | Windows | Mac | Web |
---|---|---|---|
Format cells dialog | Ctrl1 | ⌘1 | |
Toggle bold | CtrlB | ⌘B | CtrlB |
Toggle italic | CtrlI | ⌘I | CtrlI |
Toggle underline | CtrlU | ⌘U | CtrlU |
Toggle strikethrough | Ctrl5 | ⌘5 | |
Align center | AltHAC | ||
Align left | AltHAL | ||
Align right | AltHAR | ||
Increase font size | AltHFG | ||
Decrease font size | AltHFK | ||
Add border outline | CtrlShift7 | ⌘Option0 | |
Remove borders | CtrlShift_ |
Number Formatting
Shortcut | Windows | Mac | Web |
---|---|---|---|
Apply general format | CtrlShift~ | ⌘Shift~ | |
Apply number format | CtrlShift1 | ⌘Shift1 | |
Apply currency format | CtrlShift4 | ⌘Shift$ | |
Apply percentage format | CtrlShift5 | ⌘Shift5 | |
Apply date format | CtrlShift# | ⌘Shift# | |
Apply time format | CtrlShift@ | ⌘Shift@ | |
Apply scientific format | CtrlShift^ | ⌘Shift^ |
Data Entry
Shortcut | Windows | Mac | Web |
---|---|---|---|
Edit active cell | F2 | F2 | F2 |
Insert current date | Ctrl; | ⌘; | |
Insert current time | CtrlShift; | ⌘Shift; | |
Fill down from cell above | CtrlD | ⌘D | |
Fill right from cell left | CtrlR | ⌘R | |
Copy formula from cell above | Ctrl' | ⌘' | |
Copy value from cell above | CtrlShift" | ⌘Shift" | |
Add hyperlink | CtrlK | ⌘K | |
Flash fill | CtrlE | ⌘E | |
Complete entry in cell | CtrlEnter | ⌘Enter | CtrlEnter |
Insert line break in cell | AltEnter | OptionEnter |
Grid Operations
Shortcut | Windows | Mac | Web |
---|---|---|---|
Insert rows/columns | CtrlShift+ | ⌘Shift+ | |
Delete rows/columns | Ctrl- | ⌘- | |
Hide columns | Ctrl0 | ⌘0 | |
Hide rows | Ctrl9 | ⌘9 | |
Unhide columns | CtrlShift0 | ⌘Shift0 | |
Unhide rows | CtrlShift9 | ⌘Shift9 | |
Group rows or columns | AltShift→ | OptionShift→ | |
Ungroup rows or columns | AltShift← | OptionShift← | |
Zoom in | CtrlAlt+ | ⌘Option+ | |
Zoom out | CtrlAlt- | ⌘Option- |
Workbook Management
Shortcut | Windows | Mac | Web |
---|---|---|---|
Insert new worksheet | ShiftF11 | ShiftF11 | |
Go to next worksheet | CtrlPgDn | Fn⌘PgDn | |
Go to previous worksheet | CtrlPgUp | Fn⌘PgUp | |
Move to next workbook | CtrlTab | ⌘` | |
Move to previous workbook | CtrlShiftTab | ⌘Shift` | |
Toggle full screen | CtrlShiftF1 | ⌘ShiftF1 | |
Toggle scroll lock | ScrLk |
Advanced Features
Shortcut | Windows | Mac | Web |
---|---|---|---|
Insert pivot table | AltNV | ||
Create embedded chart | AltF1 | ||
Create chart in sheet | F11 | F11 | |
Text to columns | AltAE | ||
Insert table | CtrlT | ⌘T | |
Toggle filter | CtrlShiftL | ⌘ShiftF | |
Insert or edit comment | ShiftF2 | ShiftF2 | |
Open Visual Basic Editor | AltF11 | OptionF11 | |
Show formulas | Ctrl` | ⌘` | |
Calculate all worksheets | F9 | F9 | |
Calculate active worksheet | ShiftF9 | ShiftF9 |
Ribbon Navigation
Shortcut | Windows | Mac | Web |
---|---|---|---|
Expand or collapse ribbon | CtrlF1 | ⌘F1 | |
Access Home tab | AltH | ||
Access Insert tab | AltN | ||
Access Page Layout tab | AltP | ||
Access Formulas tab | AltM | ||
Access Data tab | AltA | ||
Access Review tab | AltR | ||
Access View tab | AltW |
Charts and Graphs
Shortcut | Windows | Mac | Web |
---|---|---|---|
Insert bar chart | AltNB | ||
Insert column chart | AltNC | ||
Insert line chart | AltNN | ||
Insert pie/doughnut chart | AltNQ | ||
Open recommended charts | AltNR | ||
Insert combo chart | AltNSD | ||
Insert text box | AltNX |
Conditional Formatting
Shortcut | Windows | Mac | Web |
---|---|---|---|
Clear worksheet rules | AltHLCE | ||
Clear PivotTable rules | AltHLCP | ||
Clear selected cell rules | AltHLCS | ||
Clear table rules | AltHLCT | ||
Set data bar formatting | AltHLD | ||
Format date occurring cells | AltHLHA | ||
Format cells between values | AltHLHB | ||
Format duplicate values | AltHLHD | ||
Format equal to value | AltHLHE | ||
Format greater than value | AltHLHG | ||
Format less than value | AltHLHL | ||
Open rules manager | AltHLR | ||
Set color scale rule | AltHLS |
Paste Special
Shortcut | Windows | Mac | Web |
---|---|---|---|
Skip blanks | CtrlAltVB | ||
Paste comments | CtrlAltVC | ||
Paste with addition | CtrlAltVD | ||
Paste with division | CtrlAltVI | ||
Paste with multiplication | CtrlAltVM | ||
Paste data validation | CtrlAltVN | ||
Paste with subtraction | CtrlAltVS |
Data Analysis
Shortcut | Windows | Mac | Web |
---|---|---|---|
Remove duplicates | AltAM | ||
Open goal seek | AltAWG | ||
Open scenario manager | AltAWS | ||
Create data table | AltAWT | ||
Clear hyperlinks | AltHEL | ||
Fill across worksheets | AltHFIA | ||
Fill justify | AltHFIJ | ||
Copy right cell to left | AltHFIL | ||
Open series dialog | AltHFIS | ||
Copy bottom cell up | AltHFIU |
Formula Functions
Shortcut | Windows | Mac | Web |
---|---|---|---|
Calculate average | AltHUA | ||
Count numbers | AltHUC | ||
Find minimum value | AltHUI | ||
Find maximum value | AltHUM | ||
Remove formula arrows | AltMAA | ||
Trace dependents | AltMD | ||
Trace precedents | AltMP | ||
Calculate all workbooks | CtrlAltF9 | ⌘OptionF9 |
Display Options
Shortcut | Windows | Mac | Web |
---|---|---|---|
Freeze panes | AltWFF | ||
Page break preview | AltWI | ||
Normal view | AltWL | ||
Open zoom dialog | AltWQ | ||
Toggle gridlines | AltWVG | ||
Show/hide formulas | Ctrl` | ⌘` | |
Show/hide objects | Ctrl6 | ⌘6 | |
Expand/collapse ribbon | CtrlF1 | ⌘F1 |