Excel Shortcuts Flashcards by Jane Vaughan | Brainscape

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

Edit cell content

A

F2

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Add line break inside a cell (2 options)

A

Alt + Enter or Ctrl + J

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

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

Autosum

A

Alt =

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Date stamp

A

Ctrl + ;

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Time stamp

A

Ctrl + shift + ;

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Open blank workbook

A

Ctrl + N

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move to the next worksheet

A

Ctrl + page down

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move to the previous worksheet

A

Ctrl + page up

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Switch between Excel workbooks

A

Ctrl + Tab

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select data in the current region

A

Ctrl + A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move to first cell in the same row

A

Home

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move to cell A1

A

Ctrl + Home

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Open a workbook

A

Ctrl + O

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Save a workbook

A

Ctrl + S

Q

Close a workbook

A

Ctrl + W

Q

Insert a new worksheet

A

Shift + F11

Q

Bold

A

Ctrl + B

Q

Bring up format dialog box

A

Ctrl + 1

Q

Repeat last edit

A

F4

Q

Enter data but stay on the same cell

A

Ctrl + Enter

Q

Move to the cell on the right

A

tab

Q

Flash Fill

A

Ctrl + E

Q

Go to special

A

Ctrl + G

Q

Insert a note

A

Shift + F2

Q

Move to the bottom of the data region

A

Ctrl + down arrow

Q

Move to the last used cell on the worksheet

A

Ctrl + End

Q

Insert a new cell/row/column

A

Ctrl +

Q

Delete a cell/row/column

A

Ctrl -

Q

Select the row

A

Shift + Space

Q

Select the column

A

Ctrl + Space

Q

Replace

A

Ctrl + H

Q

Create a link to somewhere

A

Ctrl + K

Q

Insert chart (same worksheet)

A

Alt + F1

Q

Insert chart (new worksheet)

A

F11

Q

Debug formula

A

F9

Q

Filter (toggle)

A

Ctrl + Shift + L

Q

Create a 2nd instance of Excel (from Power Query)

A

Windows Key, then hold down Alt, Click Excel and then Yes

Q

Highlight all columns in Power Query

A

Ctrl + A

Q

What is a quick way to set print titles?

A

Highlight the rows & columns you want to set as titles, then type “print_titles” in name box (top right)

Q

Quick way to move rows or columns

A

Shift + drag