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

Q

Move one cell left

A

Left Arrow

Q

Move one cell down

A

Down Arrow

Q

Move one cell right

A

Right Arrow

Q

Go to the Linked Cell

A

Ctrl + [

Q

Deselect to Original Cell

A

Shift + Backspace

Q

Open “Go To” Dialog Window

A

F5

Q

Open “Name Manager” Window

A

Ctrl + F3

Q

Zoom In

A

Ctrl + Alt + “+”

Q

Zoom Out

A

Ctrl + Alt + “-“

Q

Highlight Row

A

Shift + Spacebar

Q

Highlight Column

A

Ctrl + Spacebar

Q

Delete Column/Row

A

Ctrl + “-“

Q

Insert Column/Row

A

Ctrl + “+”

Q

Highlight Cells Up

A

Shift + Up Arrow

Q

Highlight Cells Down

A

Shift + Down Arrow

Q

Highlight Cells to the Left

A

Shift + Left Arrow

Q

Highlight Cells to the Right

A

Shift + Right Arrow

Q

Bold Text

A

Ctrl + B

Q

Cross Text

A

Ctrl + 5

Q

Itilize Text

A

Ctrl + I

Q

Underline Text

A

Ctrl + U

Q

Format as Percent

A

Ctrl + Shift + %

Q

Format as General

A

Ctrl + Shift + ~

Q

Format as Currency

A

Ctrl + Shift + $

Q

Find and Replace Window

A

Ctrl + H

Q

Open “Format Cells” Window

A

Ctrl + 1

Q

Right Clicking Menu

A

Shift + F10

Q

AutoSum

A

Alt + =

Q

Insert Comment

A

Ctrl + F2

Q

Delete Comment

A

Esc, Delete

Q

Show All Formulas

A

Ctrl + ~

Q

Toggle between Edit and Enter mode in cell

A

F2

Q

Repeat Previous Action

A

F4

Q

Close Comment

A

Esc, Esc

Q

Expand/Collapse Formula Bar

A

Ctrl + Shift + U

Q

Open “Insert Function” Window

A

Shift + F3

Q

Create New Sheet

A

Shift + F11