240+ Excel Keyboard Shortcuts

The fastest Excel users don’t use a mouse, but instead jump around the screen with only their keyboard.

Excel keyboard shortcuts are one of the fastest ways to improve your speed and efficiency in spreadsheets. Whether you’re editing data, formatting cells, or navigating large workbooks, the right Excel shortcuts can save you dozens of clicks per day.

This guide organizes over 240 shortcuts into easy-to-understand categories, so you can quickly find what you need from basic editing and navigation, to advanced tools like PivotTables and macros.

This section covers Excel keyboard shortcuts for common input tasks like copying, pasting, undoing, redoing, filling cells, entering values, and using Flash Fill. If you’re working with cell content, start here.

Action	Windows Shortcut
Undo Last Action	Ctrl + Z
Redo Last Action	Ctrl + Y
Copy Selected Cells	Ctrl + C
Cut Selected Cells	Ctrl + X
Paste Content from Clipboard	Ctrl + V
Repeat last action	F4
Display the Paste Special Dialog Box	Ctrl + Alt + V
Display Find and Replace	Ctrl + F
Display Find and Replace, Replace Selected	Ctrl + H
Drag and cut	Drag
Drag and copy	Ctrl + Drag
Drag and insert	Shift + Drag
Drag and insert copy	Ctrl + Shift + Drag
Edit active cell	F2
Insert or edit Notes	Shift + F2
Delete comment	Shift + F10, M
Cancel editing	Esc
Select one character right	Shift + →
Select one character left	Shift + ←
Move one word right	Ctrl + →
Move one word left	Ctrl + ←
Select one word right	Ctrl + Shift + →
Select one word left	Ctrl + Shift + ←
Select to the beginning of cell	Shift + Home
Select to end of cell	Shift + End
Delete to end of line	Ctrl + Delete
Delete character to left of cursor	Backspace
Delete character to the right of cursor	Delete
Start a new line in the same cell	Alt + Enter
Enter data and move down	Enter
Enter data and move up	Shift + Enter
Enter data and move right	Tab
Enter data and move left	Shift + Tab
Enter data and stay in same cell	Ctrl + Enter
Insert current date	Ctrl + ;
Insert current time	Ctrl + Shift + :
Fill down from cell above	Ctrl + D
Fill right from the cell on left	Ctrl + R
Copy formula from the cell above	Ctrl + ‘
Copy value from the cell above	Ctrl + Shift + “
Insert hyperlink	Ctrl + K
Display AutoComplete list	Alt + ↓
Flash Fill	Ctrl + E
Display Insert Dialog box	Ctrl + Shift + +
Display Delete dialog box	Ctrl + –
Delete contents of selected cells	Delete
Hide columns	Ctrl + 0
Hide rows	Ctrl + 9
Unhide rows	Ctrl + Shift + 9
Unhide columns	Ctrl + Shift + 0
Group rows or columns (with rows/columns selected)	Alt + Shift + →
Ungroup rows or columns (with rows/columns selected)	Alt + Shift + ←
Duplicate object	Ctrl + D
Snap to the grid (whilst dragging)	Alt

These Excel shortcuts help you select specific cells, entire rows or columns, non-adjacent ranges, or the entire worksheet. Includes options for extending or modifying existing selections.

Action	Windows Shortcut
Select Table Row	Shift + Space
Select Table Column	Ctrl + Space
Select Table (when active cell is in table)	Ctrl + A
Select adjacent worksheets	Ctrl + Shift + PgUp/PgDn
Select non-adjacent worksheets	Ctrl + Click
Select entire row	Shift + Space
Select entire column	Ctrl + Space
Select entire worksheet	Ctrl + A
Add adjacent cells to selection	Shift + Click
Add non-adjacent cells to selection	Ctrl + Click
Move right between non-adjacent selections	Ctrl + Alt + →
Move left between non-adjacent selections	Ctrl + Alt + ←
Toggle add to selection mode	Shift + F8
Cancel selection	Esc
Extend selection right	Shift + →
Extend selection left	Shift + ←
Extend selection up	Shift + ↑
Extend selection down	Shift + ↓
Extend the Selection to the Last Cell Right	Ctrl + Shift + →
Extend the Selection to the Last Cell Left	Ctrl + Shift + ←
Extend the Selection to the Last Cell Up	Ctrl + Shift + ↑
Extend the Selection to the Last Cell Down	Ctrl + Shift + ↓
Extend selection up one screen	Shift + PgUp
Extend selection down one screen	Shift + PgDn
Extend selection right one screen	Alt + Shift + PgDn
Extend selection left one screen	Alt + Shift + PgUp
Extend selection to start of row(s)	Shift + Home
Extend selection to first cell in worksheet	Ctrl + Shift + Home
Extend selection to last cell in worksheet	Ctrl + Shift + End
Toggle ‘Extend Selection’ mode	F8
Cancel ‘Extend Selection’ mode	Esc
Select the active cell (when multiple cells are already selected)	Shift + Backspace
Show the active cell on the worksheet	Ctrl + Backspace
Move active cell clockwise to corners of the selection	Ctrl + .
Move active cell down in selection	Enter
Move active cell up in selection	Shift + Enter
Move active cell right in a selection	Tab
Move active cell left in a selection	Shift + Tab
Select cells with Notes	Ctrl + Shift + O
Select current region around active cell	Ctrl + Shift + *
Select current region	Ctrl + A
Select Row Differences	Ctrl + Shift + |
Select Column Differences	Ctrl + \
Select direct precedents	Ctrl + [
Select all precedents	Ctrl + Shift + {
Select direct dependents	Ctrl + ]
Select all dependents	Ctrl + Shift + }
Select visible cells only	Alt + ;

