#File
Shortcut Windows Mac
Create new workbook CtrlN ⌘N
Open workbook CtrlO ⌘O
Save workbook CtrlS ⌘S
Save as F12 ⌘⇧S
Print file CtrlP ⌘P
Open print preview window CtrlF2
Close current workbook CtrlW ⌘W
Close Excel AltF4 ⌘Q
#Ribbon
Shortcut Windows Mac
Expand or collapse ribbon CtrlF1 ⌘⌥R
Activate access keys Alt
Move to next ribbon control Tab Tab
Activate or open selected control Space Space
Confirm control change Enter Return
Get help on selected control F1
#General
Shortcut Windows Mac
Open options AltFT ⌘,
Open help F1 ⌘/
Undo last action CtrlZ ⌘Z
Redo last action CtrlY ⌘Y
Copy selected cells CtrlC ⌘C
Repeat last action F4 ⌘Y
Cut selected cells CtrlX ⌘X
Paste values CtrlShiftV ⌘⇧V
Paste content from clipboard CtrlV ⌘V
Display the Paste Special dialog box CtrlAltV ⌘⌃V
Display find and replace CtrlF ⌘F
Display find and replace, replace selected CtrlH ⌃H
Find previous match CtrlShiftF4 ⌘⇧G
Find next match ShiftF4 ⌘G
Create embedded chart AltF1 Fn⌥F1
Create chart in new worksheet F11 FnF11
Display Quick Analysis options CtrlQ
#Tables and Filters
Shortcut Windows Mac
Insert table CtrlT ⌘T
Toggle Autofilter CtrlShiftL ⌘⇧F
Activate filter Alt↓ ⌥↓
Select table row ShiftSpace ⇧Space
Select table column CtrlSpace ⌃Space
Select table CtrlA ⌘A
Clear slicer filter AltC ⌥C
Toggle table total row CtrlShiftT ⌃⇧T
Open Custom Sort dialog box AltHSU ⌘⇧R
#Drag and Drop
Shortcut Windows Mac
Drag and cut drag drag
Drag and copy Ctrldrag ⌥drag
Drag and insert Shiftdrag ⇧drag
Drag and insert copy CtrlShiftdrag ⌥⇧drag
Drag to worksheet Altdrag ⌘drag
Drag to duplicate worksheet Ctrldrag ⌥drag
#Navigation
Shortcut Windows Mac
Move one cell right → →
Move one cell left ← ←
Move one cell up ↑ ↑
Move one cell down ↓ ↓
Move one screen right AltPgDn Fn⌥↓
Move one screen left AltPgUp Fn⌥↑
Move one screen up PgUp Fn↑
Move one screen down PgDn Fn↓
Move to right edge of data region Ctrl→ ⌘→
Move to left edge of data region Ctrl← ⌘←
Move to top edge of data region Ctrl↑ ⌘↑
Move to bottom edge of data region Ctrl↓ ⌘↓
Move to beginning of row Home Fn←
Move to last cell in worksheet CtrlEnd Fn⌃→
Move to first cell in worksheet CtrlHome Fn⌃←
Turn End mode on End Fn→
Go back to hyperlink CtrlGEnter ⌃GReturn
#Selection
Shortcut Windows Mac
Select entire row ShiftSpace ⇧Space
Select entire column CtrlSpace ⌃Space
Select entire worksheet CtrlA ⌘A
Add adjacent cells to selection ShiftClick ⇧Click
Add non-adjacent cells to selection CtrlClick ⌘Click
Same selection in next column ⌥Tab
Same selection in previous column ⌥⇧Tab
Move right between non-adjacent selections CtrlAlt→ ⌃⌥→
Move left between non-adjacent selections CtrlAlt← ⌃⌥←
Toggle add to selection mode ShiftF8 Fn⇧F8
Cancel selection Esc Esc
#Active Cell
Shortcut Windows Mac
Select active cell only ShiftBackspace ⇧Delete
Show the active cell on worksheet CtrlBackspace ⌃Delete
Move active cell clockwise in selection Ctrl. ⌃.
Move active cell down in selection Enter Return
Move active cell up in selection ShiftEnter ⇧Return
Move active cell right in a selection Tab Tab
Move active cell left in a selection ShiftTab ⇧Tab
#Extend Selection
Shortcut Windows Mac
Extend selection by one cell right Shift→ ⇧→
Extend selection by one cell left Shift← ⇧←
Extend selection by one cell up Shift↑ ⇧↑
Extend selection by one cell down Shift↓ ⇧↓
Extend the selection to the last cell right CtrlShift→ ⌘⇧→
Extend the selection to the last cell left CtrlShift← ⌘⇧←
Extend the selection to the last cell up CtrlShift↑ ⌘⇧↑
Extend the selection to the last cell down CtrlShift↓ ⌘⇧↓
Extend selection up one screen ShiftPgUp Fn⇧↑
Extend selection down one screen ShiftPgDn Fn⇧↓
Extend selection right one screen AltShiftPgDn Fn⇧⌥↓
Extend selection left one screen AltShiftPgUp Fn⇧⌥↑
Extend selection to start of row ShiftHome Fn⇧←
Extend selection to first cell in worksheet CtrlShiftHome Fn⌃⇧←
Extend selection to last cell in worksheet CtrlShiftEnd Fn⌃⇧→
Toggle extend selection mode F8 FnF8
#Select Special
Shortcut Windows Mac
Display 'Go To' dialog box CtrlG ⌃G
Select cells with comments CtrlShiftO Fn⌃⇧O
Select current region around active cell CtrlShift* ⌃⇧Space
Select current region CtrlA ⌘A
Select current array Ctrl/ ⌃/
Select row differences Ctrl\ ⌃\
Select column differences CtrlShift| ⌃⇧|
Select direct precedents Ctrl[ ⌃[
Select all precedents CtrlShift{ ⌃⇧{
Select direct dependents Ctrl] ⌃]
Select all dependents CtrlShift} ⌃⇧}
Select visible cells only Alt; ⌘⇧Z
#Cell edit mode
Shortcut Windows Mac
Edit the active cell F2 ⌃U
Cancel entry Esc Esc
Select one character right Shift→ ⇧→
Select one character left Shift← ⇧←
Move one word right Ctrl→ ⌃→
Move one word left Ctrl← ⌃←
Select one word right CtrlShift→ ⌃⇧→
Select one word left CtrlShift← ⌃⇧←
Select to beginning of cell ShiftHome Fn⇧←
Select to end of cell ShiftEnd Fn⇧→
Delete to end of line CtrlDelete Fn⌃Delete
Delete character to the left of cursor Backspace Delete
Delete character to the right of cursor Delete FnDelete
Insert line break in cell AltEnter ⌃⌥Return
#Entering data
Shortcut Windows Mac
Enter and move down Enter Return
Enter and move up ShiftEnter ⇧Return
Enter and move right Tab Tab
Enter and move left ShiftTab ⇧Tab
Complete entry and stay in same cell CtrlEnter ⌘Return
Enter same data in multiple cells CtrlEnter ⌃Return
Insert current date Ctrl; ⌃;
Insert current time CtrlShift: ⌘;
Fill down from cell above CtrlD ⌘D
Fill right from cell left CtrlR ⌘R
Copy formula from cell above Ctrl' ⌘'
Copy value from cell above CtrlShift" ⌃⇧"
Add hyperlink CtrlK ⌘K
Display AutoComplete list Alt↓ ⌥↓
Flash fill CtrlE ⌃E
#Formatting
Shortcut Windows Mac
Format (almost) anything Ctrl1 ⌘1
Display Format Cells with Font tab selected CtrlShiftF ⌃⇧F
Toggle bold formatting CtrlB ⌘B
Toggle italic formatting CtrlI ⌘I
Toggle underline formatting CtrlU ⌘U
Toggle strikethrough formatting Ctrl5 ⌘⇧X
Align center AltHAC ⌘E
Align left AltHAL ⌘L
Align right AltHAR ⌘R
Indent AltH6 ⌃⌥Tab
Remove indent AltH5 ⌃⌥⇧Tab
Increase font size one step AltHFG ⌘⇧>
Decrease font size one step AltHFK ⌘⇧<
#Number Formatting
Shortcut Windows Mac
Apply general format CtrlShift~ ⌃⇧~
Apply currency format CtrlShift$ ⌃⇧$
Apply percentage format CtrlShift% ⌃⇧%
Apply scientific format CtrlShift^ ⌃⇧^
Apply date format CtrlShift# ⌃⇧#
Apply time format CtrlShift@ ⌃⇧@
Apply number format CtrlShift! ⌃⇧!
#Borders
Shortcut Windows Mac
Add border outline CtrlShift& ⌘⌥0
Add or remove border right AltR ⌘⌥→
Add or remove border left AltL ⌘⌥←
Add or remove border top AltT ⌘⌥↑
Add or remove border bottom AltB ⌘⌥↓
Add or remove border upward diagonal AltD
Add or remove border horizontal interior AltH
Add or remove border vertical interior AltV
Remove borders CtrlShift_ ⌘⌥_
#Formulas
Shortcut Windows Mac
Toggle absolute and relative references F4 ⌘T
Open the Insert Function Dialog Box ShiftF3 Fn⇧F3
Autosum selected cells Alt= ⌘⇧T
Toggle formulas on and off Ctrl` ⌃`
Insert function arguments CtrlShiftA ⌃⇧A
Enter array formula CtrlShiftEnter ⌃⇧Return
Calculate worksheets F9 FnF9
Calculate active worksheet ShiftF9 Fn⇧F9
Force calculate all worksheets CtrlAltF9
Evaluate part of a formula F9 FnF9
Expand or collapse the formula bar CtrlShiftU ⌃⇧U
Display function arguments dialog box CtrlA ⌃A
Open the Name Manager CtrlF3 Fn⌃F3
Define name using row and column labels CtrlShiftF3 Fn⌃⇧F3
Select name box AltF3
Accept function with autocomplete Tab Tab
Paste name into formula F3 F3
#Grid Operations
Shortcut Windows Mac
Display Insert Dialog box CtrlShift+ ⌘⇧+
Insert rows CtrlShift+ ⌘⇧+
Insert columns CtrlShift+ ⌘⇧+
Display Delete dialog box Ctrl- ⌘-
Delete rows Ctrl- ⌘-
Delete columns Ctrl- ⌘-
Delete cells Ctrl- ⌘-
Delete contents of selected cells Delete FnDelete
Hide columns Ctrl0 ⌃0
Hide rows Ctrl9 ⌃9
Unhide rows CtrlShift9 ⌃⇧9
Unhide columns CtrlShift0 ⌃⇧0
Group rows or columns AltShift→ ⌘⇧K
Ungroup rows or columns AltShift← ⌘⇧J
Open Group Dialog Box AltShift→ ⌘⇧K
Open Ungroup Dialog Box AltShift← ⌘⇧J
Hide or show outline symbols Ctrl8 ⌃8
Zoom in CtrlAlt+ ⌥⌘+
Zoom out CtrlAlt- ⌥⌘-
Zoom scroll Ctrlscroll ^scroll
#Pivot Tables
Shortcut Windows Mac
Select entire pivot table CtrlA ⌘A
Toggle pivot table field checkbox Space Space
Group pivot table items AltShift→ ⌘⇧K
Ungroup pivot table items AltShift← ⌘⇧J
Hide pivot table item Ctrl- Ctrl-
Create pivot chart on same worksheet AltF1
Create pivot chart on new worksheet F11 FnF11
Open pivot table wizard AltDP ⌘⌥P
#Workbook
Shortcut Windows Mac
Insert new worksheet ShiftF11 fn⇧F11
Go to next worksheet CtrlPgDn ⌥→
Go to previous worksheet CtrlPgUp ⌥←
Move to next pane F6 FnF6
Move to previous pane ShiftF6 Fn⇧F6
Go to next workbook CtrlTab ⌘`
Go to previous workbook CtrlShiftTab ⌘⇧`
Minimize current workbook window CtrlF9 ⌘M
Maximize current workbook window CtrlF10 fn⌃F10
Select adjacent worksheets ShiftClick ⇧Click
Select non-adjacent worksheets CtrlClick ⌘Click
Toggle scroll lock ScrLk Fn⇧F14
Toggle full screen CtrlShiftF1 ⌃⌘F
#Dialog boxes
Shortcut Windows Mac
Move to next control Tab Tab
Move to previous control ShiftTab ⇧Tab
Move to next tab CtrlTab ⌃Tab
Move to previous tab CtrlShiftTab ⌃⇧Tab
Accept and apply Enter Return
Check and uncheck box Space Space
Cancel and close the dialog box Esc Esc
#Other
Shortcut Windows Mac
Check spelling F7 FnF7
Open Thesaurus dialog box ShiftF7 Fn⇧F7
Open Macro dialog box AltF8 Fn⌥F8
Open Power Query Editor AltF12 Fn⌥F12
Open VBA Editor AltF11 Fn⌥F11
Duplicate object CtrlD ⌘D
Snap to grid Alt ⌘
Hide or show objects Ctrl6 ⌃6
Display Modify Cell Style dialog box Alt' ⌘⇧L
Display right-click menu ShiftF10 Fn⇧F10
Insert or edit note ShiftF2 Fn⇧F2
Insert threaded comment CtrlShiftF2 Fn⌘⇧F2
Delete comment ShiftF10D fn⇧F10
Display control menu AltSpace

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass