Take the Shortcut Boot Camp Challenge

Download our free Excel Shortcut Boot Camp and become an Excel shortcut Guru with our hands-on training

Powered by ConvertKit

How to Use this Shortcut List:

+ Indicates to hold the previous key, while pressing the next key.
> Indicates to tap the previous key, releasing it before pressing the next key.

DescriptionPC ShortcutMac Shortcut
Basic Shortcuts
Save WorkbookCtrl + S + S
Save AsF12 + + S
PrintCtrl + P + P
Create New WorkbookCtrl + N + N
Open WorkbookCtrl + O + O
Open Print PreviewCtrl + F2 + P
Close WorkbookCtrl + F4 + W
Close ExcelALT + F4 + Q
Undo Previous ActionCtrl + Z + Z
Redo Previous ActionCtrl + Y + Y
Open HelpF1 + /
Clear Cell ContentsDeletefn + delete
Clear Cell FormattingAlt > H > E > F
Clear AllAlt > H > E > A
Number Formatting Shortcuts
Apply General FormatCtrl + Shift + ~^ + + ~
Apply Number FormatCtrl + Shift + !^ + + !
Apply Time FormatCtrl + Shift + @^ + + @
Apply Date FormatCtrl + Shift + #^ + + #
Apply Currency FormatCtrl + Shift + $^ + + $
Apply Percentage FormatCtrl + Shift + %^ + + %
Apply Scientific FormatCtrl + Shift + ^^ + + ^
Viewing Shortcuts
Close WindowCtrl + WorCtrl + F4 + W
Restore Window SizeCtrl + F5
Next WindowCtrl + F6
Move WindowCtrl + F7
Resize WindowCtrl + F8
Minimize WindowCtrl + F9^ + F9
Maximize / Restore WindowCtrl + F10 + F10
Next PaneF6
Previous PaneShift + F6
Full Screen ModeAlt > V > U + ^ + F
Exit Full ScreenEscesc
Rotate or Flip ScreenCtrl + Alt + n/a
Take ScreenshotPrint Screen + + 3
View Mode Shortcuts
Toggle Formula View ModeCtrl + `^ + `
Open Print PreviewCtrl + F2 + P
Expand Or Collapse RibbonCtrl + F1 + + R
Expand Or Collapse The Formula BarCtrl + Shift + U^ + + U
Copy, Cut, & Paste Shortcuts
CopyCtrl + C + C
CutCtrl + X + X
PasteCtrl + V + V
Open Paste Special Dialog BoxCTRL + Alt + Vctrl + + V
Paste ValueCTRL + ALT + V > V > Enterctrl + + V > + V > return
Paste FormatCTRL + ALT + V > T > Enterctrl + + V > + T > return
Paste & TransposeCTRL + ALT + V > E > Enterctrl + + V > + E > return
Paste & Skip BlanksCTRL + ALT + V > B > Enterctrl + + V > + B > return
Borders Shortcuts
Add Outline BorderCtrl + Shift + & + + 0
Add Or Remove Top BorderAlt > H > B > T + +
Add Or Remove Bottom BorderAlt > H > B > B + +
Add Or Remove Right BorderAlt > H > B > R + +
Add Or Remove Left BorderAlt > H > B > L + +
Remove BordersCtrl + Shift + _ + + _
Formatting Shortcuts
Open Format Cells Dialog BoxCtrl + 1 + 1
Repeat Previous FormatF4^ + Y
Toggle Bold FormattingCtrl + B + B
Toggle Italic FormattingCtrl + I + I
Toggle UnderlineCtrl + U + U
Toggle StrikethroughCtrl + 5 + + X
Apply Superscript FormattingCtrl + SHIFT + F > Alt + E
Apply Subscript FormattingCtrl + SHIFT + F > Alt + B
Wrap TextAlt > H > W
Merge CellsAlt > H > M
Align CenterAlt > H > A > C + E
Align LeftAlt > H > A > L + L
Align RightAlt > H > A > R + R
IndentAlt > H > 6^ + > Tab
Remove IndentAlt > H > 5^ + > + Tab
Increase Font SizeAlt > H > F > G + + >
Decrease Font SizeAlt > H > F > K + + <
Apply Conditional FormattingAlt > H > L
Format PainterCtrl + Alt + V
Highlight CellAlt > H > H
Fill ColorAlt > H > H
Pivot Table Shortcuts
Open Pivot Table WizardAlt > N > V + > P
Create Pivot Chart On Same WorksheetAlt + F1
Create Pivot Chart On New WorksheetF11fn + F11
Select Entire Pivot TableCtrl + A + A
Group Pivot Table ItemsAlt + Shift + + + K
Ungroup Pivot Table ItemsAlt + Shift + + + J
Hide Pivot Table ItemCtrl + -Ctrl + -
Toggle Pivot Table Field CheckboxSpaceSpace
Entering Data Shortcuts
Enter Text And Move DownEnterReturn
Enter Text And Move RightTabTab
Enter Text And Move UpShift + Enter + Return
Enter Text And Move LeftShift + Tab + Tab
Complete Entry And Stay In Same CellCtrl + Enter^ + Return
Enter Same Data In Multiple CellsCtrl + Enter^ + Return
Copy Formula From Cell AboveCtrl + '^ + '
Copy Value From Cell AboveCtrl + Shift + "^ + + "
Add HyperlinkCtrl + K + K
Insert Current DateCtrl + ;^ + ;
Insert Current TimeCtrl + Shift + :^ + + :
Display Autocomplete ListALT + +
Flash FillCtrl + E
Fill DownCtrl + D^ + D
Fill RightCtrl + R^ + R
Navigation Shortcuts
Move One Cell
Move to Edge of Data RegionCtrl + +
Move One Screen UpPgUpfn +
Move One Screen DownPgDnfn +
Move One Screen RightALT + PgDnfn + >
Move One Screen LeftALT + PgUpfn + >
Move To Beginning Of RowHomefn +
Move To First Cell In WorksheetCtrl + Homefn + ^ +
Move To Last Used Cell In WorksheetCtrl + Endfn + ^ +
Turn End Mode OnEndfn +
Creating Formula Shortcuts
Open The Insert Function Dialog BoxShift + F3fn + + F3
Cycles Through Absolute And Relative ReferencesF4 + T
Insert Function Arguments into CellCtrl + Shift + A^ + + A
Open The Insert Function Dialog Box From Within CellCtrl + A^ + A
Sum Selected CellsALT + = + + T
Calculate Part of a FormulaF9fn + F9
Create Array FormulaCtrl + Shift + Enter^ + + Return
Named Ranged Shortcuts
Open Name Manager Dialog BoxCtrl + F3^ + L
Insert Named Range Into FormulaF3n/a
Create Name Based on Row and Column HeadingsCtrl + Shift + F3^ + + F3
Calculation Shortcuts
Calculate NowF9fn + F9
Calculate Active SheetShift + F9fn + + F9
Force CalculateCtrl + ALT + F9n/a
Manual CalculationAlt > M > X > Mn/a
Turn on Automatic CalculationAlt > M > X > An/a
RefreshF9fn + F9
Autosum Selected CellsAlt + = + + T
Dialog Box Navigation Shortcuts
Toggle CheckboxSpaceSpace
Apply Changes and Close the Dialog BoxEnterReturn
Cancel Changes and Close the Dialog BoxEscEsc
Next ControlTabTab
Previous ControlShift + Tab + Tab
Next TabCtrl + Tab^ + Tab
Previous TabCtrl + Shift + Tab^ + + Tab
Spreadsheet Review Shortcuts
Toggle Formula View ModeCtrl + `^ + `
trace precedentsAlt > M > Pn/a
trace dependentsAlt > M > Dn/a
Cell Editing Shortcuts
Edit The Active CellF2^ + U
Toggle Between Cell Edit Mode and Cell Enter ModeF2^ + U
Save Changes and Exit Cell Edit ModeEnter
Cancel Entry and Exit Cell Edit ModeEscEsc
Go to Beginning of CellHomefn +
Go to End of CellEndfn +
Select CharacterShift + +
Move One Word to Right or LeftCtrl + +
Select One Word to Right or LeftCtrl + Shift + + +
Delete Character to Right of CursorDeletefn + Delete
Delete Character to the Left of CursorBackspaceDelete
Insert New Line Break Within CellALT + Enter^ + + Return
Insert Or Edit CommentShift + F2fn + + F2
Ribbon Shortcuts
Expand Or Collapse RibbonCtrl + F1 + + R
Activate Ribbon Shortcut KeysALT^ + F2
Move To Next Ribbon ControlTabTab
Activate Selected ControlSpaceSpace
Confirm Control ChangeEnterReturn
Cancel Control ChangeESCesc
Get Help On Selected ControlF1
Workbook Shortcuts
Insert New WorksheetShift + F11 + F11*
Go To Next Worksheet (Tab)Ctrl + PgDnfn + ^ +
Go To Previous Worksheet (Tab)Ctrl + PgUpfn + ^ +
Move To Next PaneF6F6
Move To Previous PaneShift + F6 + F6
Go To Next WorkbookCtrl + Tab^ + Tab
Go To Previous WorkbookCtrl + Shift + Tab^ + + Tab
Minimize Current Workbook WindowCtrl + F9 + M
Maximize Current Workbook WindowCtrl + F10n/a
Switch TabsCtrl + PgUporPgDnfn + ^ + or
Selection Shortcuts
Select Current Region (Possibly Entire Worksheet)Ctrl + A + A
Select Visible Cells OnlyALT + ; + + Z
Select Cells With CommentsCtrl + Shift + Ofn + ^ + + O
Display 'Go To' Dialog BoxCtrl + G^ + G
Select Region Directly Around Active CellCtrl + Shift + * + ^ + Space
Select Current ArrayCtrl + /^ + /
Select Row DifferencesCtrl + \^ + \
Select Column DifferencesCtrl + Shift + |^ + + |
Select All PrecedentsCtrl + Shift + {^ + + {
Select All DependentsCtrl + Shift + }^ + + }
Select Direct PrecedentsCtrl + [^ + [
Select Direct DependentsCtrl + ]^ + ]
Misc. Shortcuts
FindCtrl + F + F
Find and ReplaceCtrl + H^ + H
Find Previous MatchCtrl + Shift + F4 + fn + F
Find Next MatchShift + F4 + F
Insert ChartALT + F1fn + + F1
Insert Chart in New WorksheetF11F11*
Toggle AutofilterCtrl + Shift + L + + F
Activate FilterALT + +
Create TableCtrl + T^ + T
Open Visual Basic ( VBA ) EditorAlt + F11 + fn + F11
Open MacrosAlt + F8 + fn + F8
Stop Running MacroCtrl + Pause Break + .
Worksheet Shortcuts
Insert RowCtrl + +^ + I
Insert ColumnCtrl + +^ + I
Delete RowCtrl + -^ + -
Delete ColumnCtrl + -^ + -
Delete CellCtrl + -^ + -
Hide ColumnCtrl + 0^ + 0
Hide RowCtrl + 9^ + 9
Unhide RowCtrl + Shift + 9^ + + 9
Unhide ColumnCtrl + Shift + 0^ + + 0
Display Insert Dialog BoxCtrl + +^ + I
Display Delete Dialog BoxCtrl + -^ + -
Group Rows Or ColumnsALT + Shift + + + K
Ungroup Rows Or ColumnsALT + Shift + + + J
Select Entire RowShift + Space + Space
Select Entire ColumnCtrl + Space^ + Space
Select Entire WorksheetCtrl + A + A
Toggle Add To Selection ModeShift + F8fn + + F8
Mouse Shortcuts
Zoom In / Zoom OutCtrl + Mouse Wheel^ + Mouse Wheel
Drag And CopyCtrl + Drag + Drag
Drag And CutDragDrag
Drag And InsertShift + Drag + Drag
Drag And Insert CopyCtrl + Shift + Drag + + Drag
Drag To WorksheetALT + Drag + Drag

*Some Mac shortcuts conflict with Mac OS defaults. To use these shortcuts, Go to Apple > System Preferences > Keyboard > Shortcuts. Click Mission Control and then click to deselect the Show Desktop option.