Excel Keyboard Shortcuts List that You Should Know in 2022 | MS Excel Shortcut Keys Chart

There is nothing to deny the fact that all of us look for smarter alternatives to do our work these days. If you are using Microsoft Excel and looking for some great alternatives then this guide is for you. Here, we have jotted down the Most Useful Excel Keyboard Shortcuts that you should definitely consider in your work. You need not remember all of them at once and you can always look up to us for Keyboard Shortcuts in Excel. Start using these MS Excel Shortcut Keys PDF 2022 and see the difference.

Cells, Ranges, Rows, & Columns

We have listed the Advanced Excel Shortcut Keys depending on different categories. Use them and make your work-life way easier and quicker.

Navigating The Grid

ShortcutWindowsMacWeb
Select the first visible cell in the sheet (or bottom-right of freeze panes)Ctrl+HomeFn+Ctrl+←Ctrl+Home
Select the last used cell in the sheetCtrl+EndFn+Ctrl+→Ctrl+End
Select first cell in the row of the active cellHomeFn+←Home
Turn on End Mode (similar to Ctrl+Arrow Keys)EndFn+→End
Select the first/last cell of a region (non-blank cells) moving upCtrl+↑Ctrl+↑Ctrl+↑
Select the first/last cell of a region (non-blank cells) moving rightCtrl+→Ctrl+→Ctrl+→
Select the first/last cell of a region (non-blank cells) moving downCtrl+↓Ctrl+↓Ctrl+↓
Select the first/last cell of a region (non-blank cells) moving leftCtrl+←Ctrl+←Ctrl+←
Select cell one screen down from the active cellPgDnFn+↓PgDn
Select cell one screen up from the active cellPgUpFn+↑PgUp
Select cell one screen to the right of the active cellAlt+PgDnFn+Alt+↓
Select cell one screen to the left of the active cellAlt+PgUpFn+Alt+↑
Move one cell up
Move one cell right
Move one cell down
Move one cell left
Go back to hyperlinkCtrl+G,EnterCtrl+G,Return
Open the Find windowCtrl+FCmd+FCtrl+F
Open the Find & Replace windowCtrl+HCtrl+HCtrl+H
Find next matchShift+F4Cmd+GShift+F4
Find previous matchCtrl+Shift+F4Cmd+Shift+GCtrl+Shift+F4

Writing Formulas

Begin entering a formula= OR += OR += OR +
Insert function into formula with autocompleteTab↓TabTab
Edit the active cellF2Ctrl+UF2
Toggle Enter and Edit modes while editing formulaF2Ctrl+UF2
Exit cell edit modeEscEscEsc
Toggle absolute and relative referencesF4Cmd+TF4
AutoSumAlt+=Cmd+Shift+TAlt+=
Open Function Arguments window (when text cursor is inside function)Ctrl+ACtrl+A
Open the Insert Function windowShift+F3Fn+Shift+F3Shift+F3
Show Formulas instead of Values in cells (toggle)Ctrl+` or Ctrl+~Ctrl+`
Expand or collapse the formula barCtrl+Shift+UCtrl+Shift+U
Calculate worksheetsF9Fn+F9F9
Calculate active worksheetShift+F9Fn+Shift+F9
Calculate entire workbookCtrl+Alt+F9Ctrl+Shift+Alt+F9
Insert name into formulaF3
Open Name Manager windowCtrl+F3Fn+Ctrl+F3
Open Create Names From Selection windowCtrl+Shift+F3Fn+Ctrl+Shift+F3
Set focus on Name BoxAlt+F3
Enter array formulaCtrl+Shift+EnterCtrl+Shift+Return
Evaluate selected text in a formulaF9Fn+F9F9
Insert function argumentsCtrl+Shift+ACtrl+Shift+ACtrl+Shift+A

Entering Data

