Keyboard Shortcuts

MS-Excel Keyboard Shortcuts

Action Modifiers Key

Go to cell A1

Ctrl+

Home

Go to last cell in worksheet

Ctrl+

End

Go to column A, current row

 

Home

Next worksheet

Ctrl+

PgDn

Previous worksheet

Ctrl+

PgUp

Display Help

 

F1

Create default chart

[Select data to chart]

F11

Move down one screenful

 

PgDn

Move up one screenful

 

PgUp

Find dialogue box

Ctrl+

F

Goto

 

F5

Select all, current page

Ctrl+

A

Select current and next worksheet

Shift+Ctrl+

PgDn

Select current and previous worksheet

Shift+Ctrl+

PgUp

Open the Format Cells dialogue box

Ctrl+

1

Format as number

Ctrl+Shift+

!

Format as currency

Ctrl+Shift+

$

Format as date

Ctrl+Shift+

#

Format as percentage

Ctrl+Shift+

%

Autosum a range of cells

Alt+

=




Bruce Miller, 2005, 2014