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