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

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 DocumentRight 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

Page1 / 2

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

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