Excel Keyboard Shortcuts Cheat Sheet

Excel Keyboard Shortcuts

Work faster with fewer clicks. Browse by topic, or type in the box to find a shortcut.

Shortcut	What it does
`F1`	Open Help
`Ctrl`+`Z`	Undo the last action
`Ctrl`+`Y`	Redo the last action
`F4`	Repeat the last action
`Ctrl`+`C`	Copy the selected data
`Ctrl`+`X`	Cut the selected data
`Ctrl`+`V`	Paste the contents of the clipboard
`Ctrl`+`Alt`+`V`	Display the Paste Special dialog box
`Ctrl`+`F`	Find (opens Find and Replace on the Find tab)
`Ctrl`+`H`	Replace (opens Find and Replace on the Replace tab)
`Shift`+`F4`	Find the next match
`Ctrl`+`Shift`+`F4`	Find the previous match
`Alt`+`F1`	Insert an embedded chart
`F11`	Insert a chart in a new sheet
`Ctrl`+`Shift`+`L`	Toggle AutoFilter
`Alt`+`↓`	Activate the filter drop-down
`Alt`+`C`	Clear slicer filter
`Ctrl`+`T`or`Ctrl`+`L`	Create a table
`Shift`+`Space`	Select the table row
`Ctrl`+`Space`	Select the table column
`Ctrl`+`A`	Select the table (when the active cell is in the table)
`F7`	Run spell check
`Alt`+`F8`	Open the Macro dialog box
`Alt`+`F11`	Open the VBA editor
`Ctrl`+`D`	Duplicate an object, formula or text
`Alt`	Snap to grid (hold while dragging)
`Ctrl`+`6`	Hide or show objects
`Alt`+`'`	Open the Modify Cell Style dialog box
`Shift`+`F10`	Show the right-click menu
`Alt`+`Space`	Display the control menu

Shortcut	What it does
`Shift`+`F11`	Insert a new worksheet
`Ctrl`+`PgDn`	Go to the next worksheet
`Ctrl`+`PgUp`	Go to the previous worksheet
`F6`or`Shift`+`F6`	Move between the worksheet, ribbon, task pane and zoom controls in a split worksheet
`Ctrl`+`Shift`+`PgUp`or`Ctrl`+`Shift`+`PgDn`	Select the adjacent worksheet
`Ctrl`+`Click`	Select non-adjacent worksheets
`Scroll Lock`	Toggle Scroll Lock
`Ctrl`+`Shift`+`F1`	Toggle full screen
`Ctrl`+`P`	Print
`Ctrl`+`F2`	Open the print preview window
`Ctrl`+`Mouse Wheel Up`	Zoom in
`Ctrl`+`Mouse Wheel Down`	Zoom out

Shortcut	What it does
`Ctrl`+`F1`	Expand or collapse the ribbon
`Alt`	Activate the access keys
`Space`or`Enter`	Activate or open the selected control
`Enter`	Confirm a control change
`F1`	Get help with the selected control

Shortcut	What it does
`→`	Move one cell right
`←`	Move one cell left
`↑`	Move one cell up
`↓`	Move one cell down
`Alt`+`PgDn`	Move one screen right
`Alt`+`PgUp`	Move one screen left
`PgUp`	Move one screen up
`PgDn`	Move one screen down
`Ctrl`+`→`	Move to the right edge of the data region
`Ctrl`+`←`	Move to the left edge of the data region
`Ctrl`+`↑`	Move to the top edge of the data region
`Ctrl`+`↓`	Move to the bottom edge of the data region
`Home`	Move to the beginning of the row
`Ctrl`+`Home`	Move to the first cell in the worksheet
`Ctrl`+`End`	Move to the last cell in the worksheet that contains data
`End`	Turn End mode on

The active cell is the cell in the worksheet where you are currently working. These shortcuts help you move around and act on it:

Shortcut	What it does
`Shift`+`Backspace`	Select only the active cell (when multiple cells are selected)
`Ctrl`+`Backspace`	Show the active cell on the worksheet
`Ctrl`+`.`	Move the active cell clockwise to the corners of the selection
`Enter`	Move the active cell down in the selection, wrapping to the next column
`Shift`+`Enter`	Move the active cell up in the selection, wrapping to the previous column
`Tab`	Move the active cell right in a selection, wrapping to the next row
`Shift`+`Tab`	Move the active cell left in a selection, wrapping to the previous row

Shortcut	What it does
`Shift`+`Space`	Select the entire row
`Ctrl`+`Space`	Select the entire column
`Ctrl`+`A`	Select the current region if the worksheet contains data. Press again to include summary rows, and again to select the entire worksheet
`Shift`+`Click`	Expand the selection
`Ctrl`+`Click`	Add non-adjacent cells to the selection
`Ctrl`+`Alt`+`→`	Move right between non-adjacent selections
`Ctrl`+`Alt`+`←`	Move left between non-adjacent selections
`Shift`+`F8`	Toggle “Add to selection” mode
`Esc`	Exit “Add to selection” mode

Shortcut	What it does
`Enter`	Enter data and move down
`Shift`+`Enter`	Enter data and move up
`Tab`	Enter data and move right
`Shift`+`Tab`	Enter data and move left
`Ctrl`+`Enter`	Enter the same data in all the selected cells
`Ctrl`+`;`	Insert the current date
`Ctrl`+`Shift`+`:`	Insert the current time
`Ctrl`+`D`	Fill down from the cell above
`Ctrl`+`R`	Fill right from the cell on the left
`Ctrl`+`'`	Copy the formula from the cell above (an exact copy)
`Ctrl`+`Shift`+`"`	Copy the value from the cell above
`Ctrl`+`K`	Insert a hyperlink
`Alt`+`↓`	Display the AutoComplete list

Shortcut	What it does
`Ctrl`+`1`	Format cells
`Ctrl`+`Shift`+`F`	Format cells with the Font tab selected
`Ctrl`+`B`	Apply or remove bold
`Ctrl`+`I`	Apply or remove italics
`Ctrl`+`U`	Apply or remove underline
`Ctrl`+`5`	Apply or remove strikethrough

Shortcut	What it does
`Ctrl`+`Shift`+`+`	Insert a new row or column
`Ctrl`+`-`	Delete the selected row or column
`Ctrl`+`Space`	Select the entire column
`Shift`+`Space`	Select the entire row
`Ctrl`+`Shift`+`-`	Remove borders

Tip: on a Mac, use Cmd in place of Ctrl for most of these.