Excel Flashcards by Jason Pack

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

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

Cut

A

Ctrl + X

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

Italics

A

Ctrl + I

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

Format Cells

A

Ctrl + 1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Trace Precedents

A

Ctrl + [

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Trace Dependents

A

Ctrl + ]

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move One Tab to the Left

A

Ctrl + Pg Up

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move One Tab to the Right

A

Ctrl + Pg Dn

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Format Painter

A

Alt + H + FP

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Bottom Border

A

Alt + H + B + O

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Top Border

A

Alt + H + B + P

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Left Border

A

Alt + H + B + L

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Right Border

A

Alt + H + B + R

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

No Border

A

Alt + H + B + N

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

All Borders

A

Alt + H + B + A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Outside Border (thin)

A

Alt + H + B + S

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Thick Outside Border

A

Alt + H + B + T

Q

Bottom Double Border

A

Alt + H + B + B

Q

Thick Bottom Border

A

Alt + H + B + H

Q

Top and Bottom Border

A

Alt + H + B + D

Q

Top and Thick Bottom Border

A

Alt + H + B + C

Q

Top and Double Bottom Border

A

Alt + H + B + U

Q

Select Color to Fill Cell

A

Alt + H + H + Choose Color with Arrows

Q

Clear Color from Cell

A

Alt + H + H + N

Q

Set Font Color to Black

A

Alt + H + FC + Enter

Q

Select Font Color

A

Alt + H + FC + Choose Color with Arrows

Q

Align Text in Top of Cell

A

Alt + H + A + T

Q

Align Text in Middle of Cell

A

Alt + H + A + M

Q

Align Text in Bottom of Cell

A

Alt + H + A + B

Q

Left Align Text

A

Alt + H + A + L

Q

Center Align Text

A

Alt + H + A + C

Q

Right Align Text

A

Alt + H + A + R

Q

Increase Indent

A

Alt + H + 6

Q

Decrease Indent

A

Alt + H + 5

Q

Wrap Text

A

Alt + H + W

Q

Merge and Center

A

Alt + H + M + C

Q

Merge Across

A

Alt + H + M + A

Q

Merge Cells

A

Alt + H + M + M

Q

Unmerge Cells

A

Alt + H + M + U

Q

Set Row Height (to specific number)

A

Alt + H + O + H

Q

Autofit Row Height

A

Alt + H + O + A

Q

Set Column Width (to specific number)

A

Alt + H + O + W

Q

Autofit Column Width

A

Alt + H + O + I

Q

Default Column Width

A

Alt + H + O + D

Q

Select Entire Row

A

Shift + Space

Q

Select Entire Column

A

Ctrl + Space

Q

Add Column or Row (once selected)

A

Ctrl + Shift + “+/= button”

Q

Delete Column or Row (once selected)

A

Ctrl + “-/_ button”

Q

Toggle Between Screens

A

Alt + Tab

Q

Auto Sum Function

A

Alt + “+/= button”