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

Working with the DataPilot

When you work with large spreadsheets, where the amount of data seems overwhelming, or with spreadsheets where you want to quickly rearrange how the data is displayed or summarized, you can use the DataPilot to create a pivot table. The DataPilot's table cross-tabulates the information into rows and columns, making it easy for you to quickly analyze the data.

Since you can manipulate a DataPilot table even after you've created it, you can view your data in different ways without creating different tables from scratch. The DataPilot table derives its data from your original spreadsheet, so if you delete the DataPilot table, you aren't affecting the original spreadsheet at all.

To Create a DataPilot Table

1.
You can ...

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