AX2774

Changing views in an Axiom file

If views have been defined for a sheet in a spreadsheet Axiom file, you can change the view to 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. You might have the option to toggle certain rows and columns as hidden or shown, such as to select which quarters you want to view. The specific view options available depends 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.

This displays a menu showing all views defined in the current sheet. You can click on 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 one time. Some views may open a dialog where you can select specific sets of rows or columns to show. The specific behavior of each view depends on the file designer. Ideally the name of the view will give you a good idea of what to expect when that particular view is selected.

After any view is made active, the freeze panes setting for the sheet is also reapplied. Axiom Software keeps track of the currently active views in a sheet and will reapply them after you perform certain activities in a sheet, such as refreshing an Axiom query or inserting a calc method.