Headers

Expand all headers

You can choose to expand all headers in a pivot table to show all child and grandchild rows of a header.

To expand all headers of a pivot table

  1. On the visual that you want to change, select any header to open the On-visual menu.

  2. Choose Expand all below.

Header height

You can customize table header height.

To customize the height of headers in a table

  1. In the Format visual pane, choose Headers.

  2. For Row height, enter a number in pixels. You can enter a whole number from 8 through 500.

To customize the height of headers in a pivot table

  1. In the Format visual pane, choose Headers.

  2. In the Columns section, for Row height, enter a number in pixels. You can enter a whole number from 8 through 500.

Header text

You can customize table header text.

To customize header text in a table

  1. In the Format visual pane, choose Headers.

  2. In the Headers section, do one or more of the following:

    • 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. Follow the previous procedure for increasing header height.

    • To customize the size of the text, choose a text size. You can choose between extra small and extra large text.

    • To change the font color, choose the Abc color icon, and then choose 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, choose 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, choose a vertical alignment icon. You can choose top alignment, middle alignment, or bottom alignment.

To customize header text in a pivot table

  1. In the Format visual pane, choose Headers.

    The Headers section expands to show options for customizing column and row headers.

  2. In the Headers section, do one or more of the following:

    • To apply row styling to field names, choose Style field names under Rows.

    • To customize the header text size, choose a text size for Text. You can customize the text size for column headers in the Columns section, and row headers in the Rows section.

    • To change the header font color, choose the Abc color icon, and then choose a color. You can choose a font color for column headers in the Columns section, and for row headers in the Rows section. 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, choose an alignment icon. You can choose left alignment, center alignment, right alignment, or automatic alignment. You can choose a horizontal alignment for column headers in the Columns section, and for row headers in the Rows section.

    • To change the vertical alignment of text in the header, choose an alignment icon. You can choose top alignment, middle alignment, or bottom alignment. You can choose a vertical alignment for column headers in the Columns section, and row headers in the Rows section.

    • To hide column field names, choose Hide column field names.

Header background color

You can customize table headers' background color.

To customize the background color of table headers

  1. In the Format visual pane, choose Headers.

  2. For Background, choose the background color icon, and then choose 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 customize the background color of pivot table headers

  1. In the Format visual pane, choose Headers.

    The Headers section expands to show options for customizing column and row headers.

  2. In the Columns section, choose the background color icon, and then choose a color.

  3. In the Rows section, choose the background color icon, and then choose a color.

Header borders

You can customize header borders' color.

To customize header borders in a table

  1. In the Format visual pane, choose Headers.

  2. For Borders, do one or more of the following:

    • To customize the type of border that you want, choose a border type icon. You can choose no borders, horizontal borders only, vertical borders only, or all borders.

    • To customize the border thickness, choose a border thickness.

    • To customize the border color, choose the border color icon, and then choose a color. You can choose one of the provided colors, reset the border color to the default color, or create a custom color.

To customize header borders in a pivot table

  1. In the Format visual pane, choose Headers.

    The Headers section expands to show options for customizing column and row headers.

  2. In the Columns and Rows sections, for Borders, do one or more of the following:

    • To customize the type of border that you want, choose a border type icon. You can choose no borders, horizontal borders only, vertical borders only, or all borders.

    • To customize the border thickness, choose a border thickness.

    • To customize the border color, choose the border color icon, and then choose a color. You can choose one of the provided colors, reset the border color to the default color, or create a custom color.

Header styling options for hierarchy pivot tables

You can hide or rename the Rows label of a hierarchy pivot table.

To make changes to the Rows label of a hierarchy pivot table

  1. Select the hierarchy pivot table that you want to change and open the Format visual menu.

  2. In the Headers section, you can perform the following tasks

    • Choose Hide rows label to hide the Rows label from your pivot table.

    • For Rows label, enter the label that you want displayed on the pivot table.