Excel Shortcuts Flashcards by Paul Blankenship

Q

Edit active cell

A

F2

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Go to

A

F5

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Spelling for selected range

A

F7

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Create chart

A

F11

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Insert new worksheet

A

Alt Shift F1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Insert function

A

Shift F3

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Find

A

Shift F5

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Enter current time

A

Ctrl Shift Colon

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Enter current date

A

Ctrl semicolon

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select all

A

Ctrl A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Bold

A

Ctrl B

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Italicize

A

Ctrl I

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Insert hyperlink

A

Ctrl K

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Underline

A

Ctrl U

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Strike-through

A

Ctrl 5

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Print

A

Ctrl P

Q

Undo

A

Ctrl Z

Q

Minimize workbook

A

Ctrl F9

Q

Maximize workbook

A

Ctrl F10

Q

Switch to next workbook

A

Ctrl F6

Q

Previous sheet

A

Ctrl PageUp

Q

Next sheet

A

Ctrl PageDown

Q

Next tab

A

Ctrl Tab

Q

Insert value of cell above

A

Ctrl Apostrophe

Q

Apply number format

A

Ctrl Shift !

Q

Apply currency format

A

Ctrl Shift $

Q

Apply date format

A

Ctrl Shift #

Q

Apply percentage format

A

Ctrl Shift %

Q

Apply exponential format

A

Ctrl Shift ^

Q

Apply time format

A

Ctrl Shift @

Q

Move to the edge of the current data region in a worksheet

A

Ctrl arrow

Q

Select column

A

Ctrl space

Q

Select row

A

Shift space