252 Microsoft Excel Shortcut keys

Instead of relying on the mouse to access the toolbar, you can perform significant functions using Excel Shortcut keys. These shortcuts are used by individuals and organizations alike, from big companies to small firms, and even students. They facilitate tasks such as data recording and analysis, mathematical operations, and creating charts and graphs.

While the list of Excel Shortcut keys may seem extensive, becoming proficient in MS Excel requires familiarity with these shortcuts. Therefore, a downloadable PDF format of Excel Shortcut keys is available.

Most used Excel Shortcut keys

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Copy selected cellsCtrl + CCommand + C
Paste content from the clipboardCtrl + VCommand + V
Cut selected cellsCtrl + XCommand + X
Undo the last actionCtrl + ZCommand + Z
Redo the last actionCtrl + YCommand + Y
Repeat the last actionF4F4
Paste a Special dialog boxCtrl + Alt + VCommand + Option + V
Find and ReplaceCtrl + FCommand + F
Replace selectedCtrl + HCommand + H
Find the previous matchCtrl + Shift + F4Command + Shift + F4
Find next matchShift + F4Shift + F4
Create embedded chartAlt + F1Option + F1
Create a chart in the new worksheetF11F11
Open OptionsAlt, F, TOption, F, T
Open helpF1F1
Expand or collapse the ribbonCtrl + F1Command + F1
Activate access keysAltOption
Move to the next ribbon controlTabTab
Activate or open selected controlSpacebarSpacebar
Confirm control changeEnterReturn
Get help on selected controlF1F1
Open the spelling dialog boxF7F7
Open the Thesaurus dialog boxShift + F7Shift + F7
Open the Macro dialog boxAlt + F8Option + F8
Open VBA EditorAlt + F11Option + F11
Duplicate objectCtrl + DCommand + D
Snap to gridAltOption
Hide or show objectsCtrl + F6Command + F6
Display modified cell-style dialog boxAlt + ‘Option + ‘
Display right-click menuShift + F10Shift + F10
Delete commentShift + F10, DShift + F10, D
Display control menuAlt + SpacebarOption + Spacebar

File Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Create New WorkbookCtrl + NCommand + N
Open workbookCtrl + OCommand + O
Save workbookCtrl + SCommand + S
Save asF12F12
Print fileCtrl + PCommand + P
Open print preview windowCtrl + F2Command + F2
Close current workbookCtrl + F4Command + F4
Close ExcelAlt + F4Option + F4

Text Formatting Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Apply or remove bold formattingCtrl + BCommand + B
Apply or remove italic formattingCtrl + ICommand + I
Apply or Remove underscoringCtrl + UCommand + U
Apply or remove strikethrough formattingCtrl + 5Command + 5
Align centerAlt, H, A, COption, H, A, C
Align leftAlt, H, A, LOption, H, A, L
Align rightAlt, H, A, ROption, H, A, R
IndentAlt, H, 6Option, H, 6
Remove indentAlt, H, 5Option, H, 5
Increase font size one stepAlt, F, FGOption, F, FG
Decrease font size one stepAlt, H, FKOption, H, FK
Format CellsCtrl + 1Command + 1
Display Format cells with font tab selectedCtrl + Shift + FCommand + Shift + F

Number Formatting Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Apply general formatCtrl + Shift + ~Command + Shift + ~
Apply currency formatCtrl + Shift + $Command + Shift + $
Apply percentage formatCtrl + Shift + %Command + Shift + %
Apply scientific formatCtrl + Shift + ^Command + Shift + ^
Apply date formatCtrl + Shift + #Command + Shift + #
Apply time formatCtrl + Shift + @Command + Shift + @
Apply number formatCtrl + Shift + !Command + Shift + !

Filter Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Activate filterAlt + Down Arrow keyOption + Down Arrow key
Toggle AutofilterCtrl + Shift + LCommand + Shift + L
Clear slicer filterAlt + COption + C
Select the next item in the AutoFilter listDown Arrow keyDown Arrow key
Select the previous item in the AutoFilter listUp Arrow keyUp Arrow key
Close the AutoFilter list for the current columnAlt + Up Arrow keyOption + Up Arrow key
Select the first item in the AutoFilter listHome keyHome key
Select the last item in the AutoFilter listEnd keyEnd key

