Excel Spreadsheet Shortcut Keys

 

Key

Action

Menu Equivalent

Version

Ctrl+A

Select All

None

All

Ctrl+B

Bold

Format, Cells, Font,
Font Style, Bold

All

Ctrl+C

Copy

Edit, Copy

All

Ctrl+D

Fill Down

Edit, Fill, Down

All

Ctrl+F

Find

Edit, Find

All

Ctrl+G

Go To

Edit, Go To

All

Ctrl+H

Replace

Edit, Replace

All

Ctrl+I

Italic

Format, Cells, Font,
Font Style, Italic

All

Ctrl+K

Insert Hyperlink

Insert, Hyperlink

Excel 97

Ctrl+N

New Workbook

File, New

All

Ctrl+O

Open

File, Open

All

Ctrl+P

Print

File, Print

All

Ctrl+R

Fill Right

Edit, Fill Right

All

Ctrl+S

Save

File, Save

All

Ctrl+U

Underline

Format, Cells, Font, Underline, Single

All

Ctrl+V

Paste

Edit, Paste

All

Ctrl W

Close

File, Close

Excel 97

Ctrl+X

Cut

Edit, Cut

All

Ctrl+Y

Repeat

Edit, Repeat

All

Ctrl+Z

Undo

Edit, Undo

All

 

 

 

 

F1

Help

Help, Contents and Index

All

F2

Edit

None

All

F3

Paste Name

Insert, Name, Paste

All

F4

Repeat

Edit, Repeat

All

F4

Absolute/Relative References

None

All

F5

Go To

Edit, Go To

All

F6

Next Pane

None

All

F7

Spell Check

Tools, Spelling

All

F8

Extend Mode

None

All

F9

Recalculate

Tools, Options, Calculation, Calc

All

F10

Activate Menubar

None

All

F11

New Chart

Insert, Chart

All

F12

Save As

File, Save As

All

 

 

 

 

Ctrl+:

Insert Current Time

None

All

Ctrl+;

Insert Current Date

None

All

Ctrl+"

Copy Value from Cell Above

Edit, Paste Special, Value

All

Ctrl+'

Copy Formula from Cell Above

Edit, Copy

All