Suppress zeros

You can hide rows and columns in a view that contain only zeros.

You can suppress zeros in a view from the shortcut bar, by right-clicking on a row or column selector and selecting Suppress zeros, or by using the zero snap command.

Procedure

  1. To suppress zeros from the shortcut bar:
    1. Click anywhere on the view to display the shortcut bar handle.
      If you are using the new experience view, click anywhere on the view to select it.
    2. Click the handle, then click suppress zeros.
      If you are using the new experience view, click Suppress zeros in the toolbar.
    3. Select a zero suppression option.
      All
      Suppress all rows and all columns that contain only zeros.
      Rows
      Suppress all rows that contain only zeros.
      Columns
      Suppress all columns that contain only zeros.
    4. Click OK.
    5. To unsuppress zeros, clear your selection.
  2. To suppress zeros from a row or column selector:
    1. Right-click either the row selector or the column selector, then select Suppress zeros.
      You can also unsuppress zeros from this menu.
    2. You can suppress zeros on nested rows or columns by right-clicking the selector for the nested row or column and selecting Suppress zeros.