ShortcutWindowsMacWeb
Open AutoComplete dropdown listAlt+↓Alt+↓Alt+↓
Enter and move to next cell (based on direction set in Excel Options)EnterReturnEnter
Enter and move to previous cell (based on direction set in Excel Options)Shift+EnterShift+ReturnShift+Enter
Enter and move rightTabTabTab
Enter and move leftShift+TabShift+TabShift+Tab
Insert current dateCtrl+;Ctrl+;Ctrl+;
Insert current timeCtrl+Shift+:Cmd+;
Copy formula from cell aboveCtrl+’Ctrl+’Ctrl+’
Fill down from cell aboveCtrl+DCtrl+D
Fill rightCtrl+RCtrl+R
Flash fillCtrl+ECtrl+E
Stay in same cell when editing cell when single cell is selectedCtrl+EnterCtrl+ReturnCtrl+Enter
Copy data or formula to all selected cells when editing cellCtrl+EnterCtrl+ReturnCtrl+Enter
Copy value (result of formula) from cell aboveCtrl+Shift+”Ctrl+Shift+”

Editing Text

ShortcutWindowsMacWeb
Enter a line break (new line) in a cellAlt+EnterCtrl+Alt+ReturnAlt+Enter
Delete character to the left of cursorBackspaceDeleteBackspace
Delete character to the right of cursorDeleteFn+DeleteDelete
Delete to end of lineCtrl+DeleteCtrl+DeleteCtrl+Delete
Move text cursor one word to the rightCtrl+→Ctrl+→Ctrl+→
Move text cursor one word to the leftCtrl+←Ctrl+←Ctrl+←
Select one word rightCtrl+Shift+→Ctrl+Shift+→Ctrl+Shift+→
Select one word leftCtrl+Shift+←Ctrl+Shift+←Ctrl+Shift+←
Select one character rightShift+→Shift+→Shift+→
Select one character leftShift+←Shift+←Shift+←
Select to beginning of cellShift+HomeFn+Shift+←Shift+Home
Select to end of the text/formulaShift+EndFn+Shift+→Shift+End

Number Formatting

ShortcutWindowsMacWeb
Apply General format to selected cellsCtrl+Shift+~Ctrl+Shift+~
Apply Number format to selected cellsCtrl+Shift+!Ctrl+Shift+!
Apply Date format to selected cellsCtrl+Shift+#Ctrl+Shift+#
Apply Currency format to selected cellsCtrl+Shift+$Ctrl+Shift+$
Apply Percent format/style to selected cellsCtrl+Shift+%Ctrl+Shift+%
Apply Time format to selected cellsCtrl+Shift+@Ctrl+Shift+@
Apply Scientific format to selected cellsCtrl+Shift+^Ctrl+Shift+^
Modify Cell Style of the active cellAlt+’Cmd+Shift+L

Cell & Font Formatting

ShortcutWindowsMacWeb
Remove indentAlt,H,5Ctrl+Alt+Shift+Tab
IndentAlt,H,6Ctrl+Alt+Tab
Left AlignAlt,H,A,LCmd+L
Center AlignAlt,H,A,CCmd+E
Right AlignAlt,H,A,RCmd+R
Top AlignAlt,H,A,T
Middle AlignAlt,H,A,M
Bottom AlignAlt,H,A,B
Increase Font SizeAlt,H,F,GCmd+Shift+>Ctrl+Shift+>
Decrease Font SizeAlt,H,F,KCmd+Shift+<Ctrl+Shift+<
Wrap TextAlt,H,W
Format Window for cells and objectsCtrl+1Cmd+1Ctrl+1
Apply or remove bold formattingCtrl+BCmd+BCtrl+B
Apply or remove italic formattingCtrl+ICmd+ICtrl+I
Apply or remove underscoringCtrl+UCmd+UCtrl+U
Apply or remove strikethrough formattingCtrl+5Cmd+Shift+X
Display Format Cells with Font tab selectedCtrl+Shift+FCtrl+Shift+F
Insert or edit Cell NoteShift+F2Fn+Shift+F2
Insert or reply to Cell CommentCtrl+Shift+F2Fn+Ctrl+Shift+F2Shift+F2
Delete commentShift+F10,M
Add hyperlinkCtrl+KCmd+KCtrl+K

