Excel Hot Keys Flashcards by Maxwell Pedroza | Brainscape

Q

New file

A

Ctrl + N

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Open file

A

Ctrl + O

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Save file

A

Ctrl + S

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Close file

A

Ctrl + F4

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Save as

A

F12

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Exit Excel

A

Alt + F4

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Print

A

Ctrl + P

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Edit active cell

A

F2

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Cancel cell editing

A

Escape Key

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

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

Copy right

A

Ctrl + R

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Copy down

A

Ctrl + D

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Create cell comment

A

Shift +F2

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

Format currency

A

Ctrl + Shift + 4

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Format as date

A

Ctrl + Shift + 3

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Format as percentage

A

Ctrl + Shift + 5

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Format as number

A

Ctrl + Shift + 1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Bold

A

Ctrl + B

Q

Italicize

A

Ctrl + I

Q

Underline

A

Ctrl + U

Q

Strikethrough

A

Ctrl + 5

Q

Add cell borders

A

Ctrl + Shift + 7

Q

Remove all borders

A

Ctrl + Shift + - ( minus)

Q

Select entire worksheet

A

Ctrl + A

Q

Select group area

A

Ctrl + Shift + 8

Q

Select column

A

Ctrl + Space

Q

Select row

A

Ctrl + Spacebar

Q

Select Manually

A

Hold Shift + Left, Right, Up, Down Arrow Key

Q

Up one screen

A

Page Up

Q

Down one screen

A

Page Down

Q

Move to next worksheet

A

Ctrl + Page Down

Q

Move to previous worksheet

A

Ctrl + Page Up

Q

Go to first cell in worksheet area

A

Ctrl + Home

Q

Go to last cell in worksheet area

A

Ctrl + End

Q

Go to formula source

A

Ctrl + {

Q

Go to a cell

A

F5

Q

Find text

A

Ctrl + F

Q

Replace text

A

Ctrl + H

Q

Undo last action

A

Ctrl + Z

Q

Redo last action

A

Ctrl + Y

Q

Create a chart

A

F11

Q

Spell check

A

F7

Q

Show all formulas

A

Ctrl + ~

Q

Insert columns/rows

A

Ctrl + Shift + + (plus sign)

Q

Insert a new worksheet

A

Ctrl + F11

Q

Move between open workbooks

A

Ctrl + F6

Q

Autosum

A

Alt + = (equals sign)

Q

Merge Cells

A

Sequence: Ctrl + 1 , A , Alt +M

Q

Autofit Column Width

A

Alt, H, O, I