Using Spreadsheets

Use the Spreadsheet panel to view and manipulate data cell values and modify or add additional data.

Navigation:

• Click the Spreadsheet button.

• Select View > Spreadsheet.

This example illustrates the fields and controls on the Spreadsheet panel. You can find definitions for the fields and controls later on this page.

A spreadsheet displays the current dataset information in a grid format. Subsets within the dataset appear across the bottom of the spreadsheet. The spreadsheet functions much like a Microsoft Excel spreadsheet.

You can enter additional data in the cells or change existing data. You can copy, cut, and paste data within cells. Use the horizontal scroll bar at the bottom of the display to view additional data columns.

Click each subset at the bottom of the spreadsheet to see the data associated with that subset.

You can also export the data on the spreadsheet to a Microsoft Excel spreadsheet and other application types. To export the data, select File, Export, and the appropriate options.