Lesson 21 - display In this example you would choose West...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Lesson 21: Using AutoFilter Page 1 By the end of this module, learners should be able to: Filter data in a spreadsheet Page 2 Using AutoFilter Watch the video! (1:05 min) - Tips for watching our videos. The AutoFilter feature makes filtering, or temporarily hiding, data in a spreadsheet very easy. This allows you to focus on specific spreadsheet entries. To Use AutoFilter: Select Data from the main menu. Select Filter AutoFilter . Click the drop-down arrow next to the heading you would like to filter. For example, if you would like to only view data from the West Sales Region , click the drop-down arrow next to Sales Region .
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Choose the data you would like to
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: display . In this example, you would choose West . All other data will be filtered, or hidden, and only the West Sales Region data is visible. Click the drop-down arrow again and select All to display all of your original data. Page 3 Challenge! Download and save the Employee Sales spreadsheet to complete this Challenge. Need help? How to Download a File • Open the Employee Sales spreadsheet. • Use the AutoFilter feature to filter all entries except for the North Sales Region . • Continue to use AutoFilter until you are comfortable with this feature. • Save and close the spreadsheet....
View Full Document

{[ snackBarMessage ]}

Page1 / 2

Lesson 21 - display In this example you would choose West...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online