Suppress Row, Suppress Column, Indent Row Members & Number Formats

2 Minutes to read

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Suppress Row

Suppressing rows in a spreadsheet is the process of hiding certain rows from view. It helps you to create summary reports or hide some information. The below set of options are available to do ad-hoc analysis:

None: By selecting None, all rows, including Blank and Zero rows, are displayed in the view.

Note:

This is the default value.

Zero: By selecting Zero, the rows with zero values will be hidden from the view.
Blank: By selecting Blank, the rows that do not have data (blank) will be hidden from the view
Both: By selecting Both, the rows with zero values or blank rows are hidden from the view.

In Practice: Suppress Row

Select the required row, and click the vertical ellipsis icon.
The sub-menu bar appears; click the Suppress Row icon.
Select the required option.

Suppress Column

Suppress columns help to hide or remove unnecessary information from a dataset, reduce the size of the dataset, and help to keep only the columns that are required for a particular task.

None: By selecting None, all columns, including Blank and Zero columns, are displayed in the view.

Note:

This is the default value.

Zero: By selecting Zero, the columns with zero values will be hidden from the view.
Blank: By selecting Blank, the columns that do not have data (blank) will be hidden from the view
Both: By selecting Both, the rows with zero values or blank columns are hidden from the view.

In Practice: Suppress Column

Select the required row, and clickthe vertical ellipsis icon.
The sub-menu bar appears, click the Suppress Column icon.
Select the required option.

Indent Row Members

Indenting row members help to identify the hierarchical relationship between the parent and its children members and are especially useful for large datasets with multiple levels of hierarchy. Another benefit is that it helps to improve the readability of the data. Additionally, it also helps simplify navigation through the dataset.

YES: Select YES to indent data.
NO: Select NO to keep the data unindented.

Note:

The default value is NO.

In Practice: Indent Row