Shortcut Flashcards by Zhang Claire | Brainscape

Q

Filter

A

Ctrl + Shift + L

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Add Table

A

Ctrl + T

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Move to the edge of data

A

Ctrl + ˅
Ctrl + ˄
Ctrl + ˃
Ctrl + ˂

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Extend selection of cells

A

Ctrl + Shift + ˃

2. Ctrl + Shift +˅

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

Automatic Sum

A

Alt + =

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

New line in cell

A

Alt + Enter

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select entire data in current region

A

Ctrl + A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select entire row

A

Shift + Space

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Select entire column

A

Ctrl + Space

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Insert new row or column

A

select the row or column first, then Ctrl + +

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Flash fill

A

select the entire field first, then Ctrl + E

How well did you know this?

1

Not at all

2

3

4

5

Perfectly