Excel shortcuts for Windows and Mac

This page contains a list of over 300+ Excel shortcuts for the Windows and Mac versions of Excel to speed up your work and productivity. Also, download a printable cheat sheet in PDF about keyboard shortcuts.

How to use Excel Shortcuts (Press, Hold and Release Keys)

Before we take a deep dive into the topic, keep in mind the following rules. Excel shortcuts use two types of dividers: the comma sign (,) and the plus (+) sign. Just a few words about the differences:

A comma sign (,) means that you need to press and release keys in order. For example, if you want to use the ‘Increase font size‘ shortcut in Excel, use the Alt, H, F, G combination. Press Alt, then release Alt, then press H, release H, and so on.

A plus sign (+) means that you need to press and hold each key in order. To increase the font size in Mac Excel, use the Command + Shift + > shortcut. In this case, press the keys at the same time.

Let’s get started! Also, discover our latest post on what if your shortcuts are not working.

Types of Excel Shortcuts

Formula Shortcuts

Working with formulas is easy; use shortcuts to manage formulas on the fly! Learn about the most important shortcuts and make your rows and columns-related tasks easy!

CommandWindows ShortcutsMac Shortcuts
Begin entering a formula= OR += OR +
Toggle Enter and Edit modes while editing formulaF2Ctrl + U
Exit cell edit modeEscEsc
Toggle absolute and relative referencesF4Cmd + T
Open the Insert Function Dialog BoxShift + F3Fn + Shift + F3
Autosum selected cellsAlt + =Cmd + Shift + T
Toggle formulas on and offCtrl + `Ctrl + `
Insert function argumentsCtrl + Shift + ACtrl + Shift + A
Enter array formulaCtrl + Shift + EnterCtrl + Shift + Return
Calculate worksheetsF9Fn + F9
Calculate active worksheetShift + F9Fn + Shift + F9
Force calculates all worksheetsCtrl + Alt + F9
Evaluate part of a formulaF9Fn + F9
Expand or collapse the formula barCtrl + Shift + UCtrl + Shift + U
Display function arguments dialog boxCtrl + ACtrl + A
Open the Name ManagerCtrl + F3Fn + Ctrl + F3
Define name using row and column labelsCtrl + Shift + F3Fn + Ctrl + Shift + F3
Paste name into formulaF3
Accept function with autocompleteTab↓ + Tab

Grid Operation Shortcuts

If you are working with Excel, using the grid is essential. The following list contains the most useful Excel shortcuts regarding grid navigation. Select cells and ranges as soon as possible. Excel basic shortcuts like hiding and unhiding rows & columns boost your productivity.

CommandWindows ShortcutsMac Shortcuts
Display Insert Dialog boxCtrl + Shift + +Ctrl + Shift + +
Insert rowsCtrl + Shift + + Ctrl + Shift + +
Insert columnsCtrl + Shift + +Ctrl + Shift + +
Display Delete dialog boxCtrl + –Cmd + –
Delete rowsCtrl + – Cmd + –
Delete columnsCtrl + – Cmd + –
Delete cellsCtrl + – Cmd + –
Delete contents of selected cellsDeleteFn + Delete
Merge cellsAlt, H, M, CCtrl + M
Hide columnsCtrl + 0Ctrl + 0
Hide rowsCtrl + 9Ctrl + 9
Unhide rowsCtrl + Shift + 9Ctrl + Shift + 9
Unhide columnsCtrl + Shift + 0Ctrl + Shift + 0
Group rows or columnsAlt + Shift + →Cmd + Shift + K
Ungroup rows or columnsAlt + Shift + ←Cmd + Shift + J
Open Group Dialog Box (with cell or range selected)Alt + Shift + →Cmd + Shift + K
Open Ungroup Dialog Box (with cell or range selected)Alt + Shift + ← Cmd + Shift + J
Hide or show outline symbolsCtrl + 8Ctrl + 8

Data Entry Shortcuts

CommandWindows ShortcutsMac Shortcuts
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 + EnterCtrl + Return
Enter same data in multiple cellsCtrl + EnterCtrl + Return
Insert current dateCtrl + ;Ctrl + ;
Insert current timeCtrl + Shift + :Cmd + :
Fill down from cell aboveCtrl + DCtrl + D
Fill right from cell leftCtrl + RCtrl + R
Copy value from the cell aboveCtrl + ‘Ctrl+’
Copy value (the result of formula) from the cell aboveCtrl + Shift + “Ctrl + Shift + “
Display AutoComplete listAlt + ↓Alt + ↓
Flash fillCtrl + E
Quick Analysis Tool (select cells first)Ctrl + Q

Editing Text (Cell edit mode)

