EXCEL
Shortcuts

Essential keyboard shortcuts to boost your spreadsheet productivity by 200%

Keyboard cheat sheet

Select a shortcut below to locate its keys.

Core shortcuts · 10

An editorial selection to learn recurring tasks first, in the same order as the core list below.

How core shortcuts are selected

These are editorial recommendations, not usage rankings. We prioritize recurring tasks, fewer mouse trips, and combinations that are easy to learn. App-specific actions are labeled.

The same layout at every screen size.

EXCEL

Core shortcuts · 10 · Mac · danchookeys.com

01F4Cycle Absolute/Relative Reference

02Alt=AutoSum (SUM)

03CtrlShiftLApply/Remove Filter

04Ctrl1Open Format Cells Dialog

05CtrlShift1-5Change Data Format (Number, Date, etc.)

06CtrlTCreate Table

07CtrlDFill Down

08F5Go To Cell/Range/Special

09⌥EnterLine Break within Cell

10CtrlShiftArrowsSelect to edge of data

Core shortcuts · 10

F4Cycle Absolute/Relative Reference

Alt=AutoSum (SUM)

CtrlShiftLApply/Remove Filter

Ctrl1Open Format Cells Dialog

CtrlShift1-5Change Data Format (Number, Date, etc.)

CtrlTCreate Table

CtrlDFill Down

F5Go To Cell/Range/Special

⌥EnterLine Break within Cell

CtrlShiftArrowsSelect to edge of data

01 — Basics

⌘CCopy

⌘VPaste

⌘XCut

⌘ZUndo

⌘YRedo

⌘SSave

⌘ASelect All

⌘PPrint

02 — Navigation

CtrlHomeGo to cell A1

CtrlEndGo to last used cell

Ctrl→Move to edge of data (Right)

Ctrl←Move to edge of data (Left)

Ctrl↓Move to edge of data (Down)

Ctrl↑Move to edge of data (Up)

CtrlPage UpPrevious sheet

CtrlPage DownNext sheet

03 — Selection

Shift→Extend selection (Right)

CtrlShiftEndSelect to last used cell

CtrlSpaceSelect entire column

ShiftSpaceSelect entire row

CtrlShiftLApply/Remove Filter

04 — Formulas

=Start formula

F4Cycle absolute/relative references

Ctrl`Show/Hide formulas

Alt=AutoSum (SUM)

CtrlShiftEnterEnter array formula

F9Calculate selected portion of formula

05 — Editing

F2Edit active cell

EnterComplete entry and move down

TabComplete entry and move right

DeleteClear cell contents

CtrlDFill down (copy from cell above)

CtrlRFill right (copy from cell left)

CtrlEnterFill same entry in all selected cells

06 — Formatting

CtrlBBold

CtrlIItalic

CtrlUUnderline

Ctrl1Open Format Cells dialog

CtrlShift!Number format (comma separated)

CtrlShift$Currency format

CtrlShift%Percentage format

CtrlShift&Apply border

07 — Rows and Columns

Ctrl+Insert Row/Column

Ctrl-Delete Row/Column

Ctrl9Hide Row

Ctrl0Hide Column

CtrlShift9Unhide Row

CtrlShift0Unhide Column

08 — Others

F5Go To dialog

CtrlFFind

CtrlHFind and Replace

F11Create Chart

AltF1Insert Chart from data

CtrlNNew Workbook

CtrlWClose Workbook