Sort and Filter Flashcards by Wynona Chotiner | Brainscape

Q

advanced filter

A

Alt + A + Q

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

sort smallest to largest

A

Alt + A + SA

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

sort largest to smallest

A

Alt + A + SD

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

display the “sort” dialog box

A

Alt + A + SS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

display the “data validation” dialog box

A

Alt + A + V + V

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

clear filter

A

Alt + H + S + C

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

reapply filter and sort on current range

A

Ctrl + Alt + L

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

turn filter on/off

A

Ctrl + Shift + L

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

filter by the selected cell’s value

A

right mouse button + E + V

How well did you know this?

1

Not at all

2

3

4

5

Perfectly