If you edit a text, write a code, or create a custom formula, you can use these Excel shortcuts in all areas.

CommandWindows ShortcutsMac Shortcuts
Edit the active cellF2Ctrl + U
Insert or edit cell noteShift + F2Fn+Shift+F2
Insert or reply to Cell CommentCtrl + Shift + F2Fn + Ctrl + Shift + F2
Delete commentShift + F10, M
Cancel entryEscEsc
Select one character rightShift + →Shift + →
Select one character leftShift + ←Shift + ←
Move one word rightCtrl + →Ctrl + →
Move one word left Ctrl + ← Ctrl + ←
Select one word rightCtrl + Shift + →Ctrl+Shift+→
Select one word leftCtrl + Shift + ←Ctrl + Shift + ←
Select to the beginning of the cellShift + HomeFn + Shift + ←
Select to end of the cellShift + EndFn + Shift + →
Delete to end of lineCtrl + DeleteCtrl + Delete
Delete a character to the left of the cursorBackspaceDelete
Delete characters to the right of the cursorDeleteFn + Delete
Start a new line in the same cell (line break command)Alt + EnterCtrl + Alt + Return

Formatting Shortcuts

Number Formatting

Use these shortcuts in Excel to apply number formats to a cell or cells in a range.

CommandWindows ShortcutsMac Shortcuts
Format PainterAlt, H, F, P
Apply general formatCtrl + Shift + ~Ctrl + Shift + ~
Apply currency formatCtrl + Shift + $Ctrl + Shift + $
Apply percentage formatCtrl + Shift + %Ctrl + Shift + %
Apply scientific formatCtrl + Shift + ^Ctrl + Shift + ^
Apply date formatCtrl + Shift + #Ctrl + Shift + #
Apply time formatCtrl + Shift + @Ctrl + Shift + @
Apply number formatCtrl + Shift + !Ctrl + Shift + !

Cell and Font Formatting

Here is the list of useful shortcuts regarding cell and font formatting. Locate the ribbon and choose the Home Tab, and take a closer look at the functions.

CommandWindows ShortcutsMac Shortcuts
Format Window for cells and objectsCtrl + 1Cmd + 1
Display Format Cells with Font tab selectedCtrl + Shift + FCtrl + Shift + F
Apply or remove bold formattingCtrl + BCmd + B
Apply or remove italic formattingCtrl + ICmd + I
Apply or remove underscoring Ctrl + UCmd + U
Apply or remove strikethrough formattingCtrl + 5Cmd + Shift + X
Subscript format on a selected characterCtrl +1 then Alt + BCmd +1 then select the Subscript checkbox
Add or remove the shadow font styleCmd + Shift + W
Add or remove the outline font styleCmd + Shift + D
Align centerAlt, H, A, CCmd + E
Align leftAlt, H, A, LCmd + L
Align rightAlt, H, A, RCmd + R
Align topAlt, H, A, T
Align middleAlt, H, A, M
IndentAlt, H, 6Ctrl+Alt+Tab
Remove indent Alt, H, 5 Ctrl + Alt + Shift + Tab
Increase font size one stepAlt, H, F, GCmd + Shift + >
Decrease font size one stepAlt, H, F, KCmd + Shift + <
Wrap TextAlt, H, W

Formatting Charts and Shapes

CommandWindows ShortcutsMac Shortcuts
Create a chart or PivotChart on the same worksheetAlt + F1Fn + Alt + F1
Create a chart in the 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

Rows and Columns Shortcuts (Selection)

CommandWindows ShortcutsMac Shortcuts
Select entire rowShift + SpaceShift+Space
Select entire columnCtrl + SpaceCtrl + Space
Select entire worksheetCtrl + ACmd + A
Add adjacent cells to selectionShift + ClickShift + Click
Add non-adjacent cells to selectionCtrl + ClickCmd + Click
Same selection in next columnOpt + Tab
Same selection in the previous columnOpt + Shift + Tab
Move right between non-adjacent selectionsCtrl + Alt + →Ctrl + Alt + →
Move left between non-adjacent selectionsCtrl + Alt + ←Ctrl + Alt + ←
Toggle add or remove to selection modeShift + F8Fn + Shift + F8
Cancel selectionEscEsc

Active Cell

CommandWindows ShortcutsMac Shortcuts
Select a single (active) cell when the range is selectedShift + BackspaceShift + Delete
Show the active cell on the worksheetCtrl + BackspaceCmd + Delete
Activate each corner cell in selected range in clockwise directionCtrl + .Ctrl + .
Activate next cell in the selected range (based on direction set in Excel Options)EnterReturn
Activate the previous cell in selection (based on direction set in Excel Options)Shift + EnterShift + Return
Activate next cell to right/below in the selected rangeTabTab
Activate the previous cell to left/above in a selected rangeShift + TabShift + Tab

