Format headers in tables and pivot tables

Prerequisites

Page location

Insights > Analyses > Click an analysis > Click a table

Procedures

Expand all headers in a pivot table

Expanding all the headers in a pivot table shows all child and grandchild rows of a header.

  1. Click any header.
  2. Select Expand all below.

Customize the height of headers

Height is measured in pixels.

  1. Click the Format visual icon in the upper-right corner of the table. The Properties panel opens.
  2. Expand Headers.
  3. Enter the height in the Row height (pixels) field. You can enter a whole number from 8 through 500.

Customize the header text

  1. Click the Format visual icon in the upper-right corner of the table. The Properties panel opens.
  2. Expand Headers.

  3. In the Text section, do one or more of the following. In pivot tables, you customize the header text for Rows and Columns separately.

    • To wrap text in headers that are too long to fit, select Wrap text. Wrapping text in a header doesn't automatically increase the height of the header. To increase the header height, see Customize the height of headers.
    • To customize the size of the text, select a text size from the drop-down list. Size options range from Extra small to Extra large.
    • To change the font color, click the black square next to Text, and then select a color. You can choose one of the provided colors, reset the header text color to the default color, or create a custom color.
    • To change the horizontal alignment of text in the header, click a horizontal alignment icon. You can choose left alignment, center alignment, right alignment, or automatic alignment.
    • To change the vertical alignment of text in the header, click a vertical alignment icon. You can choose top alignment, middle alignment, or bottom alignment.

Customize the header background color

  1. Click the Format visual icon in the upper-right corner of the table. The Properties panel opens.
  2. Expand Headers.
  3. Click the white square next to Background, and then select a color. You can choose one of the provided colors, reset the header text color to the default color, or create a custom color. In pivot tables, you select a background color for Rows and Columns separately.

Customize the header borders

  1. Click the Format visual icon in the upper-right corner of the table. The Properties panel opens.
  2. Expand Headers.

  3. In the Borders section, do one or more of the following. In pivot tables, you customize the header borders for Rows and Columns separately.

    • To customize the type of border that you want, click a border type icon. You can choose no borders, horizontal borders only, vertical borders only, or all borders.
    • To customize the border thickness, select a border thickness from the drop-down.
    • To customize the border color, click the gray square next to Borders, and then select a color. You can choose one of the provided colors, reset the border color to the default color, or create a custom color.

Show or rename the Rows label of a hierarchy pivot table

  1. Click the Format visual icon in the upper-right corner of the table. The Properties panel opens.
  2. Expand Headers.
  3. Click Show (the eyeball icon).
  4. (Optional) To rename the Rows label, enter the text in the Rows label field.

Related topics