Active Cell Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Select active cell onlyShift + BackspaceShift + Backspace
Show the active cell on the worksheetCtrl + BackspaceCommand + Backspace
Move active cell clockwise in selectionCtrl + .Command + .
Move active cells down in the selectionEnterReturn
Move active cells up in the selectionShift + EnterShift + Return
Move active cells right in a selectionTabTab
Move active cells left in a selectionShift + TabShift + Tab

Drag and Drop Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Drag and cutDragDrag
Drag and CopyCtrl + DragCommand + Drag
Drag and insertShift + DragShift + Drag
Drag and insert a copyCtrl + Shift + DragCommand + Shift + Drag
Drag to worksheetAlt + DragOption + Drag
Drag to duplicate worksheetCtrl + DragCommand + Drag

Cell Borders Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Add or remove border-rightAlt, H, B, ROption, H, B, R
Add or remove border-leftAlt, H, B, LOption, H, B, L
Add or remove the border topAlt, H, B, TOption, H, B, T
Add or remove border-bottomAlt, H, B, BOption, H, B, B
Add or remove the border upward diagonalAlt, H, B, DOption, H, B, D
Add or remove the border horizontal interiorAlt, H, B, HOption, H, B, H
Add or remove border vertical interiorAlt, H, B, VOption, H, B, V
Add border outlineCtrl + Shift + &Command + Shift + &
Remove bordersCtrl + Shift + _Command + Shift + _

Data Entering Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
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 the same cellCtrl + EnterCommand + Return
Enter the same data in multiple cellsCtrl + EnterCommand + Return
Insert current dateCtrl + ;Command + ;
Insert current timeCtrl + Shift + :Command + Shift + :
Fill down from the cell aboveCtrl + DCommand + D
Fill right from cell leftCtrl + RCommand + R
Copy the formula from the cell aboveCtrl + `Command + `
Copy value from the cell aboveCtrl + Shift + “Command + Shift + “
Add hyperlinkCtrl + KCommand + K
Display AutoComplete listAlt + Down Arrow keyOption + Down Arrow key
Flash FillCtrl + ECommand + E

Cell Edit Mode Shortcuts

ActionMS Excel Shortcuts WindowsMS Excel Shortcuts Mac
Edit the active cellF2F2
Insert or edit the commentShift + F2Shift + F2
Cancel entryEscEsc
Select one character rightShift + Right Arrow keyShift + Right Arrow key
Select one character leftShift + Left Arrow keyShift + Left Arrow key
Move one word rightCtrl + Right Arrow keyCommand + Right Arrow key
Move one word leftCtrl + Left Arrow keyCommand + Left Arrow key
Select one word rightCtrl + Shift + Right Arrow keyCommand + Shift + Right Arrow key
Select one word leftCtrl + Shift + Left Arrow keyCommand + Shift + Left Arrow key
Select the beginning of the cellShift + HomeShift + Home
Select to end of the cellShift + EndShift + End
Delete to end of lineCtrl + DeleteCommand + Delete
Delete the character to the left of the cursorBackspaceBackspace
Delete the character to the right of the cursorDeleteDelete
Start a new line in the same cellAlt + EnterOption + Return

Dialog boxes Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Move to the next controlTabTab
Move to the previous controlShift + TabShift + Tab
Move to the next tabCtrl + TabCommand + Tab
Move to the previous tabCtrl + Shift + TabCommand + Shift + Tab
Accept and applyEnterReturn
Check and uncheck the boxSpacebarSpacebar
Cancel and close the dialogue boxEscEsc

