AX2774

Changing views in an Axiom file

If views are defined for a sheet in a spreadsheet Axiom file, you can change how information is presented in the sheet.

For example, you might have the option to switch between a Detail sheet view and a Summary sheet view, or you might have the option to toggle certain rows and columns as hidden or shown to select which quarters you want to view. The available view options depend on the file design.

To change the views in a sheet:

On the Axiom tab, in the File Options group, click Change view.

NOTE: In systems with installed products, this feature may be located on the Main tab.

A menu displays all views that are defined in the current sheet. You can click a view name to activate that view.

Some views are single-selection, which means that activating one view deactivates the prior view. Other views allow for additive selections so that multiple views can be active at the same time. Some views may open a dialog where you can select specific sets of rows or columns to be displayed. The specific behavior of each view depends on the file designer.

After you make any view active, the freeze panes setting for the sheet is also reapplied. Axiom tracks the active views in a sheet and reapplies them after you perform certain activities in a sheet, such as refreshing an Axiom query or inserting a calc method.