150+ Excel shortcuts for Windows and Mac

Unlock your Excel potential with our handy guide to over 150 shortcuts for Windows and Mac OS! Easily browse through different categories to find the perfect shortcuts that will save you time and make your spreadsheet game strong.

ShortcutWindowsMac
Save as⚡F12⌘ ⇧ S
Close Excel⚡Alt F4⌘ Q
Create new worksheet⚡Shift F11⇧ F11
Delete current worksheet⚡Alt ∙ H ∙ D ∙ S⌥ ∙ H ∙ D ∙ S
Copy selection as picture⚡Alt ∙ H ∙ C ∙ P⌥ ∙ H ∙ C ∙ P
Open context menu (right click)⚡Shift F10⌃ Click
Activate access keys⚡Alt⌥
Split screen⚡Win Arrows⌃ ⌘ Arrows
Switch between open workbooks⚡Ctrl Tab⌘ Tab
Search field⚡Alt ∙ Q⌘ ⌥ Space
Extend selection to last used cell⚡Ctrl Shift Arrows⌘ ⇧ Arrows
Move to next sheet⚡Ctrl PgUp⌘ PgUp
Move to previous sheet⚡Ctrl PgDn⌘ PgDn
Scroll horizontally⚡Ctrl Shift Scroll Wheel⌘ ⇧ Scroll Wheel
Paste values only⚡Ctrl Shift V⌘ ⇧ V
Open Paste Special dialog box⚡Ctrl Alt V⌘ ⌃ V
Edit selected cell⚡F2⌃ U
Add line break in cell⚡Alt Enter⌥ ⌘ Enter
Expand selection until last used cell⚡Ctrl Shift⌘ ⇧
Select current region/worksheet⚡Ctrl A⌘ A
Delete selected range⚡Ctrl -⌘ -
Insert selected range⚡Ctrl Shift +⌘ ⇧ +
Freeze/Unfreeze Panes⚡Alt ∙ W ∙ F ∙ F⌥ ∙ W ∙ F ∙ F
Hide selected rows⚡Ctrl 0⌘ 0
Hide selected columns⚡Ctrl 9⌘ 9
Unhide selected rows⚡Alt ∙ H ∙ O ∙ U ∙ L⌥ ∙ H ∙ O ∙ U ∙ L
Unhide selected columns⚡Ctrl Shift (⌘ ⇧ (
Exclude hidden cells from selection⚡Alt ;⌥ ;
Enter current date⚡Ctrl ;⌘ ;
Toggle absolute/relative references⚡F4⌘ T
Show formulas/cell values⚡Ctrl ~⌘ `
Flash Fill⚡Ctrl E⌘ E
Insert hyperlink⚡Ctrl K⌘ K
Find & replace⚡Ctrl H⌘ H
Toggle AutoFilter⚡Ctrl Shift L⌘ ⇧ L
Display drop-down menu of selected cell⚡Alt ↓⌥ ↓
Choose Fill Color⚡Alt ∙ H ∙ H⌥ ∙ H ∙ H
Remove Fill Color⚡Alt ∙ H ∙ H ∙ N⌥ ∙ H ∙ H ∙ N
Add borders⚡Alt ∙ H ∙ B⌥ ∙ H ∙ B
Remove borders⚡Ctrl Shift _⌘ ⇧ _
Center align content⚡Alt ∙ H ∙ A ∙ C⌥ ∙ H ∙ A ∙ C
AutoFit Column Width⚡Alt ∙ H ∙ O ∙ I⌥ ∙ H ∙ O ∙ I
Create chart on new sheet⚡F11⌘ ⌥ F11
Create embedded chart⚡Alt F1⌥ F1
Insert/edit note⚡Shift F2⇧ F2
Show/hide notes⚡Alt ∙ V ∙ C⌥ ∙ V ∙ C
Pivot Table Hide selected item⚡Ctrl -⌘ ⌥ -
ShortcutWindowsMac
Open workbookCtrl + O⌘ + O
Create new workbookCtrl + N⌘ + N
Close workbookCtrl + W⌘ + W
Save workbookCtrl + S⌘ + S
Save as⚡F12⌘ + ⇧ + S
Close Excel⚡Alt + F4⌘ + Q
Create new worksheet⚡Shift + F11⇧ + F11
Rename current worksheetAlt, H, O, R⌥, H, O, R
Delete current worksheet⚡Alt, H, D, S⌥, H, D, S
Print current sheetCtrl + P⌘ + P
Copy screen to clipboardAlt + PRT SC⌘ + ⇧ + 4
Copy selection as picture⚡Alt, H, C, P⌥, H, C, P
Open context menu (right click)⚡Shift + F10⌃ + Click
Activate access keys⚡Alt⌥
Expand/collapse RibbonCtrl + F1⌘ + ⌥ + R
Toggle full screen modeCtrl + Shift + F1⌃ + ⌘ + F1
Maximize/restore windowCtrl + F10⌃ + ⌘ + F
Minimize windowCtrl + F9⌘ + M
Show all open windowsWin + Tab⌃ + ↑
Split screen⚡Win + Arrows⌃ + ⌘ + Arrows
Switch between open workbooks⚡Ctrl + Tab⌘ + Tab
SpellcheckF7⌘ + ⇧ + :
ThesaurusShift + F7⌘ + ⌃ + T
Search field⚡Alt, Q⌘ + ⌥ + Space
Go to OptionsAlt, F, O⌥, ⌘, O
ShortcutWindowsMac
Move one cell downEnterEnter
Move one cell upShift + Enter⇧ + Enter
Move one cell rightTabTab
Move one cell leftShift + Tab⇧ + Tab
Move to last used cellCtrl + Arrows⌘ + Arrows
Extend selection to last used cell⚡Ctrl + Shift +⌘ + ⇧ +
Move to next sheet⚡Ctrl + PgUp⌘ + PgUp
Move to previous sheet⚡Ctrl + PgDn⌘ + PgDn
Move one screen downPgDnPgDn
Move one screen upPgUpPgUp
Move one screen rightAlt + PgDn⌥ + PgDn
Move one screen leftAlt + PgUp⌥ + PgUp
Zoom in/outCtrl + Scroll Wheel⌘ + Scroll Wheel
Scroll horizontally⚡Ctrl + Shift + Scroll Wheel⌘ + ⇧ + Scroll Wheel
Navigate between corners of selectionCtrl + .⌘ + .
ShortcutWindowsMac
Copy selectionCtrl + C⌘ + C
Cut selectionCtrl + X⌘ + X
PasteCtrl + V⌘ + V
Paste values only⚡Ctrl + Shift + V⌘ + ⇧ + V
Open Paste Special dialog box⚡Ctrl + Alt + V⌘ + ⌃ + V
Undo last actionCtrl + Z⌘ + Z
Redo last actionCtrl + Y⌘ + ⇧ + Z
Repeat last actionF4⌘ + Y
Edit selected cell⚡F2⌃ + U
Add line break in cell⚡Alt + Enter⌥ + ⌘ + Enter
Add bullet symbol in cellAlt + 7 *NUMPAD⌥ + 8
ShortcutWindowsMac
Expand selection by a single cellShift +⇧ +
Expand selection until last used cell⚡Ctrl + Shift +⌘ + ⇧ +
Select entire rowShift + Space⇧ + Space
Select entire columnCtrl + Space⌘ + Space
Select current region/worksheet⚡Ctrl + A⌘ + A
Delete selected range⚡Ctrl + -⌘ + -
Insert selected range⚡Ctrl + Shift + +⌘ + ⇧ + +
Freeze/Unfreeze Panes⚡Alt, W, F, F⌥, W, F, F
Hide selected rows⚡Ctrl + 0⌘ + 0
Hide selected columns⚡Ctrl + 9⌘ + 9
Unhide selected rows⚡Alt, H, O, U, L⌥, H, O, U, L
Unhide selected columns⚡Ctrl + Shift + (⌘ + ⇧ + (
Exclude hidden cells from selection⚡Alt + ;⌥ + ;
ShortcutWindowsMac
Enter current date⚡Ctrl + ;⌘ + ;
Enter current timeCtrl + Shift + ;⌘ + ⇧ + ;
Expand/collapse formula barCtrl + Shift + U⌘ + ⌥ + U
Toggle absolute/relative references⚡F4⌘ + T
Show formulas/cell values⚡Ctrl + ~⌘ + `
Select precedents of selectionCtrl + [⌘ + [
Select all precedentsCtrl + Shift + [⌘ + ⇧ + [
Select dependents of selectionCtrl + ]⌘ + ]
Select all dependentsCtrl + Shift + ]⌘ + ⇧ + ]
Trace precedents of selectionAlt, M, P⌥, ⌘, P
Trace dependents of selectionAlt, M, D⌥, ⌘, D
Clear tracing arrowsAlt, M, A, A⌥, ⌘, A, A
Fill content from top cell (Fill Down)Ctrl + D⌘ + D
Copy value from cell aboveCtrl + Shift + "⌘ + ⇧ + "
Fill content from left cell (Fill Right)Ctrl + R⌘ + R
Flash Fill⚡Ctrl + E⌘ + E
Insert AutoSum formulaAlt + =⌥ + =
Insert AutoSumAlt, H, U, S⌥, H, U, S
Insert AutoAverageAlt, H, U, A⌥, H, U, A
Insert AutoCountAlt, H, U, C⌥, H, U, C
Insert AutoMaxAlt, H, U, M⌥, H, U, M
Insert AutoMinAlt, H, U, I⌥, H, U, I
Insert functionShift + F3⇧ + F3
Insert hyperlink⚡Ctrl + K⌘ + K
ShortcutWindowsMac
FindCtrl + F⌘ + F
Find & replace⚡Ctrl + H⌘ + H
Find next matching entryCtrl + Shift + F4⌘ + ⇧ + ⌥ + F4
Find previous matching entryShift + F4⌘ + ⌥ + F4
Define name for selected rangeAlt, M, M, D⌥, ⌘, M, D
Display Name ManagerCtrl + F3⌘ + F3
Open Go To dialog boxCtrl + G⌘ + G
Toggle AutoFilter⚡Ctrl + Shift + L⌘ + ⇧ + L
Display drop-down menu of selected cell⚡Alt + ↓⌥ + ↓
Open Data Validation dialog boxAlt, D, L⌥, D, L
Open Macro dialog boxAlt + F8⌥ + F8
Open VBA EditorAlt + F11⌥ + F11
Open Power Query EditorAlt + F12⌥ + F12
Refresh external dataCtrl + Alt + F5⌘ + ⌥ + R
ShortcutWindowsMac
Choose Fill Color⚡Alt H, H⌥ + H, H
Remove Fill Color⚡Alt H, H, N⌥ + H, H, N
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 + ^⌘ + ⇧ + ^
Add borders⚡Alt, H, B⌥, H, B
Add outline bordersCtrl + Shift + &⌘ + ⌥ + ⇧ + &
Remove borders⚡Ctrl + Shift + _⌘ + ⇧ + _
Apply bold formattingCtrl + B⌘ + B
Apply italicCtrl + I⌘ + I
Apply underlineCtrl + U⌘ + U
Apply strikethroughCtrl + 5⌘ + ⇧ + X
Center align content⚡Alt, H, A, C⌥, H, A, C
AutoFit Row HeightAlt, H, O, A⌥, H, O, A
Adjust row heightAlt, H, O, H⌥, H, O, H
AutoFit Column Width⚡Alt, H, O, I⌥, H, O, I
Adjust column widthAlt, H, O, W⌥, H, O, W
Open Format Cells dialogCtrl + 1⌘ + 1
Format fonts via dialogCtrl + Shift + F⌘ + ⇧ + F
Display Conditional Formatting Rules ManagerAlt, O, D⌥, O, D
ShortcutWindowsMac
Create a tableCtrl + T⌘ + T
Create chart on new sheet⚡F11⌘ + ⌥ + F11
Create embedded chart⚡Alt + F1⌥ + F1
Navigate through floating objectsCtrl + Alt + 5, Tab⌘ + ⌥ + 5, Tab
Insert/edit note⚡Shift + F2⇧ + F2
Delete noteShift + F10, T⇧ + F10, T
Show/hide notes⚡Alt, V, C⌥, V, C
Show/hide objectsCtrl + 6⌘ + 6
ShortcutWindowsMac
Create a Pivot TableAlt, N, V⌥ + ⌘ + P
Open the PivotTable OptionsAlt, J, T, O⌃ + ⌥ + P
Refresh Pivot TableAlt + F5⌘ + R
Hide selected item⚡Ctrl + -⌘ + ⌥ + -
Group selected itemsAlt + Shift + →⌘ + Shift + K
Ungroup selected itemsAlt + Shift + ←⌘ + Shift + J
Change Pivot Table Field SettingsRight-click on field > Value Field Settings⌃ + Click on field > Value Field Settings
Move Pivot TableCtrl + X, then Ctrl + V⌘ + X, then ⌘ + V
Change LayoutAlt, J, T, L⌃ + ⌥ + L
Remove Pivot Table FieldRight-click on field > Remove⌃ + Click on field > Remove
Expand Pivot Table GroupAlt + Shift + +⌘ + ⌥ + +
Collapse Pivot Table GroupAlt + Shift + -⌘ + ⌥ + -