Excel's documented keymap is long, and most of it is not worth memorising. What is worth learning falls into three groups: moving and selecting across large ranges without scrolling, entering data without reaching for the mouse, and the format toggles you apply dozens of times a day. Windows and Mac bindings sit side by side; many Mac keys keep Ctrl or take Cmd, some change entirely, and the Mac list has neither ribbon key tips nor Power Pivot keys.
295 shortcuts in 21 sections.Checked row by row against Microsoft Support on .Edited by Jay.
Cell Editing & Input 27
Action
Windows
Mac
Edit CellEnter edit mode for selected cell.
F2
F2
Edit in Formula BarEdit the active cell from the formula bar; while already editing, switch focus between the bar and the cell.
Ctrl+F2
—
Confirm & Move DownCompletes the entry and, by default, selects the cell below; inside a selected range it steps from top to bottom.
Enter
Return
Confirm & Move UpFinishes the entry, then goes up instead: to the cell above, or bottom to top through a selected range.
Shift+Enter
Shift+Return
Confirm & Move RightAccepts what you typed and selects the cell to the right; on a protected sheet it jumps between unlocked cells.
Tab
Tab
Confirm & Move LeftMoves back one cell to the left after confirming the entry; in a dialog box, returns to the previous option.
Shift+Tab
Shift+Tab
Cancel EntryDiscard what you are typing and leave the cell as it was.
Esc
Esc
New Line in CellInsert line break within same cell.
Alt+Enter
Option+ReturnorCtrl+Option+Return
Fill SelectionFill all selected cells with same value.
Ctrl+Enter
Cmd+ReturnorCtrl+Return
Fill DownCopy top cell content down to selected range.
Ctrl+D
Cmd+DorCtrl+D
Fill RightCopy left cell content right to selected range.
Ctrl+R
Cmd+RorCtrl+R
Copy Formula from AboveCopy the formula of the cell directly above into the active cell.
Ctrl+'
Ctrl+'
Copy Value from AboveCopy the value of the cell directly above into the active cell.
Ctrl+Shift+"
Ctrl+Shift+"
Today's DateInsert current date as fixed value.
Ctrl+;
Ctrl+;
Current TimeInsert current time as fixed value.
Ctrl+Shift+:
Cmd+;
Delete ContentEmpties the selected cells of data and formulas; formats, comments and notes stay as they are.
Delete
Delete
Clear Cell or Delete LeftClear the active cell, or erase the character before the cursor while editing.
Backspace
Delete
Delete Character to the RightWhile editing a cell, erase the character after the cursor (the forward-delete key on full-size Mac keyboards).
Delete
Fn+Delete
Delete Cells/Rows/ColumnsOpens the Delete dialog box, where you choose how the remaining cells shift or remove an entire row or column.
Ctrl+-
Cmd+-orCtrl+-
Insert Cells/Rows/ColumnsBlank cells are added through the Insert dialog box, which asks which way the existing cells should shift.
Ctrl+Shift++
Ctrl+Shift+=
Undo Last ActionEach press steps one more change back through the edit history of the workbook.
Ctrl+Z
Cmd+ZorCtrl+Z
Redo or RepeatRedo what was undone, or run the last command again when it can be repeated.
Ctrl+Y
Cmd+YorCtrl+YorCmd+Shift+Z
Repeat Last ActionRun the previous command or action again, when Excel can repeat it.
F4
—
Insert HyperlinkOpen the dialog for adding a link to the cell.
Ctrl+K
Cmd+KorCtrl+K
Insert or Edit NoteAdd a note to the cell, or open its existing note for editing.
Shift+F2
Shift+F2
Threaded CommentStart a threaded comment on the cell, or open the thread to reply.
Ctrl+Shift+F2
Cmd+Shift+F2
Check SpellingRun the spelling checker on the active sheet or the selected range.
F7
F7
Clipboard & Paste Special 16
Action
Windows
Mac
Copy CellsPuts the selection on the clipboard and leaves the original cells unchanged, ready to paste elsewhere.
Ctrl+C
Cmd+CorCtrl+C
Cut CellsCut the selected cells so they can be pasted somewhere else.
Ctrl+X
Cmd+XorCtrl+X
Paste CellsPaste the clipboard contents over the current selection.
Ctrl+V
Cmd+VorCtrl+V
Paste SpecialOpen the Paste Special dialog to choose which part of the copied data to paste.
Ctrl+Alt+V
Cmd+Ctrl+VorCtrl+Option+VorCmd+Option+V
Paste Special (Legacy Keys)Older menu-style key sequence that opens the same Paste Special dialog.
AltthenEthenS
—
Paste AllIn the Paste Special dialog, paste contents and formatting together.
A
—
Paste FormulasIn the Paste Special dialog, paste only the formulas as they were typed.
F
—
Paste ValuesIn the Paste Special dialog, paste the results only, leaving the formulas behind.
V
—
Paste FormatsIn the Paste Special dialog, paste only the formatting of the copied cells.
T
—
Paste Comments and NotesIn the Paste Special dialog, paste only the comments and notes of the copied cells.
C
—
Paste ValidationIn the Paste Special dialog, paste only the data validation rules.
N
—
Paste All with Source FormattingIn the Paste Special dialog, paste contents together with the formatting carried by the copied cells.
H
—
Paste All Except BordersIn the Paste Special dialog, paste everything apart from the cell borders.
X
—
Paste Column WidthsIn the Paste Special dialog, apply only the column widths of the copied cells.
W
—
Paste Formulas and Number FormatsIn the Paste Special dialog, paste formulas along with their number formats.
R
—
Paste Values and Number FormatsIn the Paste Special dialog, paste values along with their number formats, without formulas.
U
—
Cell Formatting 11
Action
Windows
Mac
Format CellsOpen Format Cells dialog for all formatting options.
Ctrl+1
Cmd+1orCtrl+1
Font SettingsOpen the Format Cells dialog to set font options.
Ctrl+Shift+F
—
BoldMake selected text bold or unbold.
Ctrl+BorCtrl+2
Cmd+BorCtrl+B
ItalicMake selected text italic or remove italic.
Ctrl+IorCtrl+3
Cmd+IorCtrl+I
UnderlineAdd or remove underline from text.
Ctrl+UorCtrl+4
Cmd+U
StrikethroughAdd or remove strikethrough from text.
Ctrl+5
Cmd+Shift+X
Apply BorderAdds an outline border, a line around the outer edge of the selection rather than around every cell.
Ctrl+Shift+&
Cmd+Option+0
Remove BorderTakes the outline border off the selected cells, the reverse of Apply Border.
Ctrl+Shift+_
Cmd+Option+-
Borders MenuOpen the Home tab's border options for the selected cells.
AltthenHthenB
—
Fill ColorOpens the Fill Color palette on the Home tab so a background shade can be picked for the selected cells.
AltthenHthenH
—
Center AlignCenter the contents of the selected cells.
AltthenHthenAthenC
Cmd+E
Number Formatting 7
Excel for Mac keeps these on Ctrl + Shift; they do not move to Cmd.
Action
Windows
Mac
Thousand SeparatorApplies the Number format, which shows two decimals, a thousands separator and a leading minus on negative values.
Ctrl+Shift+!
Ctrl+Shift+!
Currency FormatUses two decimal places and puts negative numbers in parentheses, also in red on Mac.
Ctrl+Shift+$
Ctrl+Shift+$
Percentage FormatDisplays values as percentages with no decimal places, so 0.25 reads as 25%.
Ctrl+Shift+%
Ctrl+Shift+%
Scientific FormatShows the selected numbers in exponential notation with two decimals, such as 1.23E+04.
Ctrl+Shift+^
Ctrl+Shift+^
Date FormatApply date format (day-month-year).
Ctrl+Shift+#
Ctrl+Shift+#
Time FormatShows the hour and minute followed by AM or PM, for example 1:30 PM.
Ctrl+Shift+@
Ctrl+Shift+@
General FormatResets the selected cells to General, the default with no fixed decimals, currency symbol or date pattern.
Ctrl+Shift+~
Ctrl+Shift+~
Navigation & Movement 17
Action
Windows
Mac
Move One CellMove the active cell one step up, down, left or right.
Arrow keys
Arrow keys
Jump to EdgeJump to edge of data region in arrow direction.
Ctrl+Arrow
Cmd+Arrow
End Mode JumpPress End, then an arrow key, to land on the next filled cell in that direction.
EndthenArrow
—
Start of RowGo to first column of current row.
Home
HomeorFn+Left
Go to A1Jump to cell A1 (start of worksheet).
Ctrl+Home
Ctrl+HomeorCtrl+Fn+Left
Last CellLands where the lowest used row meets the rightmost used column, even if that cell itself is empty.
Ctrl+End
Ctrl+EndorCtrl+Fn+Right
Screen DownMoves the active cell down by a full window of rows; MacBook keyboards use the Fn form.
Page Down
Page DownorFn+Down
Screen UpSends the active cell up by a full window of rows, the reverse of Screen Down.
Page Up
Page UporFn+Up
Screen RightJump one full screen to the right.
Alt+Page Down
Option+Page DownorOption+Fn+Down
Screen LeftJump one full screen to the left.
Alt+Page Up
Option+Page UporOption+Fn+Up
Next SheetActivates the worksheet tab to the right of the current one in the same workbook.
Ctrl+Page Down
Ctrl+Page DownorOption+Right
Previous SheetGoes one tab to the left in the sheet tab bar, staying in the same workbook.
Ctrl+Page Up
Option+Left
Next Unlocked CellOn a protected sheet, move to the next cell that is not locked.
Tab
Tab
Top-Left Cell of WindowWith Scroll Lock on, jump to the top-left cell currently visible in the window.
Home
—
Scroll HorizontallyTurn the mouse wheel up to move left and down to move right.
Ctrl+Shift+Scroll
Shift+Scroll
Zoom InIncrease the zoom level of the worksheet.
Ctrl+Alt+=
—
Zoom OutDecrease the zoom level of the worksheet.
Ctrl+Alt+-
—
Selection 13
On a Mac, Microsoft flags Ctrl + Space, F11 and Shift + F11 as clashing with default macOS shortcuts. If one does not reach Excel, turn off the system shortcut in System Settings > Keyboard > Keyboard Shortcuts.
Action
Windows
Mac
Select AllInside a data range, the first press selects the current region and repeated presses extend to the whole worksheet.
Ctrl+A
Cmd+AorCmd+Shift+Space
Select Data RegionWorks when the sheet contains data: the first press takes the current region, further presses widen it to the whole sheet.
Ctrl+Shift+Space
Cmd+A
Select Current RegionSelect the block of data that surrounds the active cell.
Ctrl+Shift+*
—
Select ColumnSelects the whole column of the active cell; on a Mac the keys can clash with a macOS system shortcut.
Ctrl+Space
Ctrl+Space
Select RowCovers the full row of the active cell; when several cells are selected, every row they touch is taken.
Shift+Space
Shift+Space
Extend SelectionGrows the selected range by one cell in the direction of the arrow pressed.
Shift+Arrow
Shift+Arrow
Extend to EdgeReaches the last filled cell in that direction, or the next filled cell when the adjacent one is empty.
Ctrl+Shift+Arrow
Cmd+Shift+Arrow
Select to A1The selection grows from the active cell to the start of the sheet, covering every row and column in between.
Ctrl+Shift+Home
Ctrl+Shift+HomeorCtrl+Shift+Fn+Left
Select to LastSelect from current cell to last used cell.
Ctrl+Shift+End
Ctrl+Shift+EndorCtrl+Shift+Fn+Right
Extend ModeSwitch extend mode on so the arrow keys grow the selection; press again to switch it off.
F8
F8
Add to SelectionKeep the current selection and start a second, separate one with the arrow keys.
Shift+F8
Shift+F8
Add Next Sheet to SelectionSelect the current sheet together with the one after it.
Ctrl+Shift+Page Down
—
Add Previous Sheet to SelectionSelect the current sheet together with the one before it.
Ctrl+Shift+Page Up
—
Formulas & Functions 18
On a Mac, a function key that does nothing in Excel usually needs Fn held as well, unless macOS is set to use F1, F2, etc. as standard function keys.
Action
Windows
Mac
Start FormulaTyped as the first character of a cell, it tells Excel the entry is a formula, not text.
=
=
AutoSumInserts a SUM formula and proposes the adjacent numbers above or to the left as its range.
Alt+=
Cmd+Shift+T
Insert FunctionOpen the function picker: Insert Function on Windows, Formula Builder on a Mac.
Shift+F3
Shift+F3
Function ArgumentsAfter typing a function name, open the dialog that walks through its arguments.
Ctrl+A
Ctrl+A
Insert Argument NamesAfter typing a function name, add its argument names and parentheses.
Ctrl+Shift+A
—
Toggle ReferenceToggle between absolute/relative reference types ($A$1, A$1, $A1, A1).
F4
Cmd+TorF4
Paste NameLists the workbook's defined names so one can be inserted into a formula; does nothing if none exist.
F3
—
Define NameGive the selection a name that formulas can refer to.
AltthenMthenMthenD
Ctrl+L
Show FormulasToggle between showing values and formulas.
Ctrl+`
Ctrl+`
Calculate AllRecalculate every worksheet in all open workbooks.
F9
Cmd+=orF9
Calculate SheetRecalculates only the active worksheet, while F9 alone recalculates every sheet in all open workbooks.
Shift+F9
Shift+F9
Force CalculateRecalculates every formula in all open workbooks, even where nothing has changed since the previous calculation.
Ctrl+Alt+F9
Ctrl+Option+F9
Rebuild and CalculateRecheck dependent formulas, then calculate every cell in all open workbooks.
Ctrl+Alt+Shift+F9
Ctrl+Option+Shift+F9
Expand Formula BarMake the formula bar taller, or collapse it again.
Ctrl+Shift+U
Ctrl+Shift+U
Formula TooltipsSwitch the formula-checking tooltips on or off.
Ctrl+Alt+P
Ctrl+Option+P
End of Formula Bar TextIn the formula bar, jump to the last character of the entry.
Ctrl+End
—
Select to End of Formula BarIn the formula bar, select everything from the cursor to the end.
Ctrl+Shift+End
—
Error Checking MenuOpen the menu of an Error Checking button; on a Mac, the pop-up menu of an on-object button.
Alt+Shift+F10
Option+Shift+F10
Data Management 18
Action
Windows
Mac
Create TableConvert selected range to Excel table.
Ctrl+T
Cmd+TorCtrl+T
Create Table (Alternate)Second Windows key combination for the Create Table dialog.
Ctrl+L
—
Toggle FilterAdds filter dropdown arrows to the header row of the current range, or removes them if present.
Ctrl+Shift+L
Cmd+Shift+ForCtrl+Shift+L
Open FilterOpen filter dropdown for selected column.
Alt+Down
Option+Down
Number or Text FiltersOpens the filter menu, then its Number Filters submenu, or Text Filters when the column contains text.
Alt+DownthenF
—
Filter by ColorFrom the open filter menu, go to the filter-by-color choices.
Alt+DownthenI
—
Sort A to ZSort the column in ascending order: A first, or lowest number first.
AltthenAthenSthenAorAlt+DownthenS
—
Sort Z to ASort the column in descending order: Z first, or highest number first.
AltthenAthenSthenDorAlt+DownthenO
—
Sort DialogOpen the Sort dialog to define a custom sort.
AltthenAthenSthenSorAltthenHthenSthenU
Cmd+Shift+R
Reapply SortRun the current sort again after the data has changed.
Ctrl+Alt+LorAltthenAthenYthen3
—
Open Validation ListOn a cell with data validation, open its list of allowed choices.
Alt+Down
—
Quick AnalysisShow the Quick Analysis options for the selected data.
Ctrl+Q
—
Flash FillFill the current column by following the pattern Excel detects in the adjacent columns.
Ctrl+E
Ctrl+E
Refresh DataRefresh external data on the current worksheet.
Ctrl+F5
—
Refresh AllRefresh every external data source in the workbook.
Ctrl+Alt+F5
—
Stop RefreshCancel a refresh that is still running.
Esc
—
Power Query EditorBrings up the editor window where queries shape imported data before it is loaded into the workbook.
Alt+F12
Option+F12
Next Record in Data FormIn a data form, go to the first field of the following record.
Enter
—
Find & Replace 4
Action
Windows
Mac
FindOpen Find dialog to search for data.
Ctrl+F
Ctrl+ForShift+F5
ReplaceOpens the Find and Replace dialog box on its Replace tab, ready for the search and replacement text.
Ctrl+H
Ctrl+HorCmd+Shift+H
Go ToOpen Go To dialog to jump to specific cell.
Ctrl+G
Ctrl+G
Go ToSame as Ctrl+G - opens Go To dialog.
F5
F5
Row/Column Management 7
Action
Windows
Mac
Hide RowsHides each row the selection touches, so one selected cell is enough to hide its whole row.
Ctrl+9
Ctrl+9
Hide ColumnsApplies to every column that holds a selected cell; nothing is deleted, the columns are only taken out of view.
Ctrl+0
Ctrl+0
Outline SymbolsShow or hide the outline symbols beside grouped rows and columns.
Ctrl+8
Ctrl+8
Expand GroupHover over collapsed grouped rows or columns, hold Shift and scroll down to expand them.
Shift+Scroll Down
—
Collapse GroupHover over expanded grouped rows or columns, hold Shift and scroll up to collapse them.
Shift+Scroll Up
—
Delete ColumnDelete the selected column through the Home tab's Delete menu.
AltthenHthenDthenC
—
Move and Insert CellsDrag selected cells, rows or columns with Shift held to insert them at the drop point.
Shift+Drag
Shift+Drag
Workbook Management 14
Action
Windows
Mac
New WorkbookStarts an empty workbook from the blank workbook template; the workbook you were editing stays open.
Ctrl+N
Cmd+NorCtrl+N
OpenShows the Open screen or dialog box, where a recent or saved workbook can be chosen.
Ctrl+O
Cmd+OorCtrl+O
SaveSaves the workbook under its current name; a workbook that was never saved asks for a name and location first.
Ctrl+S
Cmd+SorCtrl+S
Save AsBrings up the Save As dialog box so the workbook can be stored under another name, location or file type.
F12
Cmd+Shift+SorF12
PrintShows the print preview and printer settings; nothing is printed until the Print button is chosen there.
Ctrl+P
Cmd+PorCtrl+P
CloseCloses only the active workbook window, prompting to save unsaved changes, and leaves Excel running.
Ctrl+W
Cmd+WorCtrl+W
Close WindowShuts the selected workbook window while Excel keeps running; on Mac it also dismisses a dialog box.
Ctrl+F4
Cmd+F4
Exit ExcelCloses every open workbook and ends the program, prompting to save any that have unsaved changes.
Alt+F4
Cmd+Q
New SheetAdds a blank worksheet in front of the active sheet and makes it the active one.
Shift+F11
Shift+F11
New Sheet (Alternate)Second Windows key combination that inserts a worksheet.
Alt+Shift+F1
—
VBA EditorOpens the Visual Basic for Applications window, where the macros and modules of open workbooks are written and edited.
Alt+F11
Option+F11
Macro DialogOpen the Macro dialog, where macros are run and managed.
Alt+F8
Option+F8
Excel HelpOpens the built-in Help for Excel, where articles can be searched by topic or keyword.
F1
F1orCmd+/
Workbook StatisticsBring up the Workbook Statistics dialog.
Ctrl+Shift+G
—
Window Management 13
Action
Windows
Mac
Next WindowAlternates between two open Excel windows; adding Shift steps through all of them instead.
Ctrl+F6
—
Cycle All WindowsStep through all open Excel windows.
Ctrl+Shift+F6
—
Switch WorkbooksWith no dialog box open, alternates between two Excel windows; inside a dialog box it moves to the next tab.
Ctrl+Tab
—
Cycle All Windows (Tab Key)With no dialog box open, step through all open Excel windows.
Ctrl+Shift+Tab
—
Next PaneMove focus to the next area: worksheet, ribbon, task pane, then zoom controls or status bar.
F6
F6
Previous PaneMove focus through the same areas in the opposite direction.
Shift+F6
Shift+F6
MinimizeShrinks the active workbook window out of view to the taskbar or Dock without closing the workbook.
Ctrl+F9
Ctrl+F9
MaximizeEnlarges the workbook window to fill the screen, or returns it to its previous size when already maximized.
Ctrl+F10
Ctrl+F10orCmd+F10
Restore Window SizePut the selected workbook window back to its restored, non-maximized size.
Ctrl+F5
—
Move WindowStart the Move command for a workbook window that is not maximized.
Ctrl+F7
—
Resize WindowStart the Size command for a workbook window that is not maximized.
Ctrl+F8
—
Window Control MenuShow the Control menu of the Excel window.
Alt+Space
—
Full ScreenSwitch full screen mode on or off.
Ctrl+Shift+F1
Cmd+Ctrl+F
Ribbon & Key Tips 22
Key tips are sequences, not chords: Alt shows letters on the ribbon and you press them one after another. Microsoft's Mac list has no key tips, so the key-tip rows have no Mac entry.
Action
Windows
Mac
Show Key TipsShow the key tip letters on the ribbon and activate its tabs.
AltorF10
—
File MenuAccess key for the File menu, the full-window view that holds Open, Save As, Print and Options.
AltthenF
—
Home TabOpen the Home tab: text and number formatting and the Find tool.
AltthenH
—
Insert TabOpen the Insert tab: PivotTables, charts, pictures, shapes and text boxes.
AltthenN
—
Page Layout TabOpen the Page Layout tab: themes, page setup, scaling and alignment.
AltthenP
—
Formulas TabOpen the Formulas tab: insert and trace functions and control calculation.
AltthenM
—
Data TabOpen the Data tab: connections, sorting, filtering and analysis tools.
AltthenA
—
Review TabOpen the Review tab: spelling, notes, comments and sheet protection.
AltthenR
—
View TabOpen the View tab: page break previews, gridlines, zoom, panes and macros.
AltthenW
—
Search BoxJump to the Search (or Tell Me) box on the ribbon, then type what you are looking for.
AltthenQ
—
Normal ViewShow the sheet in Normal view.
AltthenWthenL
—
Page Layout ViewShow the sheet in Page Layout view.
AltthenWthenP
—
Page Break PreviewShow the sheet in Page Break Preview.
AltthenWthenI
—
Toggle RibbonCollapses the ribbon to its tab names to free up rows, or expands it again.
Ctrl+F1
Cmd+Option+R
Move Through Ribbon CommandsMove focus forward or backward through the commands on the ribbon or an add-in pane.
TaborShift+Tab
—
Move Among Ribbon ItemsStep from one ribbon item to the next in the direction of the arrow.
Arrow keys
—
Previous or Next TabWith the ribbon selected, move to the tab on the left or right.
LeftorRight
—
Jump Between Ribbon GroupsMove from one group of ribbon controls to the next or previous group.
Ctrl+LeftorCtrl+Right
—
Activate ButtonTrigger the ribbon button that has focus.
SpaceorEnter
—
Open Command ListOpen the list belonging to the selected ribbon command.
Down
—
Open Button MenuOpen the menu attached to the selected ribbon button.
Alt+Down
—
Show TooltipShow the tooltip of the ribbon element that has focus.
Ctrl+Shift+F10
—
Menus & Dialog Boxes 15
Action
Windows
Mac
Context MenuOpen the right-click menu for the selected item.
Shift+F10orMenu
Shift+F10
Next or Previous Menu CommandIn an open menu or submenu, move to the following or preceding command.
DownorUp
—
Switch Menu and SubmenuMove between a main menu and its open submenu.
LeftorRight
—
First Menu CommandSelect the first command of the visible menu or submenu.
Home
—
Last Menu CommandSelect the last command of the visible menu or submenu.
End
—
Open Menu or Run CommandWorks after the menu bar has been activated: a selected menu opens and a selected command is carried out.
Enter
—
Default Dialog ButtonIn a dialog box, press the default button, usually OK.
Enter
Return
Close Menu or DialogDismiss whatever menu, dialog box or message window is open.
Esc
Esc
Next Dialog OptionMove to the following option or group of options in a dialog box.
Tab
Tab
Previous Dialog OptionMove back to the preceding option in a dialog box.
Shift+Tab
Shift+Tab
Next Dialog TabGo to the following tab of a dialog box.
Ctrl+Tab
—
Previous Dialog TabGo back to the preceding tab of a dialog box.
Ctrl+Shift+Tab
—
Move Between OptionsIn a dialog box, move among the items of an open list or an option group.
Arrow keys
—
Open Drop-Down ListIn a dialog box, expands the drop-down list that has focus so the arrow keys can move through its options.
DownorAlt+Down
—
Press Button or Toggle CheckboxIn a dialog box, press the selected button, or tick or clear a checkbox.
Space
—
Charts & Objects 6
Action
Windows
Mac
ChartPlaces a chart of the default type on the same worksheet, built from the current data range.
Alt+F1
—
Chart SheetChart the current range on a separate chart sheet.
F11
F11
Toggle Object DisplayCycle between hiding objects, showing them, and showing placeholders.
Ctrl+6
Ctrl+6
Cycle Floating ShapesPut focus on a floating shape (text box, picture and so on); each further Tab moves to the next shape.
Ctrl+Alt+5thenTab
—
Exit Shape NavigationLeave floating-shape navigation and go back to moving between cells.
Esc
—
Select All ObjectsWith one object selected, select every object on the sheet.
Ctrl+Shift+Space
—
Copilot in Excel 9
Action
Windows
Mac
Open Copilot PaneShows the task pane where you type prompts for Copilot in Excel and read its responses.
Alt+C
Cmd+Ctrl+I
Send PromptSend the prompt typed in the Copilot task pane.
Enter
Return
Stop RequestHalt the Copilot request that is in progress.
Esc
Esc
Accept ChangesKeep the changes Copilot made to the workbook.
Ctrl+Enter
Cmd+Return
Switch Copilot ModeCycle the Copilot pane between edit, chat and plan modes.
Ctrl+Shift+M
Cmd+Shift+M
Browse Chat ResponsesMove between the responses in the Copilot chat.
Alt+C
Option+C
Confirm Selected FilesConfirm that Copilot may use the files selected in the pane.
Ctrl+J
Cmd+J
Start DictationBegin dictating to Copilot instead of typing.
Alt+Shift+H
Option+Shift+H
Switch Grid and CopilotMove focus between the worksheet grid and the Copilot pane.
F6
Shift+F6
Power Pivot 27
Action
Windows
Mac
Select TableSelect the whole table in the Power Pivot window.
Ctrl+A
—
Select Current ColumnSelect the column that holds the active cell.
Ctrl+Space
—
Select Current RowSelect the row that holds the active cell.
Shift+Space
—
Select to Bottom of ColumnSelect everything from the active cell down to the bottom of its column.
Shift+Page Down
—
Select to Top of ColumnSelect everything from the active cell up to the top of its column.
Shift+Page Up
—
Select to End of RowSelect everything from the active cell to the end of its row.
Shift+End
—
Select to Start of RowSelect everything from the active cell back to the start of its row.
Shift+Home
—
First Cell of TableJump to the upper-left cell of the selected table.
Ctrl+Home
—
Last Cell of TableJump to the lower-right cell of the selected table.
Ctrl+End
—
First Cell of RowGo to the start of the selected row.
Ctrl+Left
—
Last Cell of RowGo to the end of the selected row.
Ctrl+Right
—
First Cell of ColumnGo to the top of the selected column.
Ctrl+Up
—
Last Cell of ColumnGo to the bottom of the selected column.
Ctrl+Down
—
Previous TableGoes one table back in the Power Pivot window, where each table sits on its own tab.
Ctrl+Page Up
—
Next TableShows the table after the current one in the Power Pivot window, the next tab along the bottom.
Ctrl+Page Down
—
Copy DataPlaces a copy of the data selected in the Power Pivot window on the clipboard.
Ctrl+C
—
Delete TableRemoves the table that is open in the Power Pivot window from the Data Model.
Ctrl+D
—
Move TableMove the current table to another position.
Ctrl+M
—
Rename TableStarts renaming the table that is active in the Power Pivot window.
Ctrl+R
—
Save FileSave the file from the Power Pivot window.
Ctrl+S
—
Undo in Power PivotReverse the last action in Power Pivot.
Ctrl+Z
—
Redo in Power PivotRedo the action that was just undone in Power Pivot.
Ctrl+Y
—
Cell Context MenuShow the right-click menu for whatever cell, column or row is selected.
Shift+F10
—
AutoFilter MenuOpen the AutoFilter menu for the column.
Alt+Down
—
Go To DialogOpen the Go To dialog in the Power Pivot window.
F5
—
Recalculate FormulasRecalculate every formula in the Power Pivot window.
F9
—
Close Dialog or CancelDismiss the open dialog box, or abort an operation in progress such as a paste.
Ctrl+Esc
—
Mac Only: Files, App & Search 15
Action
Windows
Mac
New from TemplateStart a new workbook from a template.
—
Cmd+Shift+P
Save DialogShow the dialog for saving the workbook.
—
Option+F2
Open Dialog (Function Key)Function-key alternative that shows the Open dialog.
—
Cmd+F12
Insert Macro Sheet (Excel 4.0)Adds a sheet for legacy Excel 4.0 macros to the workbook, the macro format that predates VBA.
—
Cmd+F11
Hide ExcelHides every Excel window without quitting; clicking the Dock icon brings them back.
—
Cmd+H
Next ApplicationSwitch to the next open application.
—
Cmd+Tab
Previous ApplicationSwitch back to the previous application.
—
Cmd+Shift+Tab
Take ScreenshotCapture the screen to a file on the desktop.
—
Cmd+Shift+3
Search BoxGo to the search field while a cell is selected or being edited.
—
Cmd+F
Search SheetPut focus in the Search Sheet box.
—
Ctrl+F5
Open ThesaurusBring up the thesaurus to look for synonyms.
—
Shift+F7orCmd+Ctrl+Option+R
Smart LookupBring up the Smart Lookup pane.
—
Cmd+Ctrl+Option+L
Toggle Scroll LockTurn Scroll Lock off or on; some keyboards need Ctrl, Option or Cmd in place of Shift.
—
Shift+F14
Drawing ModeSwitches Drawing mode on with one press and off again with the next.
—
Cmd+Ctrl+Z
Cycle Chart ObjectsStep through the selectable parts of a chart.
—
Arrow keys
Mac Only: Editing & Formulas 12
Action
Windows
Mac
Edit Cell (Cursor at End)Start editing the active cell with the cursor after the last character of the line.
—
Ctrl+U
Line Break (Alternate Keys)Further key combinations Microsoft lists for a line break inside a cell.
—
Cmd+Option+ReturnorCtrl+Option+Return
Delete to End of LineErase everything from the cursor to the line's end (Ctrl with the forward-delete key on full-size keyboards).
—
Ctrl+Fn+Delete
Move Cursor in EntryWhile typing in a cell, move the cursor one character in any direction.
—
Arrow keys
Start of LineWhile editing, put the cursor at the start of the current line.
—
HomeorFn+Left
Insert or Reply to CommentAdd a threaded comment, or a reply to an existing thread.
—
Cmd+Return
Emoji & SymbolsOpen the character viewer to insert symbols or emoji.
—
Cmd+Ctrl+Space
Array FormulaConfirm the entry as an array formula.
—
Cmd+Shift+ReturnorCtrl+Shift+Return
AutoComplete ListShow the AutoComplete list for the cell.
—
Option+Down
Define Name DialogOpens the dialog box where a name is given to a cell, a range or a formula.
—
Cmd+F3
Create NamesOpens the dialog that builds defined names from the row or column labels of the selected range.
—
Cmd+Shift+F3
Show Active CellScroll to make active cell visible.
—
Ctrl+Delete
Mac Only: Formatting 8
Action
Windows
Mac
Increase Font SizeMake the font of the selection one step larger.
—
Cmd+Shift+>
Decrease Font SizeMake the font of the selection one step smaller.
—
Cmd+Shift+<
Align LeftAlign the cell contents to the left.
—
Cmd+L
Modify Cell StyleBring up the dialog for modifying the cell style.
—
Cmd+Shift+L
Right BorderAdd an outline border on the right edge of the selection.
—
Cmd+Option+Right
Left BorderAdd an outline border on the left edge of the selection.
—
Cmd+Option+Left
Top BorderAdd an outline border on the top edge of the selection.
—
Cmd+Option+Up
Bottom BorderAdd an outline border on the bottom edge of the selection.
—
Cmd+Option+Down
Mac Only: Selection, Rows & Columns 16
Action
Windows
Mac
Select to Row StartGrows the selection from the active cell back to the beginning of its row; MacBook keyboards use the Fn form.
—
Shift+HomeorShift+Fn+Left
Extend Down One ScreenGrow the selection downward by one screen.
—
Shift+Page DownorShift+Fn+Down
Extend Up One ScreenGrow the selection upward by one screen.
—
Shift+Page UporShift+Fn+Up
Select Visible CellsNarrow the selection to the cells that are not hidden.
—
Cmd+Shift+*
Keep Only Active CellCollapse a multi-cell selection to just the active cell.
—
Shift+Delete
Select Current ArraySelect the whole array that contains the active cell.
—
Ctrl+/
Select Row DifferencesIn the selected row, pick the cells whose value differs from the active cell.
—
Ctrl+\
Select Direct PrecedentsSelect the cells that formulas in the selection refer to directly.
—
Ctrl+Shift+[
Select All PrecedentsSelect every cell the selection's formulas depend on, directly or indirectly.
—
Ctrl+Shift+{
Select Direct DependentsSelect the cells whose formulas refer straight to the active cell.
—
Ctrl+]
Select All DependentsSelect every cell whose formula depends on the active cell, directly or indirectly.
—
Ctrl+Shift+}
Next Corner of SelectionSend the active cell to the following corner of the selected range, going clockwise.
—
Ctrl+.
Unhide RowsBrings back hidden rows that lie inside the selection, so select the rows on both sides of them first.
—
Cmd+Shift+(orCtrl+Shift+(
Unhide ColumnsShows again any hidden columns within the selection; the selection has to span the columns on either side of them.
—
Cmd+Shift+)orCtrl+Shift+)
Group CellsPut the selected cells into an outline group.
—
Cmd+Shift+K
Ungroup CellsTake the selected cells out of their outline group.
—
Cmd+Shift+J
No row on this page matches that filter.
Notes
Moving across a sheet the way Excel expects
The single most useful key in Excel is Ctrl + Arrow (Cmd + Arrow on a Mac): it jumps to the edge of the current block of data in that direction, so Ctrl + Down lands on the last filled row of a column no matter how long it is. Hold Shift as well — Ctrl + Shift + Arrow, or Cmd + Shift + Arrow on a Mac — and the same jump becomes a selection, which is how you grab an entire column of data in one keystroke. Ctrl + Home returns to A1 and Ctrl + End goes to the last used cell, which is also a quick way to discover that a sheet has stray formatting far below the real data. Ctrl + Page Up and Ctrl + Page Down move between sheets; there is no default shortcut to jump to a sheet by name. Mac keyboards without Home, End and Page keys use Fn with the arrow keys instead, and Microsoft's Mac list adds Option + Left and Option + Right for the previous and next sheet.
Entering data without leaving the keyboard
F2 puts the active cell into edit mode with the cursor at the end, which is what you need to fix a formula without retyping it. Alt + Enter inserts a line break inside a cell — the answer to the most common "how do I make a new line" question. Ctrl + Enter fills every selected cell with what you typed, so selecting a range and typing a formula once is faster than fill-down; Ctrl + D and Ctrl + R copy the top or left cell across a selection when the source already exists. Ctrl + ; enters today's date as a fixed value, unlike a TODAY() formula that changes tomorrow. In Excel for Mac the line break is Option + Return and the fill keys also accept Cmd, but the date shortcut stays on Ctrl — Cmd + ; enters the time instead.
The F4 shortcut does two unrelated things
While editing a formula, F4 cycles the reference under the cursor through the four absolute/relative forms (A1, $A$1, A$1, $A1). Outside edit mode it repeats the last action, so after applying a border to one range you can select another and press F4 to apply the same border. Both behaviours are useful; the confusion comes from expecting one and getting the other. The related number-format shortcuts all use Ctrl + Shift with the symbol printed on the key — Ctrl + Shift + $ for currency, Ctrl + Shift + % for percent, Ctrl + Shift + # for a date — which is easier to remember than it looks. On a Mac the reference toggle is listed as Cmd + T or F4, and the number-format shortcuts keep Ctrl + Shift rather than moving to Cmd.
Tables, filters and the shortcuts that only work inside them
Ctrl + T converts the current region into a structured Table, which changes what several other shortcuts do: Ctrl + A inside a table selects the table first and the whole sheet on a second press, and Ctrl + Space selects the table column rather than the sheet column. Ctrl + Shift + L toggles AutoFilter on any range, and Alt + Down on a header cell opens that column's filter dropdown so you can filter without the mouse. On a Mac the table key is Cmd + T, the filter toggle is Cmd + Shift + F, and Option + Down opens the filter list.
Questions
Why do the Alt, H shortcuts have several letters?
Those are ribbon key tips, not chords. Press Alt, then H for the Home tab, then the letters shown on screen in sequence. They work in any ribbon tab, which is why Alt, H, D, C deletes a column. Microsoft's Mac list has no key tips, so those rows have no Mac entry.
Do these shortcuts work in Excel for Mac?
Use the Mac column, which follows Microsoft's own Mac list. Many shortcuts either work as they are with the Control key (the number formats stay on Ctrl + Shift) or swap Ctrl for Cmd, but others change completely: AutoSum is Cmd + Shift + T and strikethrough is Cmd + Shift + X, and ribbon key tips and the Power Pivot keys have no Mac entry. An empty Mac cell means Microsoft's Mac list does not include that action, and shortcuts it lists only for Mac sit in the Mac Only sections at the end.
What is the fastest way to select a whole column of data?
Put the cursor on the first cell and press Ctrl + Shift + Down (Cmd + Shift + Down on a Mac). That selects to the last filled cell, unlike clicking the column header, which selects a million empty rows too.
How do I insert a line break inside a cell?
Alt + Enter while editing the cell, or Option + Return on a Mac. Enter alone confirms the entry and moves down.
Why does F9 recalculate but my formulas still look stale?
Shift + F9 recalculates only the active sheet and F9 all open workbooks, but neither forces cells Excel believes are already current. Ctrl + Alt + F9 (Ctrl + Option + F9 on a Mac) recalculates everything unconditionally.
Every row on this page was matched to a line in the documentation above on . A binding that could not be found there is not listed.
13 rows from the earlier version of this page were removed in that check: duplicates, and bindings the documentation does not list or lists differently.
Found a wrong or missing key? Tell us and it gets checked against the source. How we verify describes the process and its limits.