Excel Keyboard Shortcuts

Contact Us
CIO for Rent
Web Design
Services
Success Stories
Resources
About Us
Training
MS Excel Keyboard Shortcuts:

1st key

2nd key

What it does

CTRL

DELETE

Delete to end of line

CTRL

Spacebar

Selects the current column

Shift

Spacebar

Selects the current row

ALT

F1

Create a chart that uses the current range

CTRL

:

Insert the current time

CTRL

;

Insert today's date

CTRL

`

(single left quotation mark) Alternate between displaying cell values and displaying cell formulas

CTRL

1

Display the Format Cells dialog box

CTRL

A

Select all (when you are not entering or editing a formula)

CTRL

A

When you enter a formula, display the Formula Palette after you type a function name

CTRL

C

Copy

CTRL

END

Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1

CTRL

ENTER

Fill the selected cell range with the current entry

CTRL

HOME

Move to the beginning of the worksheet

CTRL

O

Open

CTRL

P

Print

CTRL

S

Save

CTRL

Spacebar

Select the current column

CTRL

V

Paste

CTRL

Z

Undo

F11

 

Create a chart that uses the current range

F5

 

Display the Go To dialog box

F9

 

Calculate all sheets in all open workbooks

SHIFT

F3

Paste a function into a formula

SHIFT

F9

Calculate the active worksheet

SHIFT

Spacebar

Select the current row


 

 

 

 

Back Home Next