Edit analysis tables

You can create tables in queries or ad hoc analyses as a result view. In tables, you can evaluate data and perform calculations in the same way as in models of the Spreadsheet type.

You can save them as models of the Spreadsheet type.

Topics

Sort query table output

Merge or unmerge query table output cells

Sort ad hoc analysis table output

Add attributes to a spreadsheet

Save attributes

Restore default column width

Specify column width

Specify row height

Restore default row height

Change formula parameters

Create conditional formatting for cells

Protect an area of a spreadsheet

Correct error(s) in formular

Use fixed cell references

Clear formats

Select format type

Insert formula directly

Insert formula

Clear contents

Clear contents and formats

Add contents to a spreadsheet

Copy items to spreadsheet

Calculate with physical constants

Define a border

Remove borders

Manage rules

Use relative cell references

Unprotect table

Save table view as a model

Export spreadsheet to Microsoft Excel

Insert sheet

Delete sheet

Working with cell references across sheets

Calculate values in a spreadsheet

How to select multiple items in query output tables