Navigation Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Move one cell rightRight Arrow keyRight Arrow key
Move one cell leftLeft Arrow keyLeft Arrow key
Move one cell upUp Arrow keyUp Arrow key
Move one cell downDown Arrow keyDown Arrow key
Move one screen rightAlt + Page Down keyOption + Page Down key
Move one screen leftAlt + Page Up keyOption + Page Up key
Move one screen upPage Up keyPage Up key
Move one screen downPage Down keyPage Down key
Move to the right edge of the data regionCtrl + Right Arrow keyCommand + Right Arrow key
Move to the left edge of the data regionCtrl + Left Arrow keyCommand + Left Arrow key
Move to the top edge of the data regionCtrl + Up Arrow keyCommand + Up Arrow key
Move to the bottom edge of the data regionCtrl + Down Arrow keyCommand + Down Arrow key
Move to the beginning of the rowHome keyHome key
Move to the last cell in the worksheetCtrl + End keyCommand + End key
Move to the first cell in the worksheetCtrl + Home keyCommand + Home key
Turn End Mode onEnd keyEnd key

Selection Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Select entire rowShift + SpacebarShift + Spacebar
Select entire columnCtrl + SpacebarCommand + Spacebar
Select entire worksheetCtrl + ACommand + A
Add adjacent cells to the selectionShift + ClickShift + Click
Add non-adjacent cells to the selectionCtrl + ClickCommand + Click
Move right between non-adjacent selectionsCtrl + Alt + Right Arrow keyCommand + Option + Right Arrow key
Move left between non-adjacent selectionsCtrl + Alt + Left Arrow keyCommand + Option + Left Arrow key
Toggle add to selection modeShift + F8Shift + F8
Cancel selectionEscEsc

Extend Selection Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Extend selection by one cell rightShift + Right Arrow keyShift + Right Arrow key
Extend selection by one cell leftShift + Left Arrow keyShift + Left Arrow key
Extend selection by one cell upShift + Up Arrow keyShift + Up Arrow key
Extend selection by one cell downShift + Down Arrow keyShift + Down Arrow key
Extend the selection to the last cell rightCtrl + Shift + Right Arrow keyCommand + Shift + Right Arrow key
Extend the selection to the last cell leftCtrl + Shift + Left Arrow keyCommand + Shift + Left Arrow key
Extend the selection to the last cell upCtrl + Shift + Up Arrow keyCommand + Shift + Up Arrow key
Extend the selection to the last cell downCtrl + Shift + Down Arrow keyCommand + Shift + Down Arrow key
Extend selection up one screenShift + Page Up keyShift + Page Up key
Extend selection down one screenShift + Page Down keyShift + Page Down key
Extend selection right one screenAlt + Shift + Page Down keyOption + Shift + Page Down key
Extend selection left one screenAlt + Shift + Page Up keyOption + Shift + Page Up key
Extend selection to the start of the rowShift + HomeShift + Home
Extend selection to End of rowShift + EndShift + End
Extend selection to the first cell in the worksheetCtrl + Shift + HomeCommand + Shift + Home
Extend selection to the last cell in the worksheetCtrl + Shift + EndCommand + Shift + End
Toggle extend selection modeF8F8

Grid Operations Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Insert rowsCtrl + +Command + +
Delete rowsCtrl + –Command + –
Insert columnsCtrl + +Command + +
Delete columnsCtrl + –Command + –
Display Insert dialogue boxCtrl + Shift + +Command + Shift + +
Display Delete dialogue boxCtrl + –Command + –
Hide columnsCtrl + 0Command + 0
Unhide columnsCtrl + Shift + 0Command + Shift + 0
Hide rowsCtrl + 9Command + 9
Unhide rowsCtrl + Shift + 9Command + Shift + 9
Group rows or columnsAlt + Shift + Right Arrow keyOption + Shift + Right Arrow key
Ungroup rows or columnsAlt + Shift + Left Arrow keyOption + Shift + Left Arrow key
Zoom inCtrl + Alt + +Command + Option + +
Zoom outCtrl + Alt + –Command + Option + –
Open group dialogue boxAlt + Shift + Right Arrow keyOption + Shift + Right Arrow key
Open Ungroup dialogue boxAlt + Shift + Left Arrow keyOption + Shift + Left Arrow key
Hide or show outline symbolsCtrl + 8Command + 8
Delete cellsCtrl + –Command + –
Delete contents of selected cellsDeleteDelete

