FreeOfficeTutorials.com logo
Main Page

Microsoft Excel 5F: Columns, Filters and Queries in Spreadsheets

Overview

Columns, Filters & Queries:

  • You can put a filter at the top of a column of data which will list only certain entries in this column.
    • Example: assume a column has 450 dates in it (eg. 01/01/2001 and 01/17/2006). Perhaps you only want to view the names of people who have a date beside thier name after 2003. A filter can be used to hide all the other entries.
  • This is a database feature. You can import and export information from Microsoft Excel into Microsoft Access for much more sophisticated filters and queries.

 

 

 

This website is copyright protected see contact page for details.

stepbystep