# Show/hide values Inforiver allows you to hide/unhide cells, rows, columns or measures from the toolbar in a single click. ## 1. Cells a) To hide a cell, click on the cell and then the hide icon highlighted.

b) The cell gets hidden. You can also see that the hide icon is highlighted to indicate that the cell has been hidden. Formatting options are also greyed out in the 'Style' and 'Alignment' sections.

c) You can hide multiple cells or cell ranges in a single click. Use Ctrl/Shift and click to select non-adjacent or adjacent cells.

d) To unhide, select the cell(s) and click on the unhide option.

## 2. Rows a) To hide a row or multiple rows, make a selection and click on the hide icon.

b) To unhide, click on the 'Show/hide' dropdown -> 'Rows' -> 'Unhide'.

c) Multiple rows can be hidden at a time.

d) When multiple rows are hidden, you can choose to unhide selected rows as required.

## 3. Columns In this example, we have sub-categories in the column field. Let's say you want to hide Juices -> 2021 Actuals alone. This can be achieved using 'Show/hide columns'. a) Select the column and click on the 'Hide' icon.

b) The column gets hidden.

c) You can also hide individual columns from the column gripper as shown below.

d) Multiple columns can be hidden by using Shift/Ctrl + click.

## 4. Measures In this example, we have sub-categories in the column field. Let's say you want to hide 2021 Actuals for all the sub-categories. This can be achieved using 'Manage columns'. a) Click on the 'Manage columns' dropdown. A list of the row hierarchies and the measures is displayed. To hide 2021 Actuals, uncheck the highlighted checkbox.

b) 2021 Actuals are hidden.

c) To show a measure, check the corresponding checkbox.

## 5. Measure headers and category headers You can select the measure header and click on the hide icon if you do not want to display headers in your reports. Repeat the procedure to display a hidden measure/category header again.

## 6. Displaying hidden/skipped rows To enable hidden or skipped rows, navigate to the Show/hide dropdown > Rows section and click on the respective icon to display the row again in your report.

In the next section, we'll cover how to [manage column widths](/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/3.-basic-interactions/manage-column-widths.md). --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.inforiver.com/~/changes/mS6jwvARNLHpKqBa4cT9/working-with-inforiver/3.-basic-interactions/show-or-hide-values-rows-and-columns.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.