Excel Shortcuts Flashcards by Jackson Wainwright

Q

Paste

A

Ctrl+V

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

Copy special

A

Ctrl+C

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

Copy the format right in a range

A

Ctrl+R

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Copy the format down in a range

A

Ctrl+D

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Make absolute reference

A

F4

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Sum rows

A

Alt+=

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Insert or Modify comment

A

Shift+F2

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Undo last action

A

Ctrl+Z

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Redo last action

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

Find

A

Ctrl+F

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select and show cell A1

A

Ctrl+Home

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select last used cell

A

Ctrl+End

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select range

A

Shift+Arrow

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Replace

A

Ctrl+H

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select columns

A

Ctrl+Space

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select rows

A

Shift+Space

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select all surrounding cells

A

Ctrl+A

Q

Format cells dialogue

A

Ctrl+1 (control tab to move between tabs)

Q

General number format

A

Ctrl+shift+~

Q

Accounting Format

A

Ctrl+shift+!

Q

Currency format

A

Ctrl+ shift +$

Q

Italic

A

Ctrl+I

Q

Underline

A

Ctrl+U

Q

Bold

A

Ctrl+B

Q

Percentage format

A

Ctrl+Shift+%

Q

Insert time

A

Ctrl+:

Q

Delete cell/range/row/column

A

Ctrl+-

Q

Insert table

A

Ctrl+T

Q

Insert cell/range/row/column

A

Ctrl+Shift++

Q

Insert date

A

Ctrl+;

Q

Move to right sheet

A

Ctrl+Page Down

Q

Move to left sheet

A

Ctrl+Page Up

Q

Open contextual menu (right-click)

A

Shift+F10

Q

Move to edge of data region

A

Ctrl+Arrow

Q

Open ‘Go To’ dialog

A

Ctrl+G

Q

Spellcheck

A

F7

Q

Show cell content and edit cell

A

F2

Q

Hide or show ribbon

A

Ctrl+F1 (or double click something on ribbon)

Q

Lock computer

A

Window+L

Q

Show desktop

A

Window+D

Q

Open this list of keyboard shortcuts

A

Ctrl+Alt+Q

Q

Type in new line within same cell

A

Alt+Enter

Q

Show shortcuts on ribbon

A

Alt+H

Q

Highlight precendents (input cells)

A

Ctrl+[

Q

Highlight antecendents (dependent cells)

A

Ctrl+]

Q

Toggle filter on/off

A

Ctrl+Shift+L