Periodic Table of Excel Keyboard Shortcuts

General

F1

Excel Help

Ctrl

I

Toggle Italics

F2

Edit Current Cell

F4

Redo Last Action

F7

Start Spell Check

F9

Recalculate All Worksheets

F12

Save File As

Ctrl

B

Toggle Bold Text

Ctrl

C

Copy Selection

Ctrl

P

Print

Ctrl

S

Save File

Ctrl

U

Toggle Underline

Ctrl

V

Paste Contents of Clipboard

Ctrl

X

Cut Selection

Ctrl

Y

Redo Last Action

Ctrl

Z

Undo Last Action

Periodic Table of

Excel Keyboard Shortcuts

Range Selection & Navigation

Ctrl Shift

Select All Cells to the Left

Ctrl Shift

Select All Cells to the Right

Ctrl Shift

Select All Cells Below

Ctrl Shift

Select All Cells Above

Ctrl

Home

Move to Top of Worksheet

Ctrl

End

Move to Last Used Cell

Ctrl

Move to Left-Most Cell

Alt

;

Select Only Visible Cells

F5

Go To Specified Range

Ctrl

9

Hide Row

Ctrl

A

Select Entire Region

Ctrl

Space

Select Entire Column

Shift

Space

Select Entire Row

Ctrl

Move to Right-Most Cell

Ctrl

Move to Last Cell in

Column

Ctrl

Move to First Cell in

Column

Ctrl

0

Hide Column

Ctrl Shift

)

Unhide Column

Ctrl Shift

(

Unhide Row

Formula Editing & Management

Alt

=

Insert Auto Sum

F4

Toggle Absolute Reference

(In Edit Mode Only)

Ctrl

D

Fill Values Down

Ctrl

R

Fill Values Right

Ctrl

`

Copy from Cell Above

Shift

F3

Insert Function

F3

Insert Defined Named Range (Only If Any Exists)

Ctrl Shift

F3

Create Named Range from Selection

Ctrl

~

Toggle Formula View

Ctrl

]

Select Dependents for Active Formula

Ctrl

[

Select Precedents for Active Formula

Ctrl Shift

Enter

Create an Array Formula

(In Edit Mode Only)

Formatting

Ctrl Shift

~

Apply General Format

Ctrl Shift

!

Apply Number Format

Ctrl Shift

@

Apply Time Format

Ctrl Shift

#

Apply Date Format

Ctrl Shift

$

Apply Currency Format

Ctrl Shift

%

Apply Percent Format

Ctrl

5

Apply Strikethrough

Format

Alt

Enter

Add Carriage Return

(In Edit Mode Only)

Ctrl Shift

-

Remove Borders

Ctrl Shift

&

Apply Border Around Selection

Workbook & Worksheet Management

Ctrl

N

Start New Workbook

Shift

F11

Inset New Worksheet

Ctrl

W

Close Active Workbook

Ctrl

F6

Move to Next Open Workbook

Ctrl

PgDn

Move to Next Worksheet

Ctrl

PgUp

Move to Prev Worksheet

Shift

F6

Move to Prev Open Workbook

Shift

F9

Recalculate Active Worksheet

Useful Dialog Boxes

Ctrl

O

Open Existing File Dialog Box

Ctrl

F3

Name Manager Dialog Box

Ctrl

1

Format Cells Dialog Box

Ctrl Shift

+

Insert Dialog Box

Ctrl

F

Find Dialog Box

Ctrl

H

Replace Dialog Box

Ctrl

-

Delete Dialog Box

Ctrl

T

Create Table Dialog Box

Alt

F8

Macros Dialog Box

Alt

F11

Open Visual Basic Editor

Primary Keyboard Key to Press

Additional Keys to Be Pressed in Conjunction

with Primary Key

Description

Ctrl Shift

!

Apply Number Format

F2

Open Object Browser

Ctrl

R

Open Project Window

Ctrl

G

Open Immediate Window

F4

Open Properties Window

Ctrl

PgDn

Jump to Bottom of Procedure

Ctrl

PgUp

Jump to Top of Procedure

Visual Basic Editor Keyboard Shortcuts

Ctrl

Jump to Next Procedure

Ctrl

Jump to Prev Procedure

Shift

F2

Jump to Variable (Highlight Variable

First)

Ctrl Shift

F2

Jump Back to Prev Position

Ctrl

F

Find Dialog Box

Ctrl

H

Replace Dialog Box

F5

Run Procedure

F8

Step Into

Shift

F8

Step Over

Ctrl

F8

Run to Cursor

Ctrl

F9

Toggle Breakpoint

Ctrl Shift

F8

Ctrl Shift

F9

Step Out

Debugging Tools

Clear All Breakpoints

? Copyright 2013

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download