O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filtering worksheet data

When you want to look at a subset of your data or display only data values related to a specific category of information, you can apply filters to that data. You use the Filter tool on the Data tab to instruct Excel 2013 as to how you want to filter the information on the worksheet. When you filter your data, the data items that don’t meet the filter criteria are hidden temporarily so that you can view only the data you need.

You can also use slicers to filter your data in real time in a table format. Slicers are simple, graphical tables with which you can display your data in different ways without changing selections on the worksheet. Slicers are easy to add and can be an effective tool for showing how your data looks ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required