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

Study These Flashcards

A

Alt + H + B + T

Q

Bottom Double Border

Study These Flashcards

A

Alt + H + B + B

Thick Bottom Border

Alt + H + B + H

Top and Bottom Border

Alt + H + B + D

Top and Thick Bottom Border

Alt + H + B + C

Top and Double Bottom Border

Alt + H + B + U

Select Color to Fill Cell

Alt + H + H + Choose Color with Arrows

Clear Color from Cell

Alt + H + H + N

Set Font Color to Black

Alt + H + FC + Enter

Select Font Color

Alt + H + FC + Choose Color with Arrows

Align Text in Top of Cell

Alt + H + A + T

Align Text in Middle of Cell

Alt + H + A + M

Align Text in Bottom of Cell

Alt + H + A + B

Left Align Text

Alt + H + A + L

Center Align Text

Alt + H + A + C

Right Align Text

Alt + H + A + R

Increase Indent

Alt + H + 6

Decrease Indent

Alt + H + 5

Wrap Text

Alt + H + W

Merge and Center

Alt + H + M + C

Merge Across

Alt + H + M + A

Merge Cells

Alt + H + M + M

Unmerge Cells

Alt + H + M + U

Set Row Height (to specific number)

Alt + H + O + H

Autofit Row Height

Alt + H + O + A

Set Column Width (to specific number)

Alt + H + O + W

Autofit Column Width

Alt + H + O + I

Default Column Width

Alt + H + O + D

Select Entire Row

Shift + Space

Select Entire Column

Ctrl + Space

Add Column or Row (once selected)

Ctrl + Shift + "+/= button"

Delete Column or Row (once selected)

Ctrl + "-/_ button"

Toggle Between Screens

Alt + Tab

Auto Sum Function

Alt + "+/= button"