Excel Keyboard Shortcuts Cheatsheet (2026)
Home›Excel›Keyboard Shortcuts
ExcelReference Post⏱ 15 min read

Excel Keyboard Shortcuts Cheatsheet (2026)

Learning ten shortcuts saves an hour a week. Learning fifty changes how you think about Excel. This cheatsheet organizes 130+ shortcuts by category, with Windows and Mac keys side by side, plus a "top 20 to memorize first" section if you don't know where to start.

Top 20 to memorize first

If you learn nothing else from this guide, these twenty will change how you work.

Shortcut (Win)Shortcut (Mac)Does what
Ctrl+CCmd+CCopy
Ctrl+VCmd+VPaste
Ctrl+ZCmd+ZUndo
Ctrl+YCmd+YRedo
Ctrl+SCmd+SSave
Ctrl+FCmd+FFind
Ctrl+HCmd+HReplace
Ctrl+ArrowCmd+ArrowJump to edge of data
Ctrl+Shift+ArrowCmd+Shift+ArrowSelect from cursor to edge of data
Ctrl+HomeCmd+Home / Fn+Ctrl+LeftGo to A1
Ctrl+EndCmd+End / Fn+Ctrl+RightGo to last used cell
F2Ctrl+UEdit the active cell
F4Cmd+T (in formulas) / Cmd+Y (repeat)Toggle $ in formula / repeat last action
Alt+=Cmd+Shift+TAutoSum
Ctrl+;Ctrl+;Insert today's date
Ctrl+Shift+;Cmd+Shift+;Insert current time
Ctrl+BCmd+BBold
Ctrl+1Cmd+1Format Cells dialog
Ctrl+PageUp / PageDownFn+Ctrl+Up / DownPrevious / next sheet tab
Ctrl+Shift+LCmd+Shift+FToggle AutoFilter
How to actually memorize them

Pick five from the top 20 and use only those for a week. Deliberately catch yourself reaching for the mouse and use the shortcut instead. Next week, add five more. In a month, all twenty are muscle memory.

WindowsMacAction
Arrow keysArrow keysMove one cell in that direction
Ctrl+ArrowCmd+ArrowJump to edge of current data region
Ctrl+HomeCmd+HomeGo to A1
Ctrl+EndCmd+EndGo to last used cell
HomeHome / Fn+LeftGo to start of row (column A)
Page Up / Page DownFn+Up / Fn+DownScroll one screen up/down
Alt+Page Up / DownOption+Fn+Up / DownScroll one screen left/right
Ctrl+Page Up / DownOption+Left / RightPrevious / next sheet
Ctrl+GF5Go To dialog
Ctrl+FCmd+FFind dialog
TabTabMove one cell right
Shift+TabShift+TabMove one cell left
EnterReturnMove down (or as set in Options)
Shift+EnterShift+ReturnMove up
F5 then type a referenceF5Jump to any cell/range/name

Selection

WindowsMacAction
Shift+ArrowShift+ArrowExtend selection one cell
Ctrl+Shift+ArrowCmd+Shift+ArrowExtend selection to edge of data
Ctrl+Shift+EndCmd+Shift+EndExtend selection to last used cell
Ctrl+Shift+HomeCmd+Shift+HomeExtend selection back to A1
Shift+SpaceShift+SpaceSelect entire row
Ctrl+SpaceCtrl+SpaceSelect entire column
Ctrl+ACmd+ASelect current region (press twice for entire sheet)
Ctrl+Shift+SpaceCmd+Shift+SpaceSame as Ctrl+A
Ctrl+.Cmd+.Move active cell around corners of selection
F8F8Enable Extend Selection mode
Shift+F8Shift+F8Add non-adjacent cells to selection
Ctrl+BackspaceCmd+DeleteScroll back to active cell

Editing

