Filtering Data
While sorting helps you arrange your data, filtering allows you to mask out certain data in the database and view just those records that meet the criteria used by the filter. You have two options for filtering data. First, you can filter the data in the database area using AutoFilter.
When you click the AutoFilter tool on the Main toolbar, a set of drop-down arrows appears at the top of each field name. You use these drop-down lists to select the filter parameters. Records meeting those parameters will remain visible in the database. Records not meeting the filter parameters will be hidden.
You can also set up simple and complex filters using the Standard and Advanced Filter dialog boxes. Standard filter parameters are set up ...
Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