Extend Selection

CommandWindows ShortcutsMac Shortcuts
Extend selection by one cell rightShift + →Shift + →
Extend selection by one cell leftShift + ←Shift + ←
Extend selection by one cell up Shift + ↑ Shift + ↑
Extend selection by one cell down Shift + ↓ Shift + ↓
Extend the selection to the last cell rightCtrl + Shift + →Ctrl + Shift + →
Extend the selection to the last cell leftCtrl + Shift + ←Ctrl + Shift + ←
Extend the selection to the last cell upCtrl + Shift + ↑Ctrl + Shift + ↑
Extend the selection to the last cell down Ctrl + Shift + ↓Ctrl + Shift + ↓
Extend selection up one screenShift + PgUpFn + Shift + ↑
Extend selection down one screenShift + PgDnFn + Shift + ↓
Extend selection right one screenAlt + Shift + PgDnFn + Shift + Alt + ↓
Extend selection left one screenAlt + Shift + PgUp Fn + Shift + Alt + ↑
Extend selection to start of the rowShift + HomeFn + Shift + ←
Extend selection to the first cell in a worksheetCtrl + Shift + HomeFn + Ctrl + Shift + ←
Extend selection to the last cell in a worksheetCtrl + Shift + EndFn + Ctrl + Shift + →
Toggle extend selection modeF8Fn + F8
Select Spill RangeCtrl + A

Select Special Cells

CommandWindows ShortcutsMac Shortcuts
Display ‘Go To’ dialog boxCtrl + GCtrl + G
Open the Go To Special windowAlt, H, F, D, S
Select cells with comments (Note)Ctrl + Shift + OFn + Ctrl + Shift + O
Select current region around the active cellCtrl + Shift + 8Shift + Ctrl + Space
Select current regionCtrl + ACmd + A
Select current arrayCtrl + /Ctrl + /
Select row differencesCtrl + \Ctrl + \
Select column differencesCtrl + Shift + |Ctrl + Shift + |
Select direct precedentsCtrl + [Ctrl + [
Select all precedentsCtrl + Shift + {Ctrl + Shift + {
Select direct dependentsCtrl + ]Ctrl + ]
Select all dependentsCtrl + Shift + }Ctrl + Shift + }
Select visible cells only (when range is selected)Alt + ;Cmd + Shift + Z

Cell Borders

CommandWindows ShortcutsMac Shortcuts
Open Border dropdown menu on Home TabAlt, H, B
Add all borders to cells in the selected rangeAlt, H, B, A
Add or remove Right BorderAlt, H, B, RCmd + Alt + →
Add or remove Left BorderAlt, H, B, LCmd + Alt + ←
Add or remove Top BorderAlt, H, B, PCmd + Alt + ↑
Add or remove Bottom BorderAlt, H, B, OCmd + Alt + ↓
Remove all borders (apply no borders)Ctrl + Shift + _Cmd + Alt + _

WorkSheet Tab Shortcuts

CommandWindows ShortcutsMac Shortcuts
Insert new worksheetShift + F11Fn + Shift + F11
Go to the next worksheetCtrl + PgDnFn + Ctrl + ↓
Go to the previous worksheetCtrl + PgUpFn + Ctrl + ↑
Delete selected worksheetsAlt, E, L
Rename current worksheetAlt, O, H, R
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 a WorkSheetAlt, R, P, S
Clear print areaAlt, P, R, C
Set print areaAlt, P, R, S

Workbook Shortcuts

CommandWindowsMac
Create a new WorkbookCtrl + NCmd + N
Open WorkbookCtrl + OCmd + O
Save WorkbookCtrl + SCmd + S
Save AsF12Cmd + Shift + S
Print FileCtrl + PCmd + P
Open Print Preview WindowCtrl + F2
Close Current WorkbookCtrl + WCmd + W
Close ExcelAlt + F4Cmd + Q

Workbook Actions & Options

CommandWindowsMac
Undo the last actionCtrl + ZCmd + Z
Redo the last action Ctrl + Y Cmd + Y
Repeat the last actionF4Cmd + Y
Open Excel Options windowAlt, F, TCmd + ,
Open helpF1
Open the Control MenuAlt + Space
Open Spelling window (Spell Check)F7Fn + F7
Open Thesaurus dialog boxShift + F7Fn + Shift + F7
Open Right-click menuShift + F10Fn + Shift + F10
Move to the next pane in the application windowF6Fn + F6
Move to the previous paneShift + F6Fn + Shift + F6
Protect and Unprotect WorkbookAlt, R, P, W

Workbook View Settings