WindowsMacAction
F2Ctrl+UEdit active cell (cursor at end)
DeleteFn+DeleteClear cell contents
BackspaceDeleteDelete character left / clear when editing
EscEscCancel edit
Ctrl+DCmd+DFill down from cell above
Ctrl+RCmd+RFill right from cell to the left
Ctrl+EnterCtrl+ReturnFill selection with the same value
Alt+EnterOption+ReturnInsert line break within a cell
Ctrl+;Ctrl+;Insert today's date
Ctrl+Shift+;Cmd+Shift+;Insert current time
Ctrl+'Ctrl+'Copy formula from cell above
Ctrl+Shift+"Ctrl+Shift+"Copy value from cell above
Ctrl+KCmd+KInsert hyperlink
F4Cmd+YRepeat last action

Formatting

WindowsMacAction
Ctrl+1Cmd+1Format Cells dialog
Ctrl+BCmd+BBold
Ctrl+ICmd+IItalic
Ctrl+UCmd+UUnderline
Ctrl+5Cmd+Shift+XStrikethrough
Ctrl+Shift+~Ctrl+Shift+~Apply General format
Ctrl+Shift+$Ctrl+Shift+$Currency format
Ctrl+Shift+%Ctrl+Shift+%Percentage format
Ctrl+Shift+#Ctrl+Shift+#Date format
Ctrl+Shift+@Ctrl+Shift+@Time format
Ctrl+Shift+!Ctrl+Shift+!Number format with commas
Ctrl+Shift+^Ctrl+Shift+^Scientific notation
Ctrl+Shift+&Cmd+Option+0Apply border around selection
Ctrl+Shift+_Cmd+Option+_Remove all borders
Alt+H, H—Fill color (opens picker)
Alt+H, F, C—Font color
Alt+H, A, C—Center align
Alt+H, W—Wrap text
Alt+H, M, M—Merge cells

Formulas

WindowsMacAction
==Start a formula
Alt+=Cmd+Shift+TAutoSum
F2Ctrl+UEdit active cell / formula
F4 (in formula)Cmd+TToggle absolute/relative reference
F9Fn+F9Calculate all workbooks
Shift+F9Fn+Shift+F9Calculate active sheet only
Ctrl+Alt+F9Cmd+Option+F9Force full recalculation
F9 (in formula, on selection)Fn+F9Evaluate selected portion of formula
Ctrl+`Ctrl+`Toggle formula display (show formulas instead of values)
Ctrl+[Ctrl+[Select cells that this formula references (precedents)
Ctrl+]Ctrl+]Select cells that reference this cell (dependents)
Ctrl+Shift+EnterCtrl+Shift+ReturnEnter as legacy array formula (rare in modern Excel)
Shift+F3Fn+Shift+F3Insert function dialog
Ctrl+A (after typing function name)Ctrl+AOpen Function Arguments dialog
Ctrl+Shift+UCtrl+Shift+UExpand / collapse formula bar
The F4 dollar-sign toggle

In a formula, select a cell reference like A1. Press F4: becomes $A$1. Press again: A$1. Again: $A1. Again: back to A1. Cycles through all four absolute/relative combinations without typing $ signs.

Rows & columns

