ReferenceFree · No signup

Excel Shortcuts Cheat Sheet

Ninety-plus shortcuts, searchable by task and switchable between Windows and Mac. Learn the ten that save the most time, then look up the rest as you need them.

Runs in your browserUpdated October 25, 202690+ shortcuts · Windows and Mac · Searchable by task

The short answer

The most useful Excel shortcuts are Ctrl+Arrow to jump to data edges, Ctrl+Shift+Arrow to select a block, Alt+= to insert a SUM, Ctrl+1 for Format Cells, F4 to lock references, Ctrl+Shift+L for filters and Ctrl+E for Flash Fill. On Mac, substitute Cmd for Ctrl except where noted.

Platform

Start with these seven

Jump to the edge of the data regionCtrl+Arrow

Select to the edge of the data regionCtrl+Shift+Arrow

Select the entire rowShift+Space

Select the entire columnCtrl+Space

Edit the active cellF2

Flash Fill — auto-complete a patternCtrl+E

Paste SpecialCtrl+Alt+V

AutoSum the column or row aboveAlt+=

99 shortcutsWindows / Excel 365

Ctrl+ArrowJump to the edge of the data regionNavigation
Ctrl+HomeGo to cell A1Navigation
Ctrl+EndGo to the last used cellNavigation
Ctrl+Page DownMove to the next worksheetNavigation
Ctrl+Page UpMove to the previous worksheetNavigation
Ctrl+GOpen Go To (jump to a cell or named range)Navigation
Ctrl+FFind text or valuesNavigation
Ctrl+HFind and replaceNavigation
Ctrl+TabSwitch to the next open workbookNavigation
Alt+Page DownMove one screen to the rightNavigation
Alt+Page UpMove one screen to the leftNavigation
F5Open Go ToNavigation
Ctrl+Shift+ArrowSelect to the edge of the data regionSelection
Ctrl+ASelect the current region (press twice for the whole sheet)Selection
Shift+SpaceSelect the entire rowSelection
Ctrl+SpaceSelect the entire columnSelection
Ctrl+Shift+EndSelect from the active cell to the last used cellSelection
Ctrl+Shift+HomeSelect from the active cell to A1Selection
Alt+;Select visible cells only (skips hidden rows)Selection
F8Turn on Extend Selection modeSelection
Ctrl+ClickAdd non-adjacent cells to the selectionSelection
Shift+ClickExtend the selection to the clicked cellSelection
F2Edit the active cellEditing
Alt+EnterInsert a line break inside a cellEditing
Ctrl+EnterFill every selected cell with the current entryEditing
Ctrl+DFill down from the cell aboveEditing
Ctrl+RFill right from the cell to the leftEditing
Ctrl+EFlash Fill — auto-complete a patternEditing
Ctrl+ZUndoEditing
Ctrl+YRedoEditing
Ctrl+CCopyEditing
Ctrl+XCutEditing
Ctrl+VPasteEditing
Ctrl+Alt+VPaste SpecialEditing
Ctrl+Shift+VPaste values only (where supported)Editing
DeleteClear the contents of the selectionEditing
Ctrl+-Delete cells, rows or columnsEditing
Ctrl+Shift++Insert cells, rows or columnsEditing
Ctrl+'Copy the formula from the cell aboveEditing
Ctrl+Shift+"Copy the value from the cell aboveEditing
Ctrl+;Insert today's dateEditing
Ctrl+Shift+;Insert the current timeEditing
Ctrl+KInsert or edit a hyperlinkEditing
Ctrl+TCreate a table from the selected rangeEditing
Alt+=AutoSum the column or row aboveEditing
Ctrl+1Open Format CellsFormatting
Ctrl+BBoldFormatting
Ctrl+IItalicFormatting
Ctrl+UUnderlineFormatting
Ctrl+Shift+$Apply currency formatFormatting
Ctrl+Shift+%Apply percentage formatFormatting
Ctrl+Shift+#Apply date formatFormatting
Ctrl+Shift+!Apply number format with two decimalsFormatting
Ctrl+Shift+~Apply General formatFormatting
Ctrl+Shift+&Add an outline borderFormatting
Ctrl+Shift+_Remove all bordersFormatting
Ctrl+9Hide the selected rowsFormatting
Ctrl+Shift+9Unhide rowsFormatting
Ctrl+0Hide the selected columnsFormatting
Ctrl+Shift+0Unhide columns (may be blocked by Windows)Formatting
Alt+H+O+IAutoFit column widthFormatting
Alt+H+O+AAutoFit row heightFormatting
Alt+=Insert AutoSumFormulas
F4Toggle absolute / relative reference while editingFormulas
F9Calculate all open workbooks (or evaluate part of a formula)Formulas
Shift+F9Calculate the active worksheetFormulas
Ctrl+`Show formulas instead of resultsFormulas
Ctrl+Shift+EnterEnter a legacy array formulaFormulas
Ctrl+Shift+AShow argument names after typing a functionFormulas
F3Paste a defined name into the formulaFormulas
Ctrl+F3Open the Name ManagerFormulas
Ctrl+Shift+UExpand or collapse the formula barFormulas
F4Repeat the last action (outside edit mode)Formulas
Ctrl+Shift+LTurn filters on or offData
Alt+DownOpen the filter dropdown for the active cellData
Alt+F1Create an embedded chart from the selectionData
F11Create a chart on its own sheetData
Ctrl+Shift+F3Create names from the selected row or column labelsData
Ctrl+Shift+*Select the current region around the active cellData
Ctrl+8Show or hide outline symbolsView
Ctrl+6Show or hide objects and chartsView
Ctrl+F1Show or hide the ribbonView
Ctrl+Mouse wheelZoom in or outView
Alt+W+F+FFreeze panes at the active cellView
Ctrl+Shift+F1Toggle full screenView
Ctrl+NCreate a new workbookFiles
Ctrl+OOpen a workbookFiles
Ctrl+SSaveFiles
F12Save AsFiles
Ctrl+PPrintFiles
Ctrl+WClose the workbookFiles
Alt+F4Close ExcelFiles
AltShow Key Tips for the ribbonRibbon
Alt+HOpen the Home tabRibbon
Alt+NOpen the Insert tabRibbon
Alt+MOpen the Formulas tabRibbon
Alt+AOpen the Data tabRibbon
Alt+WOpen the View tabRibbon
Alt+QSearch the ribbon (Tell Me / Search)Ribbon

Some function keys need Fn on laptops, and a few combinations are reserved by Windows or macOS. Mac Excel also varies by version — check Help → Keyboard Shortcuts for the authoritative list in your build.

How to use it

1Search for the task you are doing, e.g. “filter”, “paste values” or “insert row”.
2Switch between Windows and Mac to see the correct modifier keys.
3Filter by category when you want to learn a whole workflow.
4Copy a shortcut and keep the page open while you practise it.

Questions about the shortcut finder

What are the most important Excel shortcuts?

Learn Ctrl+Arrow (jump to the edge of data), Ctrl+Shift+Arrow (select to the edge), Alt+= (AutoSum), F4 (lock a reference), Ctrl+1 (Format Cells), Ctrl+Shift+L (filters) and Ctrl+E (Flash Fill). Those seven cover most daily work.

Do Mac Excel shortcuts use Cmd or Ctrl?

Most use Cmd instead of Ctrl, for example Cmd+C, Cmd+Z and Cmd+Arrow. A few keep Ctrl, including Ctrl+Option+Arrow for grouping and some function-key combinations. The platform switch in the tool shows the correct keys.

How do I lock a cell reference quickly?

Put the cursor on the reference in the formula bar and press F4. Each press cycles through absolute ($A$1), mixed ($A1, A$1) and relative (A1). On Mac, use Cmd+T if F4 is mapped to a system key.

Why do some shortcuts not work on my laptop?

Function-key shortcuts may require Fn, and some are claimed by Windows, macOS or your keyboard software. Excel's own list (Help → Keyboard shortcuts) reflects your exact version and locale.

Need it done for you?

Shortcuts save minutes. A expert saves the night.

If the deadline is closer than the learning curve, send the assignment. Tested solutions with explanations, from $15/hr.

Get a fixed quote Ask on WhatsApp See pricing →

From $15/hr
Fixed quote before work starts
Free minor revisions
Human experts, not AI files

Related free tools

All tools →

Formula ExplainerPaste any Excel formula and get a plain-English explanation of every function, range and nested step.Open tool →Formula CheckerCheck any Excel formula for syntax errors, wrong argument counts, approximate-match traps and #REF! errors.Open tool →Formula GeneratorBuild accurate Excel formulas from plain choices: SUMIF, SUMIFS, COUNTIF, IF, IFERROR, TEXTJOIN, INDEX MATCH and more.Open tool →

Keep reading