CommandWindowsMac
Minimize current workbook windowCtrl + F9Cmd + M
Maximize or Restore current workbook windowCtrl + F10Fn + Ctrl + F10
Toggle full screenCtrl + Shift + F1Ctrl + Cmd + F
Go to previous workbookCtrl + Shift + TabCtrl + Shift + Tab
Go to next workbookCtrl + TabCtrl + Tab

Ribbon Shortcuts

CommandWindows ShortcutsMac Shortcuts
Activate Ribbon shortcut keysAlt
Move to the next ribbon controlTabTab
Move through Ribbon tabs and groups→ ← ↑ ↓
Open dropdown menu of the selected buttonAlt + ↓Alt + ↓
Expand or collapse the ribbonCtrl + NCmd + Alt + R
Activate access keyCtrl + OCtrl + O
Move to the next ribbon controlCtrl + SCtrl + S
Activate or open the selected controlF12Crtl + Shift + S
Confirm control changeCtrl + PCtrl + P
Get help on selected controlCtrl + WCmd + W

Table and Filter Shortcuts

CommandWindows ShortcutsMac Shortcuts
Insert tableCtrl +TCtrl +T
Insert Table (select style first)Alt, H, T
Insert a row above the current rowAlt, H, I, R
Insert a column to the left of the current columnAlt, H, I, C
Select Table BodyCtrl + ACmd+A
Select Table rowShift + SpaceShift + Space
Open Filter Dropdown MenuAlt + ↓Alt + ↓
Open Filter Dropdown Menu (from any cell in a Table)Shift + Alt+ ↓Shift + Alt+ ↓
Toggle Total Row on/offCtrl + Shift + TCmd + Shift + T
Clear slicer filter (with slicer selected)Alt + CAlt + C

Copy & Paste Shortcuts (Objects)

CommandWindows ShortcutsMac Shortcuts
Copy selected object (cells, range, shape)Ctrl + CCmd + C
Cut selected objectCtrl + XCmd + X
Paste content from the clipboardCtrl + VCmd + V
Paste ValuesAlt, E, S, VCmd, Ctrl, V, V
Open the Paste Special windowCtrl + Alt + VCmd + Ctrl + V
Duplicate selected object (shapes, charts, slicers)Ctrl + DCmd + D
Copy selected range or shape (mouse) Ctrl + Drag Alt + 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 objects and retain vertical or horizontal alignment (right-click mouse)Right-click + Shift + DragRight-click + Shift + Drag

Pivot Table Shortcuts

CommandWindows ShortcutsMac Shortcuts
Insert a new Pivot TableAlt, N, V
Refresh Pivot Table or QueryAlt + F5
Refresh AllCtrl + Alt + F5Cmd + Alt + P
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 –
Open Filter Dropdown Menu in Pivot Table cellsAlt + ↓Alt + ↓
Toggle pivot table field checkboxSpaceSpace
Insert pivot chartAlt + F1Fn + Alt + F1
Create pivot chart on new Chart SheetF11Fn + F11
CommandWindows ShortcutsMac Shortcuts
Move one cell right
Move one cell left
Move one cell up
Move one cell down
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 screen downPgDnFn + ↓
Select the first/last cell of a region (non-blank cells) moving rightCtrl + →Ctrl + →
Select the first/last cell of a region (non-blank cells) moving downCtrl + ←Ctrl + ←
Select the first/last cell of a region (non-blank cells) moving upCtrl + ↑Ctrl + ↑
Select the first/last cell of a region (non-blank cells) moving downCtrl + ↓Ctrl + ↓
Move to begin of rowHomeFn + ←
Select the last used cell in the sheetCtrl + EndFn + Ctrl + →
Select the first visible cell in the sheetCtrl + HomeFn + Ctrl + Home
Turn End mode on (like Ctrl+Arrow Keys)EndFn + →
Go back to the hyperlinkCtrl+G, EnterCtrl+G, Return

Other Shortcuts

Macros and VBA Editor

CommandWindows ShortcutsMac Shortcuts
Open the VBE window (edit VBA code)Alt + F11Fn + Alt + F11
Open the Macro window to run or edit a macroAlt + F8Fn + Alt + F8
Record MacroAlt, L, R
Open Excel Add-ins WindowAlt, L, R
Open COM Add-ins WindowAlt, L, J

Power Query

CommandWindows ShortcutsMac Shortcuts
Open the Power Query EditorAlt, A, P, L, N
Press any button in the Power Query RibbonAlt, Letter Sequence
Quick Access Toolbar (QAT) in Power QueryAlt + Number
Rename ColumnF2
Remove Column(s)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

We hope you find this Excel shortcuts list helpful. Stay tuned.