Excel Shortcuts
Learn Windows, Mac and Web shortcut mappings.
Open Excel Help
F1 — Opens the Excel Help task pane.
Paste a defined name
F3 — Opens the Paste Name dialog when names exist in the workbook.
Cycle worksheet and interface focus
F6 — Moves focus between worksheet, ribbon, task pane and other Excel areas.
Extend selection mode
F8 — Turns Extend mode on or off so arrow keys extend the selection.
Turn KeyTips on/off
F10 — Activates Ribbon KeyTips; Alt provides the same access-key entry point.
Save As
F12 — Opens the Save As dialog.
Copy selection
Ctrl + C — Copies the selected cells or content to the clipboard.
Paste selection
Ctrl + V — Pastes copied or cut content into the active location.
Cut selection
Ctrl + X — Cuts the selection so it can be moved elsewhere.
Undo
Ctrl + Z — Reverses the most recent action.
Redo / repeat
Ctrl + Y — Redoes the last undone action when Excel supports it.
Save workbook
Ctrl + S — Saves the current workbook.
Open workbook
Ctrl + O — Opens the workbook/file dialog.
New workbook
Ctrl + N — Creates a new blank workbook.
Ctrl + P — Opens print settings for the workbook.
Find
Ctrl + F — Searches the current worksheet/workbook for text or values.
Find and Replace
Ctrl + H — Finds matching content and lets you replace it.
Format Cells dialog
Ctrl + 1 — Opens the full Format Cells dialog.
Bold
Ctrl + B — Applies or removes bold formatting.
Italic
Ctrl + I — Applies or removes italic formatting.
Underline
Ctrl + U — Applies or removes underline formatting.
Strikethrough
Ctrl + 5 — Applies or removes strikethrough formatting.
Select current region / worksheet
Ctrl + A — Selects the current data region, then expands selection with repeated use.
Select entire column
Ctrl + Space — Selects the entire column containing the active cell.
Select entire row
Shift + Space — Selects the entire row containing the active cell.
Select to edge of data region
Ctrl + Shift + Right Arrow — Extends selection to the edge of the current data region.
Select down to data edge
Ctrl + Shift + Down Arrow — Extends selection down to the edge of the current data region.
Jump to data edge
Ctrl + Right Arrow — Moves the active cell to the edge of the current data region.
Jump left to data edge
Ctrl + Left Arrow — Moves to the left edge of the current data region.
Jump down to data edge
Ctrl + Down Arrow — Moves to the bottom edge of the current data region.
Jump up to data edge
Ctrl + Up Arrow — Moves to the top edge of the current data region.
Go to beginning of worksheet
Ctrl + Home — Moves to the beginning of the worksheet.
Go to last used cell
Ctrl + End — Moves to the lowest used row of the rightmost used column.
Go To dialog
F5 — Opens the Go To dialog for jumping to a cell or named range.
Next worksheet
Ctrl + Page Down — Moves to the next worksheet tab.
Previous worksheet
Ctrl + Page Up — Moves to the previous worksheet tab.
Edit active cell
F2 — Enters cell-edit mode and places the insertion point in the cell/formula bar.
Insert AutoSum
Alt + = — Starts an automatic SUM formula for a nearby range.
Fill Down
Ctrl + D — Copies the top cell’s content and formatting into the selected cells below.
Fill Right
Ctrl + R — Copies the leftmost cell’s content and formatting across the selection.
Flash Fill
Ctrl + E — Recognizes a pattern and fills the current column.
Turn filters on/off
Ctrl + Shift + L — Adds or removes filter controls from the current data headers.
Quick Analysis
Ctrl + Q — Opens Quick Analysis for selected data.
Create Table
Ctrl + T — Opens the Create Table dialog for the current data range.
Paste Special
Ctrl + Alt + V — Opens Paste Special so you can choose what to paste.
Enter current date
Ctrl + ; — Inserts the current date as a value.
Enter current time
Ctrl + Shift + : — Inserts the current time as a value.
Show formulas
Ctrl + ` — Switches the worksheet between displayed values and formulas.
Copy value from cell above
Ctrl + Shift + " — Copies the value from the cell above into the active cell.
Insert Function dialog
Shift + F3 — Opens Excel’s Insert Function dialog.
Cycle cell references / repeat action
F4 — When editing a formula reference, cycles relative/absolute reference styles; otherwise F4 repeats the last action when possible.
Calculate all open workbooks
F9 — Recalculates formulas in all open workbooks.
Calculate active worksheet
Shift + F9 — Recalculates the active worksheet.
Force full calculation
Ctrl + Alt + F9 — Forces calculation across open workbooks even when cells are not marked as changed.
Go To
Ctrl + G — Opens the Go To dialog for a cell reference or named range.
Insert hyperlink
Ctrl + K — Opens the hyperlink dialog.
Insert or edit note
Shift + F2 — Adds or edits a cell note.
Insert or reply to threaded comment
Ctrl + Shift + F2 — Adds or opens a threaded comment.
Check spelling
F7 — Checks spelling in the active worksheet or selection.
Create embedded chart
Alt + F1 — Creates an embedded chart from the current data range.
Create chart sheet
F11 — Creates a chart of the current data in a separate chart sheet.
Macro dialog
Alt + F8 — Opens the Macro dialog for creating, running, editing, or deleting macros.
Visual Basic Editor
Alt + F11 — Opens the VBA editor.
Power Query Editor
Alt + F12 — Opens the Power Query Editor in supported desktop Excel.
Open Home tab KeyTips
Alt + H — Activates the Home tab and its Ribbon KeyTips.
Open Insert tab KeyTips
Alt + N — Activates the Insert tab and its KeyTips.
Open Data tab KeyTips
Alt + A — Activates the Data tab and its KeyTips.
Open Formulas tab KeyTips
Alt + M — Activates the Formulas tab and its KeyTips.
Open Review tab KeyTips
Alt + R — Activates the Review tab and its KeyTips.
Open View tab KeyTips
Alt + W — Activates the View tab and its KeyTips.
Open File menu KeyTips
Alt + F — Opens the File menu with keyboard access.
Move to Search field
Alt + Q — Moves to Excel’s Search/Tell Me field.
Insert cells/rows/columns
Ctrl + Shift + + — Opens the Insert dialog for selected cells.
Delete cells/rows/columns
Ctrl + - — Opens the Delete dialog for selected cells.
Hide selected rows
Ctrl + 9 — Hides selected rows.
Hide selected columns
Ctrl + 0 — Hides selected columns.
Fill selected range with current entry
Ctrl + Enter — Places the current entry into all selected cells.
New line inside a cell
Alt + Enter — Starts a new line within the same cell.
Open filter/list menu
Alt + Down Arrow — Opens a validation list or relevant filter/PivotTable field menu.
General number format
Ctrl + Shift + ~ — Applies the General number format.
Currency format
Ctrl + Shift + $ — Applies Currency format with two decimal places.
Percentage format
Ctrl + Shift + % — Applies Percentage format with no decimal places.
Date format
Ctrl + Shift + # — Applies a date format with day, month and year.
Time format
Ctrl + Shift + @ — Applies a time format with hour, minute and AM/PM.
Number format
Ctrl + Shift + ! — Applies Number format with two decimals and a thousands separator.
Outline border
Ctrl + Shift + & — Applies an outline border to selected cells.
Remove outline border
Ctrl + Shift + _ — Removes the outline border from selected cells.
Repeat last action
Ctrl + Y — Repeats the last command or action when Excel supports repeating it.
Interactive practice runs in your browser.