Excel Shortcuts (PC) for Keyboard Shortcuts

Q

Undo

A

Ctrl + Z

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Redo

A

Ctrl + Y

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Save

A

Ctrl + S

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Save as

A

F12

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Close Excel File

A

Ctrl + F4

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Create New Excel File

A

Ctrl + N

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Displaying Control Menu

A

Alt + Spacebar

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Close Excel Application

A

Alt + F4

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move Between Sheets Clockwise

A

Ctrl + PageDown

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move Between Open Excel Files

A

Ctrl + Tab

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Cut

A

Ctrl + X

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is the best online tool with which you can practice your Excel shortcuts in real simulated Excel scenarios?

A

HotKey Excellence

Check out the website at HotKeyExcel.com

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Copy

A

Ctrl + C

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Paste

A

Ctrl + V

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Uncopy

A

Esc

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Fill Down

A

Ctrl + D

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Paste Once

A

Enter

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Fill Right

A

Ctrl + R

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Show Formula

A

F2

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Paste Special

A

Ctrl + Alt + V

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Fill Formula After Showing Formula

A

Ctrl + Enter

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Hide/Unhide Toolbar

A

Ctrl + F1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Go to Cell A1

A

Ctrl + Home

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move one cell up

A

Up Arrow

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Move one cell left

Left Arrow

Move one cell down

Down Arrow

Move one cell right

Right Arrow

Go to the Linked Cell

Ctrl + [

Deselect to Original Cell

Shift + Backspace

Open "Go To" Dialog Window

F5

Open "Name Manager" Window

Ctrl + F3

Zoom In

Ctrl + Alt + "+"

Zoom Out

Ctrl + Alt + "-"

Highlight Row

Shift + Spacebar

Highlight Column

Ctrl + Spacebar

Delete Column/Row

Ctrl + "-"

Insert Column/Row

Ctrl + "+"

Highlight Cells Up

Shift + Up Arrow

Highlight Cells Down

Shift + Down Arrow

Highlight Cells to the Left

Shift + Left Arrow

Highlight Cells to the Right

Shift + Right Arrow

Bold Text

Ctrl + B

Cross Text

Ctrl + 5

Itilize Text

Ctrl + I

Underline Text

Ctrl + U

Format as Percent

Ctrl + Shift + %

Format as General

Ctrl + Shift + ~

Format as Currency

Ctrl + Shift + $

Find and Replace Window

Ctrl + H

Open "Format Cells" Window

Ctrl + 1

Right Clicking Menu

Shift + F10

AutoSum

Alt + =

Insert Comment

Ctrl + F2

Delete Comment

Esc, Delete

Show All Formulas

Ctrl + ~

Toggle between Edit and Enter mode in cell

F2

Repeat Previous Action

F4

Close Comment

Esc, Esc

Expand/Collapse Formula Bar

Ctrl + Shift + U

Open "Insert Function" Window

Shift + F3

Create New Sheet

Shift + F11