Topics Map > IT Services > Training
Topics Map > IT Services > Software Support

Microsoft Excel 2016 - Filters

This guide will show you how to use filters to show only portions of data that you want to see.

Being able to filter the data is extremely important, especially when dealing with hundreds or thousands of pieces of information. This way, it can be parsed down to just the necessary information without actually deleting the rest.

  1. Select any cell within the data field.
  2. Select the Data Tab.
  3. Select the Filter Tool.2 This automatically adds filters to each header column.
  4. Filter data as necessary.

If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or

Keywords:"Data Management", "filter tool"   Doc ID:65970
Owner:Richard L.Group:UW Oshkosh
Created:2016-08-10 15:32 CDTUpdated:2016-08-10 15:33 CDT
Sites:UW Oshkosh
Feedback:  0   0