Excel Terms and shortcuts

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/20

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

21 Terms

1
New cards

cmd + 0

Hide Column

2
New cards

cmd + 9

hide row

3
New cards

cmd + shift + 9

unhide column

4
New cards

cmd + shift + 9

unhide row

5
New cards

cmd + shift + F

add/remove filter

6
New cards

Filter

Temporarily hides rows that don;t meet selected criteria. Access via right-click, Home tab, or Data tab

7
New cards

Sorting

Reorders data by one or more levels. Access via right-click, Home tab, or Data tab

8
New cards

Conditional Formatting

applies formatting based on rules/criteria. Found in the Style group on the Home tab. Dynamically updates based on data changes

9
New cards

Filter

knowt flashcard image

<img src="https://knowt-user-attachments.s3.amazonaws.com/0b38abbc-416e-4b9f-b07f-b58c43a98ae7.png" data-width="100%" data-align="center" alt="knowt flashcard image"><p></p>
10
New cards

Sorting

knowt flashcard image

11
New cards

Conditional formatting

knowt flashcard image

12
New cards

CMD + P

Open print dialogue

13
New cards

14
New cards
15
New cards
16
New cards
17
New cards
18
New cards
19
New cards
20
New cards
21
New cards