Excel Shortcut Keys

Flashcards containing the various Excel shortcut keys and their corresponding actions.

Calculate

[F9]

Calculate Sheet

[Shift][F9]

Enter current date

[Ctrl][;]

Delete cell content

[Del]

Enter a space / Select item or checkbox

[Space]

Redo / Repeat

[Ctrl][Y]

Undo

[Ctrl][Z]

Copies formula into selected cells

[Ctrl][Enter]

Copy

[Ctrl][C]

Cut

[Ctrl][X]

Paste

[Ctrl][V]

Paste Values

[Ctrl][Alt][V]

Enter a new line in the cell

[Alt][Enter]

Repeat last Action / toggle through Absolute and relative reference

[F4]

Toggles Edit / Enter Mode

[F2]

Close

[Ctrl][F4]

Save

[Ctrl][S]

Save as

[F12]

Print

[Ctrl][P]

Opens the format dialog box

[Ctrl][1]

Wrap Text

[Shift][Ctrl][W]

Bold

[Ctrl][B]

Italics

[Ctrl][I]

Underline

[Ctrl][U]

Increase decimals

[Ctrl][,]

Auto Sum

[Alt][=]

Paste name

[F3]

Open the context menu

[Shift],[F10]

Open Goto Dialog box

[F5]

Move up one cell or Item

[Up]

Select visible cells

[Alt][;]

Next pane or area

[F6]

Enter a formula into a cell or moves to the next cell

[Enter]

Escape out of edit mode etc.

[Esc]

Help

[F1]

Insert table

[Ctrl][T]

Open the quick analysis tool

[Ctrl][Q]

Enter the current time

[Shift][Ctrl][;]

Copy formula from cell above

[Ctrl][']

Fill Down

[Ctrl][D]

Fill right

[Ctrl][R]

Flash fill

[Ctrl][E]

Find

[Ctrl][F]

Replace

[Ctrl][H]

Delete the selected Cells / Rows / Columns

[Ctrl][-]

New Workbook

[Ctrl][N]

Hide Columns

[Ctrl][0]

Hide rows

[Ctrl][9]

Show and Hide objects

[Ctrl][6]

Apply comma format

[Shift][Ctrl][!]

Select all

[Ctrl][A]

Open Name Manager

[Ctrl][F3]

Insert new worksheet

[Shift][F11]

Switches between worksheet tabs, from left-to-right

[Ctrl][Page Down]

Switches between worksheet tabs, from right-to-left

[Ctrl][Page Up]

Moves between open windows

[Alt][Esc]

Switch between applications

[Alt][Tab]

Switch between workbooks

[Ctrl][Tab]

Tab to next Cell, tool, tab stop or object

[Tab]

Tab to previous Cell, tool, tab stop or object

[Shift][Tab]

Enter and move up

[Shift][Enter]

Jumps one page down

[Pg Dn]

Jumps one page up

[Pg Up]

Move down one cell

[Down]

Move left one cell / Move one character to the left

[Left]

Move right one cell / Move one character to the right

[Right]

Move to the next worksheet in the workbook

[Ctrl][Pg Dn]

Move to the previous worksheet in the workbook

[Ctrl][Pg Up]

Moves left to the next blank cell

[Shift][Ctrl][F4]

Moves one screen to the left in a worksheet

[Alt][Pg Up]

Moves one screen to the right in a worksheet

[Alt][Pg Dn]

Moves right to the next blank cell

[Shift][F4]

Moves to the bottom of the active area

[Ctrl][End]

Moves to the bottom of the region or next region

[Ctrl][Down]

Moves to the front of the row

[Home]

Moves to the left of the region or next region

[Ctrl][Left]

Moves to the right of the region or next region

[Ctrl][Right]

Moves to the top of the current region or next region

[Ctrl][Up]

Moves to the top of the spreadsheet

[Ctrl][Home]

Puts excel in end mode (same as Ctrl+Arrow)

[End]

Hide ribbons

[Ctrl][F1]

Open a Menu or list

[Alt][Down]

Select the menu bar

[F10]

Add to selection

[Shift][F8]

Extended Selection Mode

[F8]

Select cells to the next page

[Shift][Pg Dn]

Select cells to the previous page

[Shift][Pg Up]

Select cells while moving down

[Shift][Down]

Select cells while moving left

[Shift][Left]

Select cells while moving right

[Shift][Right]

Select cells while moving up

[Shift][Up]

Select in end mode

[Shift][End]

Select the active column

[Shift][Space]

Select the cells to the beginning of the row

[Shift][Home]

Select the current and next sheet in a workbook

[Shift][Ctrl][Pg Dn]

Select the current and previous sheet in a workbook

[Shift][Ctrl][Pg Up]

Select the current column

[Ctrl][Space]

Select the current region

[Shift][Ctrl][8]

Select to the bottom of the region or next region

[Shift][Ctrl][Down]

Select to the left of the region or next region

[Shift][Ctrl][Left]