Become Awesome... With Shortcuts

Excel Content // Shortcut List


How Efficient Are You?

{Become Productive}


Filter table


All

25

50

75

100


Description PC MAC
Workbook
Insert new worksheetShift + F11Shift + F11
Go to next worksheetCtrl + PgDnFn + ⌃ + ↓
Go to previous worksheetCtrl + PgUpFn + ⌃ + ↑
Move to next paneF6F6
Move to previous paneShift + F6Shift + F6
Go to next workbookCtrl + Tab⌃ + Tab
Go to previous workbookCtrl + Shift + Tab⌃ + Shift + Tab
Minimize current workbook windowCtrl + F9⌘ + M
Maximize current workbook windowCtrl + F10
File
Create new workbookCtrl + N⌘ + N
Open workbookCtrl + O⌘ + o
Save workbookCtrl + S⌘ + s
Save asF12⌘ + Shift + S
Print fileCtrl + P⌘ + P
Open print preview windowCtrl + F2
Close current workbookCtrl + F4⌘ + W
Close ExcelCtrl + F4⌘ + Q
Ribbon
Expand or collapse ribbonCtrl + F1⌘ + ⌥ + R
Activate access keysAlt
Move to next ribbon controlTabTab
Activate or open selected controlSpaceSpace
Confirm control changeEnterReturn
Get help on selected controlF1
General
Open helpF1⌘ + /
Undo last actionCtrl + Z⌘ + Z
Redo last actionCtrl + Y⌘ + Y
Copy selected cellsCtrl + C⌘ + C
Cut selected cellsCtrl + X⌘ + X
Paste content from clipboardCtrl + V⌘ + V
Display the Paste Special dialog boxCtrl + Alt + V⌃ + ⌘ + V
Display find and replaceCtrl + F⌘ + F
Display find and replace, replace selectedCtrl + H⌃ + H
Find next matchShift + F4⌘ + G
Find previous matchCtrl + Shift + F4⌘ + Shift + G
Create embedded chartAlt + F1Fn + ⌥ + F1
Create chart in new worksheetF11Fn + F11
Toggle AutofilterCtrl + Shift + L⌘ + Shift + F
Activate filterAlt + ↓⌥ + ↓
Insert tableCtrl + T⌃ + T
Select tableCtrl + A⌘ + A
Drag and Drop
Drag and cutdragdrag
Drag and copyCtrl + drag⌥ + drag
Drag and insertShift + dragShift + drag
Drag and insert copyCtrl + Shift + drag⌥ + Shift + drag
Drag to worksheetAlt + drag⌘ + drag
Drag to duplicate worksheetCtrl + drag⌥ + drag
Navigation
Move one screen rightAlt + PgDnFn + ⌥ + ↑
Move one screen leftAlt + PgUpFn + ⌥ + ↓
Move to right edge of data regionCtrl + →⌃ + →
Move to left edge of data regionCtrl + ←⌃ + ←
Move to top edge of data regionCtrl + ↑⌃ + ↑
Move to bottom edge of data regionCtrl + ↓⌃ + ↓
Move to beginning of rowHomeFn + ←
Move to last cell in worksheetCtrl + EndFn + ⌃ + →
Move to first cell in worksheetCtrl + HomeFn + ⌃ + ←
Turn End mode onEndFn + →
Selection
Select entire rowShift + SpaceShift + Space
Select entire columnCtrl + Space⌃ + Space
Select entire worksheetCtrl + A⌘ + A
Add adjacent cells to selectionShift + ClickShift + Click
Add non-adjacent cells to selectionCtrl + Click⌘ + Click
Move right between non-adjacent selectionsCtrl + Alt + →⌃ + ⌥ + →
Move left between non-adjacent selectionsCtrl + Alt + ←⌃ + ⌥ + ←
Toggle add to selection modeShift + F8Fn + Shift + F8
Cancel selectionEscEsc
Active Cell
Select active cell onlyShift + BackspaceShift + Delete
Show the active cell on worksheetCtrl + Backspace⌘ + Delete
Move active cell clockwise in selectionCtrl + .⌃ + .
Move active cell down in selectionEnterReturn
Move active cell up in selectionShift + EnterShift + Return
Move active cell right in a selectionTabTab
Move active cell left in a selectionShift + TabShift + Tab
Extend Selection
Extend selection by one cell rightShift + →Shift + →
Extend selection by one cell leftShift + ←Shift + ←
Extend selection by one cell upShift + ↑Shift + ↑
Extend selection by one cell downShift + ↓Shift + ↓
Extend the selection to the last cell rightCtrl + Shift + →⌃ + Shift + →
Extend the selection to the last cell leftCtrl + Shift + ←⌃ + Shift + ←
Extend the selection to the last cell upCtrl + Shift + ↑⌃ + Shift + ↑
Extend the selection to the last cell downCtrl + Shift + ↓⌃ + Shift + ↓
Extend selection up one screenShift + PgUpFn + Shift + ↑
Extend selection down one screenShift + PgDnFn + Shift + ↓
Extend selection to start of rowShift + HomeFn + Shift + ←
Extend selection to first cell in worksheetCtrl + Shift + HomeFn + ⌃ + Shift + ←
Extend selection to last cell in worksheetCtrl + Shift + EndFn + ⌃ + Shift + →
Toggle extend selection modeF8Fn + F8
Select Special
Display 'Go To' dialog boxCtrl + G⌃ + G
Select cells with commentsCtrl + Shift + OFn + ⌃ + Shift + O
Select current region around active cellCtrl + Shift + *Shift + ⌃ + Space
Select current regionCtrl + A⌘ + A
Select current arrayCtrl + /⌃ + /
Select row differencesCtrl + \⌃ + \
Select column differencesCtrl + Shift + |⌃ + Shift + |
Select direct precedentsCtrl + [⌃ + [
Select all precedentsCtrl + Shift + {⌃ + Shift + {
Select direct dependentsCtrl + ]⌃ + ]
Select all dependentsCtrl + Shift + }⌃ + Shift + }
Select visible cells onlyAlt + ;⌘ + Shift + Z
Cell Edit Mode
Edit the active cellF2⌃ + U
Insert or edit commentShift + F2Fn + Shift + F2
Cancel entryEscEsc
Select one character rightShift + →Shift + →
Select one character leftShift + ←Shift + ←
Move one word rightCtrl + →⌃ + →
Move one word leftCtrl + ←⌃ + ←
Select one word rightCtrl + Shift + →⌃ + Shift + →
Select one word leftCtrl + Shift + ←⌃ + Shift + ←
Select to beginning of cellShift + HomeFn + Shift + ←
Select to end of cellShift + EndFn + Shift + →
Delete to end of lineCtrl + Delete⌃ + Delete
Delete character to the left of cursorBackspaceDelete
Delete character to the right of cursorDeleteFn + Delete
Start a new line in the same cellAlt + Enter⌃ + ⌥ + Return
Entering Data
Enter and move downEnterReturn
Enter and move upShift + EnterShift + Return
Enter and move rightTabTab
Enter and move leftShift + TabShift + Tab
Complete entry and stay in same cellCtrl + Enter⌃ + Return
Enter same data in multiple cellsCtrl + Enter⌃ + Return
Insert current dateCtrl + ;⌃ + ;
Insert current timeCtrl + Shift + :⌃ + Shift + :
Fill down from cell aboveCtrl + D⌃ + D
Fill right from cell leftCtrl + R⌃ + R
Copy formula from cell aboveCtrl + '⌃ + '
Copy value from cell aboveCtrl + Shift + "⌃ + Shift + "
Add hyperlinkCtrl + K⌘ + K
Display AutoComplete listAlt + ↓⌥ + ↓
Formatting
Format (almost) anythingCtrl + 1⌘ + 1
Display Format Cells with Font tab selectedCtrl + Shift + F
Apply format againF4⌃ + Y
Apply or remove bold formattingCtrl + B⌘ + B
Apply or remove italic formattingCtrl + I⌘ + I
Apply or remove underscoringCtrl + U⌘ + U
Apply or remove strikethrough formattingCtrl + 5⌘ + Shift + X
Align centerAlt + HAC⌘ + E
Align leftAlt + HAL⌘ + L
Align rightAlt + HAR⌘ + R
Number Formatting
Apply general formatCtrl + Shift + ~⌃ + Shift + ~
Apply currency formatCtrl + Shift + $⌃ + Shift + $
Apply percentage formatCtrl + Shift + %⌃ + Shift + %
Apply scientific formatCtrl + Shift + ^⌃ + Shift + ^
Apply date formatCtrl + Shift + #⌃ + Shift + #
Apply time formatCtrl + Shift + @⌃ + Shift + @
Apply number formatCtrl + Shift + !⌃ + Shift + !
Borders
Add border outlineCtrl + Shift + &⌘ + ⌥ + 0
Add or remove border rightAlt + R⌘ + ⌥ + →
Add or remove border leftAlt + L⌘ + ⌥ + ←
Add or remove border topAlt + T⌘ + ⌥ + ↑
Add or remove border bottomAlt + B⌘ + ⌥ + ↓
Add or remove border upward diagonalAlt + D
Add or remove border horizontal interiorAlt + H
Add or remove border vertical interiorAlt + V
Remove bordersCtrl + Shift + _⌘ + ⌥ + _
Formulas
Toggle absolute and relative referencesF4⌘ + T
Open the Insert Function Dialog BoxShift + F3Fn + Shift + F3
Autosum selected cellsAlt + =⌘ + Shift + T
Toggle formulas on and offCtrl + `⌃ + `
Insert function argumentsCtrl + Shift + A⌃ + Shift + A
Enter array formulaCtrl + Shift + Enter⌃ + Shift + Return
Calculate worksheetsF9Fn + F9
Calculate active worksheetShift + F9Fn + Shift + F9
Force calculate all worksheetsCtrl + Alt + F9
Evaluate part of a formulaF9Fn + F9
Expand or collapse the formula barCtrl + Shift + U⌃ + Shift + U
Display function arguments dialog boxCtrl + A⌃ + A
Define nameCtrl + F3⌃ + L
Define name using row and column labelsCtrl + Shift + F3⌃ + Shift + F3
Paste name into formulaF3
Accept function with auto completeTab↓ + Tab
Grid Operations
Insert row / column / cellCtrl + Shift +⌃ + I
Delete row / column / cellCtrl + -⌃ + -
Hide columnsCtrl + 0⌃ + 0
Hide rowsCtrl + 9⌃ + 9
Unhide rowsCtrl + Shift + 9⌃ + Shift + 9
Open Group Dialog BoxAlt + Shift + →⌘ + Shift + K
Open Ungroup Dialog BoxAlt + Shift + ←⌘ + Shift + J
Hide or show outline symbolsCtrl + 8⌃ + 8
Pivot Tables
Select entire pivot tableCtrl + A⌘ + A
Toggle pivot table field checkboxSpaceSpace
Group pivot table itemsAlt + Shift + →⌘ + Shift + K
Ungroup pivot table itemsAlt + Shift + ←⌘ + Shift + J
Hide pivot table itemCtrl + -Ctrl + -
Create pivot chart on same worksheetAlt + F1
Create pivot chart on new worksheetF11Fn + F11
Open pivot table wizardAlt + DP⌘ + ⌥ + P
Dialog boxes
Move to next controlTabTab
Move to previous controlShift + TabShift + Tab
Move to next tabCtrl + Tab⌃ + Tab
Move to previous tabCtrl + Shift + Tab⌃ + Shift + Tab
Check and uncheck boxSpaceSpace
Cancel and close the dialog boxEscEsc
Other
Open Spelling dialog boxF7F7
Open Thesaurus dialog boxShift + F7Shift + F7
Open Macro dialog boxAlt + F8Fn + ⌥ + F9
Open VBA EditorAlt + F11Fn + ⌥ + F11
Duplicate objectCtrl + D
Snap to gridAlt
Hide or show objectsCtrl + 6⌃ + 6
Display Modify Cell Style dialog boxAlt + '⌘ + Shift + L
Display shortcut menuShift + F10Fn + Shift + F10