Excel shortcuts Function->KeyStroke Flashcards
Move one screen to the right / to the left in a
worksheet
Alt+Page Down/Alt
+Page Up
Move to the edge of next data region (cells that
contains data)
Ctrl+Arrow Keys
Move to the beginning of a row in a worksheet.
Home
Move to the beginning of a worksheet.
Ctrl+Home
Move to the last cell with content on a worksheet.
Ctrl+End
Display the Find and Replace dialog box (with Find
selected).
Ctrl+f
Display the Find and Replace dialog box (with
Replace selected).
Ctrl+h
Repeat last find.
Shift+F4
Display the ‘Go To’ dialog box.
Ctrl+g (or f5)
Display the AutoComplete list e.g. in cell with
dropdowns or autofilter.
Alt+Arrow Down
Select the entire row.
Shift+Space
Select the entire column.
Ctrl+Space
Select the current region around the active cell
Ctrl+Shift+*
asterisk
Select the entire worksheet or the data-containing
area. Pressing ctrl+a a second time then selects entire
worksheet.
Ctrl+a (or ctrl+Shift
+spacebar)
Select the current and previous sheet in a workbook.
Ctrl+Shift+Page Up
Select all cells with comments.
Ctrl+Shift+o
Extend the selection to the last cell with content in
row or column.
Ctrl+Shift+Arrow
Key
Extend the selection down one screen /up one screen.
Shift+Page Down/S
hift+Page Up
Extend the selection to the beginning of the row.
Shift+Home
Extend the selection to the beginning of the
worksheet.
Ctrl+Shift+Home
Extend the selection to the last used cell on the
worksheet (lower-right corner).
Ctrl+Shift+End
Turn on extension of selection with arrow keys
without having to keep pressing shift.
F8
Add another (adjacent or non-adjacent) range of cells to the selection. Use arrow keys and shift+arrow keys
to add to selection.
Shift+F8
Select only the active cell when multiple cells are
selected.
Shift+Backspace
Move clockwise to the next corner of the selection.
Ctrl+. (period)
Move active cell down / up in a selection.
Enter/Shift+Enter
Move active cell right / left in a selection.
Tab/Shift+Tab
Move to the right / to the left between non-adjacent
selections (with multiple ranges selected).
Ctrl+Alt+Arrow
Right/Ctrl+Alt+Arro
w Left
Cancel Selection
Esc
Redo last action (multiple levels).
Ctrl+y
If data exists in clipboard: Display the Paste Special
dialog box.
Ctrl+Alt+v
Edit the active cell with cursor at end of the line.
F2
Start a new line in the same cell.
Alt+Enter
Complete a cell entry and move up in the selection.
Shift+Enter
Insert current date.
Ctrl+; (semicolon)
Insert current time.
Ctrl+Shift+: (colon)
Fill complete cell down (Copy above cell).
Ctrl+d
Fill complete cell to the right (Copy cell from the left).
Ctrl+r
Fill cell values down and edit (Copy above cell
values).
Ctrl+”
Fill cell formulas down and edit (Copy above cell
formulas).
Ctrl+’ (apostrophe)
Insert a table (display Create Table dialog box).
Ctrl+T
Delete Cell/Row/Column Menu
Ctrl+-
Delete row / delete column.
Ctrl+- with row /
column selected
Insert Cell/Row/Column Menu
Ctrl+Shift++
Insert row/ insert column.
Ctrl+Shift++ with
row / column
selected