Use these keyboard shortcuts to move quickly around your worksheet by cell, entire rows, or directly to the first or last cell in a region. Useful for large Excel spreadsheets.

Action	Windows Shortcut
Go to next workbook	Ctrl + Tab
Go to previous workbook	Ctrl + Shift + Tab
Go to the next worksheet	Ctrl + PgDn
Go to the previous worksheet	Ctrl + PgUp
Move between the worksheet, Ribbon, task pane, and zoom controls in a worksheet that has been split	F6 or Shift + F6
Zoom in	Ctrl + Mouse Wheel Up
Zoom out	Ctrl + Mouse Wheel Down
Move one cell right	→
Move one cell left	←
Move one cell up	↑
Move one cell down	↓
Move one screen right	Alt + PgDn
Move one screen left	Alt + PgUp
Move one screen up	PgUp
Move one screen down	PgDn
Move to the right edge of data region	Ctrl + →
Move to the left edge of data region	Ctrl + ←
Move to the top edge of data region	Ctrl + ↑
Move to the bottom edge of data region	Ctrl + ↓
Move to the beginning of row	Home
Move to last cell in worksheet that contains data	Ctrl + End
Move to the first cell in worksheet	Ctrl + Home
Turn End mode on	End

This group includes Excel shortcuts for creating, opening, saving, closing, and switching between workbooks and worksheets. Also covers worksheet-level actions like renaming or deleting sheets.

Action	Windows Shortcut
Create new workbook	Ctrl + N
Open workbook	Ctrl + O
Save workbook	Ctrl + S
Save as	F12
Minimize current workbook window	Ctrl + F9
Maximize current workbook window	Ctrl + F10
Protect workbook	Alt + R, P, W
Close current workbook	Ctrl + F4
Close Excel	Alt + F4
Insert new worksheet	Shift + F11
Rename current worksheet	Alt + O, H, R
Delete current worksheet	Alt + E, L
Display Move or Copy	Alt + E, M
Print	Ctrl + P
Open print preview window	Ctrl + F2
Protect sheet	Alt + R, P, S
Drag to worksheet	Alt + Drag
Drag to duplicate worksheet	Ctrl + Drag

Covers keyboard shortcuts for applying number formats, adding borders, hiding or showing content, and adjusting cell appearance. Helpful for cleaning up reports or presentations.

Action	Windows Shortcut
Toggle full-screen	Ctrl + Shift + F1
Set print area	Alt + P, R, S
Clear print area	Alt + P, R, C
Apply general format	Ctrl + Shift + ~
Apply number format	Ctrl + Shift + !
Apply time format	Ctrl + Shift + @
Apply date format	Ctrl + Shift + #
Apply currency format	Ctrl + Shift + $
Apply percentage format	Ctrl + Shift + %
Apply scientific format	Ctrl + Shift + ^
Apply general format	Ctrl + Shift + ~
Apply number format	Ctrl + Shift + !
Apply time format	Ctrl + Shift + @
Apply date format	Ctrl + Shift + #
Apply currency format	Ctrl + Shift + $
Apply percentage format	Ctrl + Shift + %
Apply scientific format	Ctrl + Shift + ^
Open list of border styles from Ribbon	Alt + H, B
Add border around selected cells	Ctrl + Shift + &
Add right border	Alt + H, B, R
Add left border	Alt + H, B, L
Add top border	Alt + H, B, P
Add bottom border	Alt + H, B, O
Add all borders to all cells in selection	Alt + H, B, A
Remove borders	Ctrl + Shift + –
Hide or show outline symbols	Ctrl + 8
Hide or show objects	Ctrl + 6
Open Style dialog box	Alt + ‘

