Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Suppress Header Labels or Total Rows

Explains how to hide labels and "total" rows in OfficeConnect reports.

In your report, you’re likely to have rows that you’ve added manually — using Excel functionality — to clarify or expand on Adaptive data. Typical examples are header labels above Adaptive Planning data or total rows below Adaptive Planning data.

Although these rows are not Adaptive Planning data, you can associate them with Adaptive elements. Then if you want, you can hide them when total rows are all zeros or blanks. This ensures that your report doesn’t look like it’s missing information when zero rows and columns are hidden.

To hide a header label or total row:

  1. If necessary, on the OfficeConnect tab, in the Show group, click Hide Zeros & Blanks SuppressZeroandBlanks.png to turn it off. When you create a new OfficeConnect workbook, the Hide Zeros & Blanks command is off by default.

  2.  Select the header label or total row that you want to hide if its data is all zero.

  3. From the OfficeConnect tab, click Label Suppression SuppressLabels.png.

  1.  Click in the Label Row 1 field.

  2. Select the area that contains Adaptive metadata that you want to associate with your selected header label or total row.

The cell range of the selected area, for example, B5:E13, appears in the Label Row 1 box. If you prefer, you can also type the cell range in the box.
You can also select rows, or type a range such as 2:8 to represent rows 2 through 8. 

When you enter information into the Label Row 1 field, another field appears for row 2. If you want to suppress header labels or total rows for multiple cell ranges or rows, click in the Label Row 2 box, and then select the second cell range or set of rows. Continue entering ranges in succeeding Label Row boxes as needed.

  1.  Click OK.

  2. Click Refresh.

  3.  On the OfficeConnect tab, click Hide Zeros & Blanks  SuppressZeroandBlanks.png to turn it on.
    The header label or total row you associated with any zero rows or columns is now hidden.

  • Was this article helpful?