Excels Keyboard Shortcuts




Shortcut key
Action

Menu equivalent
comments

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

Goto

Edit, Goto

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/2000
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/2000
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 last action

Edit, Repeat. Works while not in Edit mode.

All
F4

While typing a formula, switch between absolute/relative refs

None

All
F5

Goto

Edit, Goto

All
F6

Next Pane

None

All
F7

Spell check

Tools, Spelling

All
F8

Extend mode

None

All
F9

Recalculate all workbooks

Tools, Options, Calculation, Calc,Now

All
F10

Activate Menubar

N/A

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 Fromula from Cell Above

Edit, Copy

All
Shift

Hold down shift for additional functions in Excel's menu

none

Excel 97/2000
Shift+F1

What's This?

Help, What's This?

All
Shift+F2

Edit cell comment

Insert, Edit Comments

All
Shift+F3

Paste function into formula

Insert, Function

All
Shift+F4

Find Next

Edit, Find, Find Next

All
Shift+F5

Find

Edit, Find, Find Next

All
Shift+F6

Previous Pane

None

All
Shift+F8

Add to selection

None

All
Shift+F9

Calculate active worksheet

Calc Sheet

All
Shift+F10

Display shortcut menu

None

All
Shift+F11

New worksheet

Insert, Worksheet

All
Shift+F12

Save

File, Save

All
Ctrl+F3

Define name

Insert, Names, Define

All
Ctrl+F4

Close

File, Close

All
Ctrl+F5

XL, Restore window size

Restore

All
Ctrl+F6

Next workbook window

Window, ...

All
Shift+Ctrl+F6

Previous workbook window

Window, ...

All
Ctrl+F7

Move window

XL, Move

All
Ctrl+F8

Resize window

XL, Size

All
Ctrl+F9

Minimize workbook

XL, Minimize

All
Ctrl+F10

Maximize or restore window

XL, Maximize

All
Ctrl+F11

Inset 4.0 Macro sheet

None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro

All
Ctrl+F12

File Open

File, Open

All
Alt+F1

Insert Chart

Insert, Chart...

All
Alt+F2

Save As

File, Save As

All
Alt+F4

Exit

File, Exit

All
Alt+F8

Macro dialog box

Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions

Excel 97/2000
Alt+F11

Visual Basic Editor

Tools, Macro, Visual Basic Editor

Excel 97/2000
Ctrl+Shift+F3

Create name by using names of row and column labels

Insert, Name, Create

All
Ctrl+Shift+F6

Previous Window

Window, ...

All
Ctrl+Shift+F12

Print

File, Print

All
Alt+Shift+F1

New worksheet

Insert, Worksheet

All
Alt+Shift+F2

Save

File, Save

All
Alt+=

AutoSum

No direct equivalent

All
Ctrl+`

Toggle Value/Formula display

Tools, Options, View, Formulas

All
Ctrl+Shift+A

Insert argument names into formula

No direct equivalent

All
Alt+Down arrow

Display AutoComplete list

None

Excel 95
Alt+'

Format Style dialog box

Format, Style

All
Ctrl+Shift+~

General format

Format, Cells, Number, Category, General

All
Ctrl+Shift+!

Comma format

Format, Cells, Number, Category, Number

All
Ctrl+Shift+@

Time format

Format, Cells, Number, Category, Time

All
Ctrl+Shift+#

Date format

Format, Cells, Number, Category, Date

All
Ctrl+Shift+$

Currency format

Format, Cells, Number, Category, Currency

All
Ctrl+Shift+%

Percent format

Format, Cells, Number, Category, Percentage

All
Ctrl+Shift+^

Exponential format

Format, Cells, Number, Category,

All
Ctrl+Shift+&

Place outline border around selected cells

Format, Cells, Border

All
Ctrl+Shift+_

Remove outline border

Format, Cells, Border

All
Ctrl+Shift+*

Select current region

Edit, Goto, Special, Current Region

All
Ctrl++

Insert

Insert, (Rows, Columns, or Cells) Depends on selection

All
Ctrl+-

Delete

Delete, (Rows, Columns, or Cells) Depends on selection

All
Ctrl+1

Format cells dialog box

Format, Cells

All
Ctrl+2

Bold

Format, Cells, Font, Font Style, Bold

All
Ctrl+3

Italic

Format, Cells, Font, Font Style, Italic

All
Ctrl+4

Underline

Format, Cells, Font, Font Style, Underline

All
Ctrl+5

Strikethrough

Format, Cells, Font, Effects, Strikethrough

All
Ctrl+6

Show/Hide objects

Tools, Options, View, Objects, Show All/Hide

All
Ctrl+7

Show/Hide Standard toolbar

View, Toolbars, Stardard

All
Ctrl+8

Toggle Outline symbols

None

All
Ctrl+9

Hide rows

Format, Row, Hide

All
Ctrl+0

Hide columns

Format, Column, Hide

All
Ctrl+Shift+(

Unhide rows

Format, Row, Unhide

All
Ctrl+Shift+)

Unhide columns

Format, Column, Unhide

All
Alt or F10

Activate the menu

None

All
Ctrl+Tab

In toolbar: next toolbar

None

Excel 97/2000
Shift+Ctrl+Tab

In toolbar: previous toolbar

None

Excel 97/2000
Ctrl+Tab

In a workbook: activate next workbook

None