FilteringTips

FilteringTips - Excel Filtering Tips Autofilter by Example...

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

View Full Document Right Arrow Icon
1 Excel Filtering Tips Autofilter by Example While you’re viewing a large Excel list, you can scroll to a row that contains data of interest and then quickly filter the list to display all rows that have values matching the value in the selected cell. To do this, you must first add the special “Autofilter” button to a toolbar. How to: 1. Choose View, Toolbars, Customize to open the “Customize” dialog. 2. Click the “Commands” tab to bring it to the fore. 3. Scroll down the list of Categories (at left) and select “Data”. 4. Then scroll down the list of “Commands” (at right) and select “Autofilter”. 5. Drag this command to any existing toolbar (your Standard toolbar for example) and drop it to add a button to the toolbar that looks like the one in the illustration at right. Now: You need not have the Autofilter turned on to use the Autofilter button. Select any cell in the list that has a value of interest. Click the “Autofilter” button you just added to a toolbar. Excel automatically turns on the Autofilter and filters using the value in the selected cell. If you want to apply multiple filters to the list, continue in the same way. That is, select a cell in the now-filtered list that contains a value you want to use to filter the list further.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 3

FilteringTips - Excel Filtering Tips Autofilter by Example...

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