O'Reilly logo

StarOffice™ 5.2 Calc Handbook by Joe Habraken

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 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 ...

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