These keyboard shortcuts focus on writing and managing formulas. Includes inserting Excel functions, toggling between relative and absolute references, recalculating sheets, and displaying formulas.

Action	Windows Shortcut
Accept function with auto-complete	Tab
Paste name into formula	F3
Toggle absolute and relative references	F4
Open the Insert Function Dialog Box	Shift + F3
Autosum	Alt + =
Toggle displaying formulas on and off	Ctrl + ‘
Insert function arguments	Ctrl + Shift + A
Enter array formula	Ctrl + Shift + Enter
Force calculate active worksheet	Shift + F9
Force calculate all worksheets	Ctrl + Alt + F9
Expand or collapse the formula bar	Ctrl + Shift + U
Display function arguments dialog box	Ctrl + A
Open Name Manager	Ctrl + F3
Create name from values in a row(s)/column(s)	Ctrl + Shift + F3

This section shows how to navigate the Excel Ribbon and open common dialog boxes using only the keyboard. Useful for users who prefer not to use a mouse.

Action	Windows Shortcut
Expand or collapse ribbon	Ctrl + F1
Activate Ribbon access keys	Alt
Move through Ribbon tabs and groups	→ ← ↑ ↓ or Tab
Display ‘Go To’ dialog box	Ctrl + G or F5
Show right-click menu	Shift + F10
Display control menu	Alt + Space
Jump to the File Tab	Alt + F
Jump to the Home Tab	Alt + H
Jump to the Insert Tab	Alt + N
Jump to the Page Layout Tab	Alt + P
Jump to the Formulas Tab	Alt + M
Jump to the Data Tab	Alt + A
Jump to the Review Tab	Alt + R
Jump to the View Tab	Alt + W
Jump to the Developer Tab	Alt + L
Jump to the Help Tab	Alt + Y
Jump to the Search Box	Alt + Q

Excel keyboard shortcuts in this group let you create tables, apply AutoFilters, open filter menus, and sort data quickly. Great when working with structured lists or tabular datasets.

Action	Windows Shortcut
Toggle AutoFilter	Ctrl + Shift + L
Activate Filter	Alt + ↓
Insert Table	Ctrl + T
Filter Menu: Sort Filter A to Z	Alt + ↓ + S
Filter Menu: Sort Z to A	Alt + ↓ + O
Filter Menu: Sort by Color	Alt + ↓ + T
Filter Menu: Filter by Color	Alt + ↓ + I
Filter Menu: Filter by Text or Date	Alt + ↓ + F
Select Table Row	Shift + Space
Select Table Column	Ctrl + Space
Clear Slicer Filter	Ctrl + C
Toggle Table Total Row	Ctrl + Shift + T

Includes keyboard shortcuts for creating and modifying Excel PivotTables and PivotCharts. Also covers grouping, ungrouping, and filtering PivotTable items without using the mouse.

Action	Windows Shortcut
Create pivot table	Alt + N, V, T
Toggle Pivot Table Field Checkbox	Space
Select entire pivot table	Ctrl + A
Group pivot table items	Alt + Shift + →
Ungroup pivot table items	Alt + Shift + ←
Hide (filter out) pivot table item	Ctrl + –
Unhide (clear filter on) pivot table item	Alt + H, S, C
Open Pivot Chart list	Alt + N, S, Z, C
Create Pivot Chart on Same Worksheet	Alt + F1
Create Pivot Chart on New Worksheet	F11

For users working with automation, this section includes Excel keyboard shortcuts to open the Macro dialog, access the VBA editor, and run or record macros.

Action	Windows Shortcut
Object Browser	F2
Properties Window	F4
Run Macro/Procedure	F5
View userform code	F7
Step Through Each Line of Code	F8
Add a Break Point	F9
Compile VBA Project	Alt + D + L
Open VBA Editor	Alt + F11
Open Macro dialog box	Alt + F8
Insert a new userform	Alt + I + U
Insert a new code module	Alt + I +M
Reset/stop code	Alt + R + R
Run to Cursor	Ctrl + F8
Immediate Window	Ctrl + G
Project Explorer Window	Ctrl + R

Includes tools like spellcheck, thesaurus, and other Excel features designed to assist with reviewing or navigating workbooks.

Action	Windows Shortcut
Open Help	F1
Run Spellcheck	F7
Open Thesaurus	Shift + F7