Workbook Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Insert new worksheetShift + F11Shift + F11
Go to the next worksheetCtrl + Page Down keyCommand + Page Down key
Go to the previous worksheetCtrl + Page Up keyCommand + Page Up key
Move to the next paneF6F6
Move to the previous paneShift + F6Shift + F6
Go to the next workbookCtrl + TabCommand + Tab
Go to the previous workbookCtrl + Shift + TabCommand + Shift + Tab
Minimize the current workbook windowCtrl + F9Command + F9
Maximize current workbook windowCtrl + F10Command + F10
Select adjacent worksheetsShift + ClickShift + Click
Select non-adjacent worksheetsCtrl + ClickCommand + Click
Toggle scroll lockScr LkScr Lk
Toggle fullscreenCtrl + Shift + F1Command + Shift + F1

Pivot Table Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Select entire pivot tablesCtrl + ACommand + A
Toggle pivot table field checkboxSpacebarSpacebar
Group pivot table itemsAlt + Shift + Right Arrow keyOption + Shift + Right Arrow key
Ungroup pivot table itemsAlt + Shift + Left Arrow keyOption + Shift + Left Arrow key
Hide pivot table itemCtrl + –Command + –
Create a pivot chart on the same worksheetAlt + F1Option + F1
Create a pivot chart on the new worksheetF11F11
Open pivot table wizardAlt, D, POption, D, P

Excel Formulas Shortcuts

ActionExcel Shortcut keys WindowsExcel Shortcut keys Mac
Autosum selected cellsAlt + =Option + =
Toggle formulas on and offCtrl + `Command + `
Insert function argumentsCtrl + Shift + ACommand + Shift + A
Enter array formulaCtrl + Shift + EnterCommand + Shift + Return
Calculate worksheetsF9F9
Calculate active worksheetShift + F9Shift + F9
Force calculates all worksheetsCtrl + Alt + F9Command + Option + F9
Evaluate part of a formulaF9F9
Expand or collapse the formula barCtrl + Shift + UCommand + Shift + U
Display function arguments dialogue boxCtrl + ACommand + A
Define nameCtrl + F3Command + F3
Define name using row and column labelsCtrl + Shift + F3Command + Shift + F3
Paste the name into a formulaF3F3
Accept function with autocompleteTabTab
Toggle absolute and relative referencesF4F4
Open the Insert function dialogue boxShift + F3Shift + F3

Excel Select Special Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Display Go To dialog boxCtrl + GCommand + G
Select cells with commentsCtrl + Shift + OCommand + Shift + O
Select the current region around the active cellCtrl + Shift + *Command + Shift + *
Select current regionCtrl + ACommand + A
Select current arrayCtrl + /Command + /
Select row differencesCtrl + \Command + \
Select column differenceCtrl + Shift + |Command + Shift + |
Select direct precedentsCtrl + [Command + [
Select direct dependentsCtrl + ]Command + ]
Select all precedentsCtrl + Shift + {Command + Shift + {
Select all dependentsCtrl + Shift + }Command + Shift + }
Select visible cells onlyAlt + ;Option + ;

Table Shortcuts

ActionExcel Shortcuts WindowsExcel Shortcuts Mac
Insert tableCtrl + TCommand + T
Select table rowShift + SpacebarShift + Spacebar
Select table columnCtrl + SpacebarCommand + Spacebar
Select tableCtrl + ACommand + A
Toggle table total rowCtrl + Shift + TCommand + Shift + T
Move to the next field which can be editedTabTab
Move to the previous field which can be editedShift + TabShift + Tab
Move to the first field in the next recordEnterReturn
Move to the first field in the previous recordShift + EnterShift + Return
Move to the same field 10 records forwardPage Down keyPage Down key
Move to the same field 10 records backPage Up keyPage Up key
Move to a new recordCtrl + Page Down keyCommand + Page Down key
Move to a first recordCtrl + Page Up keyCommand + Page Up key
Move to the beginning of a fieldHome keyHome key
Move to the end of a fieldEnd keyEnd key

Microsoft Excel remains a popular choice for data analysis despite the many alternatives available. However, if you’re looking for a free option, Google Sheets is a great alternative. Take a look at the Google Sheets Shortcuts list to streamline your workflow.

READ NEXT:

Back to top button