Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.

Excel Formulas | Power Query | Macros | Excel Errors | Excel Videos

Before jumping onto each excel shortcuts, let us clarify what does keys for mac represent in case if you have moved to mac in recent times otherwise please ignore the following and go straight to the excel shortcuts mentioned below.

Mac Keys Used in Excel Shortcuts;

⌘ is the Command () key

⌃ is the Control key

⌥ is the Option (alt) key

⇧ is the Shift key

⇪ is the Caps Lock key

fn is the Function key

EXCEL SHORTCUTS LIST

ShortcutWindowsMac
Repeat last actionShift + F4 or Ctrl + YLooped square + Y
Define name using row and column labelsCtrl + Shift + F3No alternative/ shortcut for mac.
Open Spelling dialog boxShift + F7Fn (Function key) + F7
Hide or show outline symbolsCtrl + 8˄ + 8
Add or remove border leftAlt + LLooped square + Option key + ← (left arrow)
Expand or collapse the formula barCtrl + Shift + U˄ +⇧ + U
Add or remove border vertical interiorAlt + VNo alternative/ shortcut for mac.
Fill right from cell leftCtrl + R˄ + R
Extend selection by one cell downShift + ↓+ ↓
Display Format Cells with Font tab selectedCtrl + Shift + F˄ + ⇧+ F
Extend selection right one screenAlt + Shift + PgDnFn + ⇧+ Looped sqauare + ↓
Add or remove border rightAlt + R⌘ Looped square + ⌥ (option key) + →
Extend selection to first cell in worksheetCtrl + Shift + HomeFn + ˄ + ⇧+ ←
Move one word rightCtrl + →⌃ + →
Apply or remove italic formattingCtrl + I⌘ + I
Toggle scroll lockScrLkFn +⇧ + F14
Extend selection left one screenAlt + Shift + PgUpFn +⇧ + ⌘ +
Hide columnsCtrl + 0⌃ + 0
Add or remove border upward diagonalAlt + DNo alternative/ shortcut for mac.
Extend the selection to the last cell upCtrl + Shift + ↑⌃ +⇧ + ↑
Add or remove border horizontal interiorAlt + HNo alternative/ shortcut for mac.
Remove bordersCtrl + Shift + _⌘ + ⌥ + _
Maximize current workbook windowCtrl + F10Fn + ⌃ + F10
Select all precedentsCtrl + Shift +⌃ +⇧ + {
Move to next paneShift + F6Fn + F6
Select entire pivot tableCtrl + A⌘ + A
Check and uncheck boxFirst select the checkbox, Tab or Shift + SpaceFirst select the checkbox, Tab or Shift + Space
Accept function with autocompleteTab or shift + tab↓ + Tab
Extend the selection to the last cell rightCtrl + Shift + →⌃ +⇧ + →
Unhide rowsCtrl + Shift + 9⌃ + ⇧+ 9
Apply number formatCtrl + Shift + !⌃ +⇧ + !
Move one cell down
Move one screen upPgUpFn + ↑
Move to previous tabCtrl + Shift + Tab⌃ +⇧ + Tab
Cut selected cellsCtrl + X⌘ + X
Duplicate objectCtrl + D⌘ + D
Open pivot table wizardAlt + D + P⌘ + ⌥ + P
Toggle full screenCtrl + Shift + F1⌃ + ⌘ + F
Extend the selection to the last cell leftCtrl + Shift +←⌃ +⇧ + ←
Select column differencesCtrl + Shift + |⌃ +⇧ +|
Move to bottom edge of data regionCtrl + ↓⌃ + ↓
Insert current dateCtrl + ;⌃ + ;
Move active cell up in selectionShift + Enter+ Return
Add border outlineCtrl + Shift + &⌘ + ⌥ + 0
Extend selection down one screenShift + PgDnFn + ⇧+ ↓
Print fileCtrl + P⌘ + P
Move to previous paneShift + F6Fn +⇧ + F6
Save workbookCtrl + S⌘ + S
Open optionsAlt + F + T⌘ + ,
Move to next tabCtrl + Tab⌃ + Tab
Display the Paste Special dialog boxCtrl + Alt + V⌃ +⌘ + V
Get help on selected controlShift + F1No alternative/ shortcut for mac.
Copy selected cellsCtrl + C ⌘ + C
Evaluate part of a formulaShift + F9Fn + F9
Add adjacent cells to selectionShift + Click+ Click
Remove indentAlt + H + 5⌃ + ⌥ + ⇧ + Tab
Apply currency formatCtrl + Shift + $⌃ +⇧ + $
Move one word leftCtrl + ←⌃ + ←
Move one screen downPgDnFn + ↓
Add or remove the shadow font styleNo alternative/ shortcut for windows.⌘ +⇧ + W
Extend the selection to the last cell downCtrl + Shift + ↓⌃ +⇧ + ↓
Force calculate all worksheetsCtrl + Alt + F9N/A
Align leftAlt + H + A + L⌘ + L
Unhide columnsCtrl + Shift + 0⌃ + ⇧+ 0
Create chart in new worksheetShift + F11Fn + F11
Create new workbookCtrl + N⌘ + N
Create pivot chart on same worksheetAlt + F1No alternative/ shortcut for mac.
Move one cell up
Extend selection to start of rowShift + HomeFn + ⇧ + ←
Go to next worksheetCtrl + PgDnFn + ⌃ + ↓
Select all dependentsCtrl + Shift + }⌃ +⇧ + }
Flash fillCtrl + EN/A
Extend selection to last cell in worksheetCtrl + Shift + EndFn + ⌃ + ⇧+ →
Display right-click menuShift + F10Fn +⇧ + F10
Turn End mode onEnd (or Shift + End)Fn + →
Enter and move downEnterReturn
Select direct dependentsCtrl + ]⌃ + ]
Apply or remove underscoringCtrl + U⌘ + U
Increase font size one stepAlt + H + FG⌘ +⇧ + >
Select current region around active cellCtrl + Shift + *+ ⌃ + Space
Display find and replace
Ctrl + F
⌘ + F
Define nameCtrl + F3Fn + ⌃ + F3
Move left between non-adjacent selectionsCtrl + Alt + ←⌃ + ⌥ + ←
Show the active cell on worksheetCtrl + Backspace⌘ + Delete
Apply or remove strikethrough formattingCtrl + 5⌘ + ⇧+ X
Toggle AutofilterCtrl + Shift + L⌘ + ⇧ + F
Activate access keysAlt or Shift + F10No shortcut/ alternative for mac.
Toggle add to selection modeShift + F8Fn + ⇧ + F8
Expand or collapse ribbonCtrl + F1⌘ + ⌥ + R
Enter array formulaCtrl + Shift + Enter⌃ + ⇧ + Return
Insert columnsCtrl + Shift + +⌘ + ⇧ + +
Close ExcelAlt + F4⌘ + Q
Clear slicer filterAlt + C⌥ + C
Cancel entryEscEsc
Find next matchShift + F4⌘ + G
Group rows or columnsAlt + Shift + →⌘ + ⇧ + K
Drag and insertShift + drag+ drag
Extend selection up one screenShift + PgUpFn + ⇧ + ↑
Insert rowsCtrl + Shift + +⌘ + ⇧ + +
Delete commentShift + F10 + DFn + Shift + F10
Select table columnCtrl + Space⌃ + Space
Calculate worksheetsShift + F9Fn + F9
Go back to hyperlinkCtrl + G Enter⌃ + G + Return
Copy formula from cell aboveCtrl + ‘⌃ + ‘
Move to previous controlShift + Tab+ Tab
Move to first cell in worksheetCtrl + HomeFn + ⌃ + ←
Find previous matchCtrl + Shift + F4⌘ + ⇧ + G
Select visible cells onlyAlt + ;⌘ + ⇧ + Z
Select table rowShift + Space+ Space
Move to top edge of data regionCtrl + ↑⌃ +↑
Display Insert Dialog boxCtrl + Shift + +⌘ + ⇧ + +
Activate or open selected controlSpaceSpace
Display Modify Cell Style dialog boxAlt + ‘⌘ +⇧ + L
Add or remove border bottomAlt + B⌘ + ⌥ + ↓
Paste content from clipboardCtrl + V⌘ + V
Complete entry and stay in same cellCtrl + Enter⌃ + Return
Move to next controlTabTab
Display function arguments dialog boxCtrl + A⌃ + A
Drag to worksheetAlt + drag⌘ + drag
Extend selection by one cell rightShift + →+ →
Select entire rowShift + Space+ Space
Insert tableCtrl + T⌃ + T
Select one word leftCtrl + Shift + ←⌃ + ⇧ + ←
Toggle formulas on and offCtrl + `⌃ + `
Open workbookCtrl + O ⌘ + O
Display Delete dialog boxCtrl + –⌘ + –
Ungroup pivot table itemsAlt + Shift + ←⌘ +⇧ + J
Select one word leftCtrl + Shift + ←⌃ + + ←
Edit the active cellShift + F2⌃ + U
Delete contents of selected cellsDeleteFn + Delete
Insert or edit commentShift +F2Fn +⇧ + F2
Move one cell left
Enter and move upShift + Enter+ Return
Select cells with commentsCtrl + Shift + OFn + ^ +⇧ + O
Display ‘Go To’ dialog boxCtrl + G^ + G
Apply or remove bold formattingCtrl + B⌘ + B
Move active cell down in selectionEnterReturn
Move active cell down in selectionAlt + Shift + →⌘ + ⇧ + K
Align rightAlt + H + A + R⌘ + R
Decrease font size one stepAlt + H + FK⌘ + ⇧ + <
Toggle extend selection modeShift + F8Fn + F8
Move active cell left in a selectionShift + Tab+ Tab
Zoom inCtrl + Alt + +⌥ + ⌘ + +
Delete to end of lineCtrl + Delete^ + Delete
Display AutoComplete listAlt + ↓⌥ + ↓
Open Ungroup Dialog BoxAlt + Shift + ←⌘ + ⇧ + J
Select current arrayCtrl + /^ + /
Add or remove the outline font styleNo shortcut/alternative for windows.⌘ +⇧ + D
Extend selection by one cell upShift + ↑+ ↑
Open helpShift + F1⌘ + /
Select adjacent worksheetsShift + Click+ Click
Ungroup rows or columnsAlt + Shift + ←⌘ + ⇧ + J
Hide pivot table itemCtrl + –Ctrl + –
Drag and cutdragdrag
Create embedded chartAlt + F1Fn + ⌥ + F1
Select one word rightCtrl + Shift + →⌃ + ⇧ + →
Open print preview windowCtrl + F2N/A
Apply general formatCtrl + Shift + ~^ + ⇧ + ~
Delete character to the left of cursorBackspace Delete
Redo last actionCtrl + Y⌘ + Y
Toggle absolute and relative referencesShift + F4⌘ + T
Move active cell right in a selectionTabTab
Same selection in previous columnN/A⌥ +⇧ + Tab
Calculate active worksheetShift + F9Fn + ⇧ + F9
Drag and insert copyCtrl + Shift + drag⌥ + ⇧ + drag
Add non-adjacent cells to selectionCtrl + Click⌘ + Click
Delete columnsCtrl + –⌘ + –
Apply date formatCtrl + Shift + #^ + ⇧ + #
Select one character rightShift + →+ →
Move to last cell in worksheetCtrl + EndFn + ^ + →
Display find and replace, replace selectedCtrl + H^ + H
Move to right edge of data regionCtrl + →^ + →
Apply scientific formatCtrl + Shift + ^^ + ⇧ + ^
Select non-adjacent worksheetsCtrl + Click⌘ + Click
Apply time formatCtrl + Shift + @⌃ + ⇧ + @
Save asShift + F12⌘ + ⇧ + S
Close current workbookCtrl + F4⌘ + W
Select row differencesCtrl + /^ + /
Autosum selected cellsAlt + =⌘ + ⇧ + T
Snap to gridAlt
Toggle table total rowCtrl + Shift + T⌘ + ⇧ + T
Select to end of cellShift + EndFn + ⇧ + →
Format (almost) anythingCtrl + 1⌘ + 1
Extend selection by one cell leftShift + ←+ ←
Select entire worksheetCtrl + A⌘ + A
Toggle pivot table field checkboxSpaceSpace
Go to next workbookCtrl + Tab^ + Tab
Go to next workbookTabTab
Move one cell right
IndentAlt + PgDnFn + ⌥ + ↓
Hide or show objectsCtrl + 6^ + 6
Enter same data in multiple cellsCtrl + Enter^ + Return
Hide rowsCtrl + 9^ + 9
Open VBA EditorAlt + F11Fn + ⌥ + F11
Zoom outCtrl + Alt + –⌥ + ⌘ + –
Select active cell onlyShift + Backspace+ Delete
Copy value from cell aboveCtrl + Shift + “^ + ⇧ + “
Move active cell clockwise in selectionCtrl + .^ + .
Cancel and close the dialog boxEscEsc
Select entire columnCtrl + Space^ + Space
Activate filterAlt + ↓⌥ + ↓
Create pivot chart on new worksheetShift + F11Fn + F11
Add hyperlinkCtrl + K⌘ + K
Select current regionCtrl + A⌘ + A
Insert function argumentsCtrl + Shift + A^ + ⇧ + A
Open Macro dialog boxAlt + F8Fn + ⌥ + F8
Open Group Dialog BoxAlt + Shift + →⌘ + ⇧ + K
Accept and applyEnterReturn
Drag to duplicate worksheetCtrl + drag⌥ + drag
Select one character leftShift + ←+ ←
Confirm control changeEnter Return
Same selection in next columnN/A⌥ + Tab
Move to left edge of data regionCtrl + ←⌃ + ←
Undo last actionCtrl + Z⌘ + Z
Fill down from cell aboveCtrl + D^ + D
Select one character leftShift + ←+ ←
Align centerAlt + H + A + C⌘ + E
Select direct precedentsCtrl + [^ + [
Paste name into formulaF3N/A
Apply percentage formatCtrl + Shift + %^ + ⇧ + %
Insert current timeCtrl + Shift + :⌘ + ;
Start a new line in the same cellAlt + Enter⌃ + ⌥ + Return
Move to beginning of rowHomeFn + ←
Display control menuAlt + Space?
Drag and copyCtrl + drag⌥ + drag
Move one screen leftAlt + PgUpFn + ⌥ + ↑
Open Thesaurus dialog boxShift + F7Fn + ⇧ + F7
Minimize current workbook windowCtrl + F9⌘ + M
Add or remove border topAlt + T⌘ + ⌥ + ↑
Select tableCtrl + A⌘ + A
Go to previous worksheetCtrl + PgUpFn + ^ + ↑
Insert new worksheetShift + F11Fn + ⇧ + F11
Enter and move leftShift + Tab     + Tab
Delete character to the right of cursorDeleteFn + Delete
Delete cellsCtrl + –⌘ + –
Move to next ribbon controlTabTab
Cancel selectionEscEsc
Move right between non-adjacent selectionsCtrl + Alt + →^ + ⌥ + →
Go to previous workbookCtrl + Shift + Tab^ + ⇧ + Tab
Delete rowsCtrl + –⌘ + –
Excel Shortcut Table

Print Excel shortcuts by entering CTRL + P on your keyboard and select ‘save as’ PDF which let you save it on your drive.

EXCEL SHORTCUTS

If you still