WindowsMacAction
Ctrl+Plus (+)Cmd+Shift+PlusInsert row/column (based on what's selected)
Ctrl+Minus (-)Cmd+MinusDelete row/column
Shift+SpaceShift+SpaceSelect entire row
Ctrl+SpaceCtrl+SpaceSelect entire column
Ctrl+9Cmd+9Hide selected rows
Ctrl+Shift+9Cmd+Shift+9Unhide rows
Ctrl+0Cmd+0Hide selected columns
Ctrl+Shift+0Cmd+Shift+0Unhide columns (may need to enable in Windows keyboard settings)
Alt+H, O, R—Rename column
Alt+H, O, I—Auto-fit column width
Alt+H, O, A—Auto-fit row height

Sheets & workbooks

WindowsMacAction
Ctrl+NCmd+NNew workbook
Ctrl+OCmd+OOpen file
Ctrl+SCmd+SSave
F12Cmd+Shift+SSave As
Ctrl+WCmd+WClose workbook
Ctrl+PCmd+PPrint
Ctrl+F4Cmd+F4Close current window
Alt+F4Cmd+QQuit Excel
Ctrl+Page UpOption+LeftPrevious sheet
Ctrl+Page DownOption+RightNext sheet
Shift+F11Fn+Shift+F11Insert new sheet
Alt+H, D, S—Delete sheet
Alt+O, H, R—Rename sheet
Ctrl+TabCmd+~Switch between open workbooks

View

WindowsMacAction
Ctrl+F1Cmd+Option+RShow/hide ribbon
Ctrl+Shift+F1—Toggle full screen
Alt+W, F, F—Freeze panes
Alt+W, F, R—Freeze top row
Alt+W, F, C—Freeze first column
Ctrl+Scroll wheelCmd+ScrollZoom in/out
Alt+V, N—Normal view
Alt+V, P—Page layout view
Alt+V, I—Page break preview

Data & filters

WindowsMacAction
Ctrl+Shift+LCmd+Shift+FToggle AutoFilter
Alt+Down (in filtered header)Option+DownOpen filter dropdown
Ctrl+TCmd+TCreate Table from selection
Alt+A, S, A—Sort A→Z
Alt+A, S, D—Sort Z→A
Alt+A, S, S—Open custom Sort dialog
Alt+D, P—Open PivotTable Wizard (classic)
Alt+A, R, ACmd+Option+F5Refresh all data
Alt+A, T—Text to Columns
Alt+A, V, V—Data Validation
Ctrl+ECmd+EFlash Fill

Pivot tables

WindowsMacAction
Alt+N, V—Insert PivotTable
Alt+F5Cmd+Option+F5Refresh the pivot table
Alt+Shift+Right (in pivot)—Group items
Alt+Shift+Left (in pivot)—Ungroup items
Ctrl+- (on selected pivot items)Cmd+-Hide selected items
Alt+D, P—Classic PivotTable Wizard

Ribbon shortcuts (Alt keys)

Press Alt and Excel shows letter overlays on every ribbon tab. Press the letter to open that tab, then more letters for individual buttons. Once you learn a sequence, you can execute it fast even without seeing the overlays.

Tab-level shortcuts

ShortcutOpens
Alt+FFile menu (Backstage view)
Alt+HHome tab
Alt+NInsert tab
Alt+PPage Layout tab
Alt+MFormulas tab
Alt+AData tab
Alt+RReview tab
Alt+WView tab
Alt+LDeveloper tab (if enabled)
Alt+QSearch / Tell Me

Common Alt sequences worth memorizing

SequenceDoes
Alt+H, HFill color picker
Alt+H, F, CFont color picker
Alt+H, B, AAll borders
Alt+H, A, CCenter horizontally
Alt+H, A, MMiddle align vertically
Alt+H, D, SDelete sheet
Alt+H, I, RInsert rows
Alt+H, I, CInsert columns
Alt+H, O, WColumn width
Alt+H, V, VPaste values only
Alt+H, V, SPaste Special dialog
Alt+H, V, TPaste formats only
The Paste Values sequence

Alt+H, V, V is the single most useful Alt sequence to memorize. It pastes values only — strips formulas, keeps just the results. Essential when copying formula outputs to somewhere else without breaking references. Muscle memory this and never think about "how do I paste values" again.

Special characters & F-keys reference

F-keys at a glance

KeyDoes
F1Help
F2Edit active cell
F3Paste name dialog
F4Toggle absolute/relative reference / repeat last action
F5Go To dialog
F6Switch between worksheet, ribbon, task pane
F7Spell check
F8Extend Selection mode
F9Calculate all workbooks
F10Activate menu bar (same as Alt)
F11Create chart on new sheet from selected data
F12Save As

Special content shortcuts

WindowsMacInserts
Ctrl+;Ctrl+;Today's date (static)
Ctrl+Shift+;Cmd+Shift+;Current time (static)
=TODAY()=TODAY()Today's date (updates every day)
=NOW()=NOW()Current date-time (updates on recalc)
Alt+EnterOption+ReturnLine break within a cell
Alt+numeric keypad codesOption+letterSpecial characters (© ± √ etc.)

How to actually learn them

Learn in themes, not alphabetically

Pick a category — say, navigation. Learn all six or seven shortcuts. Use only those for a week. Next week, another category. Learning in themed batches beats trying to memorize a random list of 50.

Print the cheatsheet and stick it near your monitor

The friction of alt-tabbing to a cheat sheet is why you forget shortcuts. A printed reference next to your screen catches your eye at the moment you need it.

Cover the mouse button

Literally. Put a sticky note over your trackpad's right-click button, or unplug your mouse for an hour. Forces you to reach for the keyboard for everything.

Watch someone who's fast

YouTube demos of Excel power users are gold. Watch how they navigate — you'll see combinations you didn't know existed. ExcelIsFun and MyOnlineTrainingHub are two channels worth an hour of your time.

Customize with the Quick Access Toolbar

Some things you'll do constantly don't have great shortcuts. Add them to the Quick Access Toolbar (top-left area) and Excel assigns Alt+1, Alt+2, Alt+3 shortcuts to whatever's up there. Custom shortcuts for the actions you actually use.

Enable Excel's built-in shortcut display

Press Alt in modern Excel and letter overlays appear on every ribbon element. Learn common Alt sequences by using this — you don't even need a cheat sheet, Excel tells you the next key to press.

The 80/20 rule for shortcuts

Twenty shortcuts get used in 80% of Excel work. Nail the top 20 above. The other 100+ shortcuts in this guide save time in specific situations — learn them as you encounter the need, not all at once.

Windows/Mac differences summary

Most Windows Ctrl shortcuts translate to Cmd on Mac. The exceptions:

  • Function keys often require the Fn modifier on Mac (F5 becomes Fn+F5 on many Mac keyboards)
  • Alt on Windows becomes Option on Mac
  • Some Ctrl-based shortcuts stay Ctrl on Mac (Ctrl+; for today's date)
  • Ribbon Alt sequences don't work on Mac — Mac Excel doesn't have the same ribbon-navigation model
  • Right-click menu shortcut: Menu key on Windows, Ctrl+F10 on Mac (or two-finger click on trackpads)
Excel Wizard

Automate the things you can't shortcut

Shortcuts save seconds; automation saves hours. When a workflow is more than "select, format, save" — reshaping data, building a report, applying rules to hundreds of rows — Excel Wizard generates a one-click macro or Power Query from your plain-English intent.

Install Excel Wizard →

Frequently asked questions

What are the most useful Excel keyboard shortcuts?

Top 10 to memorize first: Ctrl+C copy, Ctrl+V paste, Ctrl+Z undo, Ctrl+S save, Ctrl+Arrow to jump to edge of data, Ctrl+Shift+Arrow to select to edge, Ctrl+Home to A1, F2 to edit, Alt+= for AutoSum, Ctrl+; for today's date.

What is the F4 key in Excel?

Two things. In a formula, toggles absolute/relative references (=A1 → =$A$1 → =A$1 → =$A1). Outside a formula, repeats the last action — apply a fill color once, then F4 to reapply on any other cell.

How do I add a row in Excel with a keyboard shortcut?

Shift+Space to select the whole row, then Ctrl+Plus to insert. Ctrl+Minus deletes. Same pattern with Ctrl+Space for columns.

What is the Ctrl+Shift+L shortcut in Excel?

Toggles AutoFilter on/off for the current range. Instant filter dropdowns on any header row.

Are Excel shortcuts the same on Mac?

Mostly — Ctrl becomes Cmd, Alt becomes Option. Some differ (Ctrl+Shift+L on Windows is Cmd+Shift+F on Mac). Ribbon Alt sequences don't work on Mac.