Rows & Columns

ShortcutWindowsMacWeb
Select all cells in worksheet (unless active cell is in a Table)Ctrl+ACmd+A
Select entire rowShift+SpaceShift+SpaceShift+Space
Select entire columnCtrl+SpaceCtrl+SpaceCtrl+Space
Add non-adjacent cells to selectionCtrl+ClickCmd+Click
Add adjacent cells to selectionShift+ClickShift+Click
Toggle Add or Remove Selection ModeShift+F8Fn+Shift+F8Shift+F8
Same selection in next columnOpt+Tab
Same selection in previous columnOpt+Shift+Tab
Move right between non-adjacent selectionsCtrl+Alt+→
Move left between non-adjacent selectionsCtrl+Alt+←
Open Insert windowCtrl++Ctrl++
Insert rows (with rows selected)Ctrl++Ctrl++
Insert columns (with columns selected)Ctrl++Ctrl++
Open Delete windowCtrl+-Cmd+-Ctrl+-
Delete rows (with rows selected)Ctrl+-Cmd+-Ctrl+-
Delete columns (with columns selected)Ctrl+-Cmd+-Ctrl+-
Delete cells (with cells selected)Ctrl+-Cmd+-Ctrl+-
AutoFit Column WidthAlt,H,O,IAlt,H,O,I
AutoFit Row HeightAlt,H,O,AAlt,H,O,A

Group & Hide

ShortcutWindowsMacWeb
Group rows or columns (with rows/columns selected)Shift+Alt+→Cmd+Shift+K
Ungroup rows or columns (with rows/columns selected)Shift+Alt+←Cmd+Shift+J
Open Group window (with cell or range selected)Shift+Alt+→Cmd+Shift+K
Open Ungroup window (with cell or range selected)Shift+Alt+←Cmd+Shift+J
Hide or show outline symbolsCtrl+8Ctrl+8
Hide rowsCtrl+9Ctrl+9Ctrl+9
Hide columnsCtrl+0Ctrl+0Ctrl+0
Unhide rowsCtrl+Shift+9Ctrl+Shift+9Ctrl+Shift+9
Unhide columnsCtrl+Shift+0Ctrl+Shift+0Ctrl+Shift+0
Unhide columns (Alternate: Ctrl+Shift+0 does not work on some versions of Windows)Alt,H,O,U,L

Active Cell

ShortcutWindowsMacWeb
Activate next cell in selected range (based on direction set in Excel Options)EnterReturnEnter
Activate next cell to right/below in selected rangeTabTabTab
Activate each corner cell in selected range in clockwise directionCtrl+.Ctrl+.Ctrl+.
Activate previous cell in selection (based on direction set in Excel Options)Shift+EnterShift+ReturnShift+Enter
Activate previous cell to left/above in selected rangeShift+TabShift+TabShift+Tab
Scroll active cell into viewCtrl+BackspaceCmd+DeleteCtrl+Backspace
Select single (active) cell when range is selectedShift+BackspaceShift+DeleteShift+Backspace

Extend Selection

ShortcutWindowsMacWeb
Extend selection by one cell upShift+↑Shift+↑
Extend selection by one cell rightShift+→Shift+→Shift+→
Extend selection by one cell downShift+↓Shift+↓
Extend selection by one cell leftShift+←Shift+←Shift+←
Extend the selection to the last cell upCtrl+Shift+↑Ctrl+Shift+↑
Extend the selection to the last cell rightCtrl+Shift+→Ctrl+Shift+→
Extend the selection to the last cell downCtrl+Shift+↓Ctrl+Shift+↓
Extend the selection to the last cell leftCtrl+Shift+←Ctrl+Shift+←
Extend selection to first cell in worksheetCtrl+Shift+HomeFn+Ctrl+Shift+←Ctrl+Shift+Home
Extend selection to last cell in worksheetCtrl+Shift+EndFn+Ctrl+Shift+→Ctrl+Shift+End
Extend selection right one screenShift+Alt+PgDnFn+Shift+Alt+↓
Extend selection left one screenShift+Alt+PgUpFn+Shift+Alt+↑
Extend selection to start of rowShift+HomeFn+Shift+←Shift+Home
Extend selection down one screenShift+PgDnFn+Shift+↓
Extend selection up one screenShift+PgUpFn+Shift+↑
Toggle extend selection modeF8Fn+F8
Select Spill RangeCtrl+A

