Periodic Table of Excel Keyboard Shortcuts - Excel y VBA

Periodic Table of

Excel Keyboard Shortcuts

General

F1

Excel Help

F2

Ctrl

I

Toggle Italics

Ctrl

Ctrl

Edit Current Cell

F4

F9

Recalculate All

Worksheets

F12

Save File As

Ctrl

?

Print

Select All Cells

to the Left

Ctrl

Shift

Ctrl

Alt

Alt

F3

?

Home

;

=

Save File

Select All Cells

to the Right

Move to Top of

Worksheet

Select Only

Visible Cells

Insert Auto Sum

Ctrl

U

Shift

?

Toggle

Underline

Select All Cells

Below

Ctrl

Ctrl

V

Shift

?

Paste Contents

of Clipboard

Select All Cells

Above

Ctrl

Ctrl

Ctrl

F4

End

F5

Move to Last

Used Cell

Go To Specified

Range

Ctrl

Insert Defined

Named Range

(Only If Any Exists)

Ctrl

Ctrl

Ctrl

Ctrl

F3

Toggle Absolute

Reference

(In Edit Mode Only)

Create Named

Range from

Selection

~

!

Move to

Left-Most Cell

Hide Row

Fill Values Down

Toggle Formula

View

Apply Number

Format

Ctrl

Ctrl

Ctrl

]

?

0

R

Cut Selection

Select Entire

Region

Move to

Right-Most Cell

Hide Column

Fill Values Right

Select

Dependents for

Active Formula

Ctrl

Ctrl

Y

Space

Toggle Bold Text

Redo Last

Action

Select Entire

Column

Ctrl

Copy Selection

Shift

Space

Undo Last

Action

Select Entire

Row

Shift

¡®

Unhide Column

Copy from Cell

Above

Ctrl

Shift

F3

Unhide Row

Insert Function

Alt

Shift

Ctrl

Remove

Borders

Ctrl

Enter

Create an Array

Formula

(In Edit Mode Only)

Shift

Ctrl

Shift

Open Existing

File Dialog Box

Name Manager

Dialog Box

Ctrl

1

F

Start New

Workbook

Inset New

Worksheet

Format Cells

Dialog Box

Find

Dialog Box

Ctrl

Ctrl

W

PgDn

Close Active

Workbook

Move to Next

Worksheet

Ctrl

Shift

+

H

Insert

Dialog Box

Replace

Dialog Box

Ctrl

Ctrl

Ctrl

Ctrl

F6

PgUp

-

T

Move to Next

Open Workbook

Move to

Prev Worksheet

Delete

Dialog Box

Create Table

Dialog Box

-

Apply Date

Format

Shift

Shift

F3

F11

Ctrl

Add Carriage

Return

(In Edit Mode Only)

O

N

Enter

#

Select

Precedents for

Active Formula

Ctrl

(

?

Move to

First Cell in

Column

Shift

Shift

Ctrl

Ctrl

Shift

5

Apply

Strikethrough

Format

Apply Time

Format

Ctrl

Workbook & Worksheet

Management

Ctrl

Ctrl

@

[

)

?

Move to

Last Cell in

Column

Ctrl

Z

C

Ctrl

Ctrl

B

Apply Percent

Format

D

A

Ctrl

Apply General

Format

Shift

Ctrl

Shift

%

9

Ctrl

Ctrl

~

Ctrl

Ctrl

Shift

?

Ctrl

Useful

Dialog Boxes

Formatting

Shift

X

Ctrl

Ctrl

Formula Editing &

Management

S

Ctrl

Start Spell

Check

Shift

P

Ctrl

Redo Last

Action

F7

Range Selection & Navigation

Shift

Shift

Alt

Alt

$

&

F6

F9

F8

F11

Apply Currency

Format

Apply Border

Around Selection

Move to Prev

Open Workbook

Recalculate

Active Worksheet

Macros

Dialog Box

Open Visual

Basic Editor

Visual Basic Editor Keyboard Shortcuts

Primary Keyboard

Key to Press

Additional Keys to Be

Pressed in Conjunction

with Primary Key

Description

F2

Ctrl

Open Object

Browser

Shift

!

Ctrl

Apply Number

Format

Ctrl

Ctrl

G

Open Immediate

Window

Ctrl

Shift

PgDn

?

Jump to Bottom

of Procedure

Jump to Next

Procedure

Ctrl

F

F8

Find Dialog Box

Step Into

F2

Jump to Variable

(Highlight Variable

First)

Ctrl

Ctrl

Ctrl

Shift

Ctrl

R

F4

PgUp

F2

H

F5

Open Project

Window

Open Properties

Window

?

Jump to Top

of Procedure

Jump to Prev

Procedure

Jump Back to

Prev Position

Replace Dialog

Box

Run Procedure

Ctrl

F8

Run to Cursor

Ctrl

Shift

Ctrl

Shift



Toggle

Breakpoint

Ctrl

Shift

F8

F8

F9

Step Over

Step Out

Clear All

Breakpoints

Debugging Tools

? Copyright 2013

F9

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

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

Google Online Preview   Download