You can hide rows, columns, or individual cells in which all of the values are zero, or are above or below a certain amount, using the options in the Hide tab. For more information, see Hiding rows, columns, and cells.

To display this tab, choose Tables > Properties from the menu and click the Hide tab.

Check this box to hide rows, select a condition from the list, and then enter a value. For example, select less than, and then enter a value of 50 to hide rows where values are less than 50. You must then specify the column to use to test the condition in the based on list. The default is Base Count, which hides rows where the value in the base column is less than 50.

If you do not want the hide condition to apply to rows containing means, standard deviation and other special items, select ignore special elements.

Check this box to hide columns, then select a condition from the list and enter a value. For example, select less than and enter a value of 50 to hide columns where values are less than 50. You must then specify the row to use to test the condition in the based on list. The default is Base Count, which hides columns where the value in the base row is less than 50.

If you do not want the hide condition to apply to columns containing means, standard deviation and other special items, select ignore special elements.

Check this box to hide cells, then select a condition from the list and enter a value. For example, select less than and enter a value of 50 to hide cells where values are less than 50.

Click this button to use the changes you make on this tab as the default settings for all new tables that you create.

Sets all the properties for the selected tables to their default values. This affects all the properties in the dialog, not only the ones on the current tab.