Select Special Cells

ShortcutWindowsMacWeb
Open the Go To windowF5 OR Ctrl+GCtrl+GCtrl+G
Open the Go To Special windowAlt,H,F,D,S OR F5,Alt,S
Select visible cells only (when range is selected)Alt+;Cmd+Shift+Z
Select current regionCtrl+ACmd+A
Select current region around active cellCtrl+Shift+8Shift+Ctrl+Space
Select current arrayCtrl+/Ctrl+/
Select row differencesCtrl+Ctrl+
Select column differencesCtrl+Shift+Ctrl+Shift+
Select direct dependentsCtrl+]Ctrl+]
Select direct precedentsCtrl+[Ctrl+[
Select all precedentsCtrl+Shift+{Ctrl+Shift+{
Select all dependentsCtrl+Shift+}Ctrl+Shift+}
Select cells with commentsCtrl+Shift+OFn+Ctrl+Shift+O

Copy & Move with the Mouse

ShortcutWindowsMacWeb
Copy selected range or shapeCtrl+DragAlt+Drag
Insert copy of selected range (moves existing cells)Ctrl+Shift+DragAlt+Shift+Drag
Drag and cutDragDrag
Cut and paste selected range (moves existing cells)Shift+DragShift+Drag
Move selected range to another worksheetAlt+DragCmd+Drag

Zoom & Scroll

ShortcutWindowsMacWeb
Zoom inCtrl+Alt++Alt+Cmd++Ctrl+Alt++
Zoom outCtrl+Alt+-Alt+Cmd+-Ctrl+Alt+-
Zoom in (with mouse)Ctrl+Scroll UpCtrl+Scroll UpCtrl+Scroll Up
Zoom out (with mouse)Ctrl+Scroll DownCtrl+Scroll DownCtrl+Scroll Down
Zoom to SelectionAlt,W,G
Zoom to SelectionAlt,W,J
Toggle Scroll Lock on/offScrLkFn+Shift+F14
Toggle Gridlines on/offAlt,W,V,G
Toggle Freeze Panes on/offAlt,W,F,F

Cell Borders

ShortcutWindowsMacWeb
Add Outside Borders to selected cell/rangeCtrl+Shift+&Cmd+Alt+0Ctrl+Shift+&
Remove all borders (apply No Borders) to the selectionCtrl+Shift+_Cmd+Alt+_
Open Border dropdown menu on Home TabAlt,H,BAlt,H,B
Add all borders to cells in the selected rangeAlt,H,B,A
Add or remove Bottom BorderAlt,H,B,OCmd+Alt+↓
Add or remove Top BorderAlt,H,B,PCmd+Alt+↑
Add or remove Left BorderAlt,H,B,LCmd+Alt+←
Add or remove Right BorderAlt,H,B,RCmd+Alt+→
Open Borders tab in Format Cells window (More Borders)Alt,H,B,M

Worksheet Tabs

ShortcutWindowsMacWeb
Insert new worksheetShift+F11Fn+Shift+F11Shift+F11
Delete selected worksheetsAlt,E,LAlt,H,D,S
Rename current worksheetAlt,O,H,R
Go to next worksheetCtrl+PgDnFn+Ctrl+↓Ctrl+Alt+PgDn
Go to previous worksheetCtrl+PgUpFn+Ctrl+↑Ctrl+Alt+PgUp
Select adjacent worksheetsCtrl+Shift+PgUp/PgDn
Select adjacent worksheets (mouse)Shift+ClickShift+Click
Select non-adjacent worksheets (mouse)Ctrl+ClickCmd+Click
Open Move or Copy window for selected sheetsAlt,E,M
Duplicate worksheet (mouse)Ctrl+dragAlt+drag
Protect or Unprotect SheetAlt,R,P,S
Clear print areaAlt,P,R,C
Set print areaAlt,P,R,S

Workbooks

File Open, Close, Save

ShortcutWindowsMacWeb
Create new workbookCtrl+NCmd+N
Open workbookCtrl+OCmd+OCtrl+O
Save workbookCtrl+SCmd+S
Save asF12Cmd+Shift+SAlt+F2
Close current workbookCtrl+F4 OR Ctrl+WCmd+WCtrl+W
Close ExcelAlt+F4Cmd+Q

Workbook Actions & Options

ShortcutWindowsMacWeb
Undo last actionCtrl+ZCmd+ZCtrl+Z
Redo last actionCtrl+YCmd+YCtrl+Y
Repeat last actionF4Cmd+YF4
Open Excel Options windowAlt,F,TCmd+,
Open helpF1Cmd+/
Tell MeAlt+Q
Open the Control Menu (minimize, maximize, close window)Alt+Space
Open Spelling window (Spell Check)F7Fn+F7
Open Thesaurus dialog boxShift+F7Fn+Shift+F7
Open Right-click menuShift+F10 OR Menu KeyFn+Shift+F10
Move to next pane in application windowF6Fn+F6
Move to previous paneShift+F6Fn+Shift+F6
Protect and Unprotect WorkbookAlt,R,P,W

Workbook View Settings

ShortcutWindowsMacWeb
Minimize current workbook windowCtrl+F9Cmd+M
Maximize or Restore current workbook window (toggle)Ctrl+F10Fn+Ctrl+F10
Toggle full screenCtrl+Shift+F1Ctrl+Cmd+F
Go to previous workbookCtrl+Shift+TabCmd+Shift+`
Go to next workbookCtrl+TabCmd+`
Open current workbook in Desktop Excel ApplicationAlt+O

Tables & Filters

ShortcutWindowsMacWeb
Insert TableCtrl+TCtrl+TCtrl+L OR Ctrl+Alt+T
Insert Table (select style first)Alt,H,T
Insert a row above the current rowAlt,H, I, RAlt,H, I, R
Insert a column to the left of the current columnAlt,H, I, CAlt,H, I, C
Select Table Body (Press again to include Headers)Ctrl+ACmd+A
Select Table rowShift+SpaceShift+SpaceShift+Space
Select Table columnCtrl+SpaceCtrl+SpaceCtrl+Space
Toggle Autofilter on/offCtrl+Shift+LCmd+Shift+FCtrl+Shift+L
Open Filter Dropdown Menu (with header cell selected)Alt+↓Alt+↓Alt+↓
Open Filter Dropdown Menu (from any cell in a Table)Shift+Alt+↓Shift+Alt+↓Shift+Alt+↓
Toggle Total Row on/offCtrl+Shift+TCmd+Shift+T
Clear slicer filter (with slicer selected)Alt+CAlt+C

Charts & Shapes

ShortcutWindowsMacWeb
Create chart or PivotChart on same worksheetAlt+F1Fn+Alt+F1Alt+F1
Create chart in new ChartSheetF11Fn+F11
Open Format Chart Area Task PaneCtrl+1Cmd+1
Show or Hide All Field Buttons on PivotChartAlt,J,T,D,A
Snap to gridAltCmd+
Hide or show objects (shapes, charts, slicers)Ctrl+6Ctrl+6

Copy & Paste Objects

ShortcutWindowsMacWeb
Copy selected object (cells, range, shape)Ctrl+CCmd+CCtrl+C
Cut selected objectCtrl+XCmd+XCtrl+X
Paste content from clipboardCtrl+VCmd+VCtrl+V
Open the Paste Special windowCtrl+Alt+VCmd+Ctrl+V
Duplicate selected object (shapes, charts, slicers)Ctrl+DCmd+D
Copy selected objects (mouse)Ctrl+DragCmd+Drag
Copy selected ojbects and retain vertical or horizontal alignment (mouse)Ctrl+Shift+DragCmd+Shift+Drag
Copy selected objects (mouse right-click)Right-click+DragRight-click+Drag
Copy selected ojbects and retain vertical or horizontal alignment (right-click mouse)Right-click+Shift+DragRight-click+Shift+Drag

Pivot Tables

ShortcutWindowsMacWeb
Insert Pivot TableAlt,N,V
Refresh Pivot Table or QueryAlt+F5Alt+F5
Refresh AllCtrl+Alt+F5Ctrl+Alt+F5
Open pivot table wizardAlt,D,PCmd+Alt+P
Select entire pivot tableCtrl+ACmd+A
Group pivot table itemsShift+Alt+→Cmd+Shift+K
Ungroup pivot table itemsShift+Alt+←Cmd+Shift+J
Unhide (clear filter on) pivot table itemAlt,H,S,C
Filter out (exclude/hide) pivot itemCtrl+-Ctrl-Ctrl+-
Open Filter Dropdown Menu in Pivot Table cellsAlt+↓Alt+↓Alt+↓
Toggle pivot table field checkboxSpaceSpace
Insert pivot chartAlt+F1Fn+Alt+F1Alt+F1
Create pivot chart on new Chart SheetF11Fn+F11

Ribbon

ShortcutWindowsMacWeb
Activate Ribbon shortcut keysAlt OR Shift+F6Alt OR Win+Alt
Move to next ribbon controlTabTabTab
Move through Ribbon tabs and groups→ ← ↑ ↓→ ← ↑ ↓
Open dropdown menu of selected buttonAlt+↓Alt+↓
Open help window for selected controlF1
Expand or collapse ribbonCtrl+F1Cmd+Alt+R

Macros & VBA

ShortcutWindowsMacWeb
Open the VB Editor window (VBA)Alt+F11Fn+Alt+F11
Open the Macro window (run or edit macro)Alt+F8Fn+Alt+F8
Record MacroAlt,L,R
Open Excel Add-ins WindowAlt,L,R
Open COM Add-ins WindowAlt,L,J

Navigating Windows & Dialog Boxes

ShortcutWindowsMacWeb
Move to next tabCtrl+TabCtrl+Tab
Move to previous tabCtrl+Shift+TabCtrl+Shift+Tab
Move to next control or buttonTabTabTab
Move to previous control or buttonShift+TabShift+TabShift+Tab
Press selected control or buttonEnterReturnEnter
Check and uncheck checkboxesSpaceSpace
Close the window or dialog boxEscEscEsc

Power Query

ShortcutWindowsMacWeb
Open the Power Query EditorAlt,A,P,L,N
Press any button in the Power Query RibbonAlt, Letter Sequence
Quick Access Toolbar in Power QueryAlt+Number
Rename ColumnF2
Remove Column(s)Delete
Undo Last ActionTab (6 times), Delete
Select All ColumnsCtrl+A
Select First ColumnHome
Select Last ColumnEnd
Select Multiple Adjacent ColumnsShift+→ or ←
Select Multiple Non-Adjacent ColumnsCtrl+→ or ←, Space
Open Filter Drop-down MenuAlt+↓
Open Right-click MenusMenu Key
Open Table Options MenuSelect First Column,← ,Space
Select Task Panes & RibbonTab & Shift+Tab
Close Power Query WindowAlt+F4
Close & LoadAlt,F,Enter

Wrapping Up

We have included all the ones that we feel are important in the Shortcut Keys of MS Excel. If you need any other set of Excel Shortcuts for Mac, Windows, etc. do let us know your queries and we are happy to solve them. To know more about such similar kinds of Google Sheets Keyboard Shortcuts and Google Forms Keyboard Shortcuts bookmark our site.

Leave a Comment