# Show/hide values The Planning Sheet 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/unhide multiple cells or cell ranges in a single click. Use Ctrl/Shift and click to select non-adjacent or adjacent cells, then click on the hide/unhide icon.

## 2. Rows a) To hide a row or multiple rows, select the rows using Shift/Ctrl + and click on the hide icon.

b) To unhide, click on the 'Show/hide' dropdown -> 'Rows' -> 'Unhide'. You can choose to unhide selected rows or all 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/columns and click on the 'Hide' icon.

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

c) To unhide, click on the 'Show/hide' dropdown -> 'Columns' -> 'Unhide'. You can choose to unhide selected columns or all columns as required.

## 4. Measures You can also hide/unhide measure or row hierarchies by unchecking/checking the check box under the Manage Columns option. By default, all the Rows and Measures are checked and visible.

To hide a measure/row uncheck the corresponding checkbox. In the image below the Variant rows and the Revenue columns are hidden.

Hiding rows/columns using the manage column option

You can unhide them by checking the corresponding boxes under the manage columns. ## 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.

The image below shows the Quarter Name hidden, which can be unhidden by clicking on the Unhide icon.

## 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. You can skip/hide rows from the action options in the row gripper, as shown in the image below.

The hidden/skipped rows can be shown using the unhide option.

## 7. Displaying measures for specific time periods

You can use the **Show/hide Measures** interface to display the data for a particular period. You can create and save specific time ranges for measures and instantly access them like bookmarks. You will need to enter a name to identify the measure time range, choose the measures to display, and select the time interval. {% hint style="info" %} Disable the **Show** toggle to hide measures for a specific time frame. {% endhint %}

Show/Hide measures for specific time range

You can leverage the **date picker** to select the time range.

You can also display measures for **relative time periods** like last n days/weeks/months/years.

Another option is to use Plan's built-in date and time intelligence functions to display measures over a specific range of time. Select the **Date Functions** option in the Show/Hide measures interface. In the example below, we are displaying the Units Sold measure based on the end of the week and end of the month in the report.

Using date functions to show/hide measures

After you create and save a measure time range, you can instantly switch between them and analyze your data.

--- # 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.fabricplan.com/planning/working-with-lumel-epm/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.