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
-
On the visual that you want to change, select any header to open the On-visual menu.
-
Choose Expand all below.
Header height
You can customize table header height.
To customize the height of headers in a table
-
In the Properties pane, choose Headers.
-
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
-
In the Properties pane, choose Headers.
-
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
-
In the Properties pane, choose Headers.
-
Navigate to the TEXT section and do one or more of the following:
-
To change the color of the header text, choose the color swatch underneath Text styling, and then choose the color that you want the table text to be.
-
To change the font or font size of the header text, open the Font or Font size dropdown and choose the font or font size that you want.
-
To bold, italicize, or underline the header text, choose the appropriate icon from the style bar.
-
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 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
-
In the Properties pane, choose Headers.
The Headers section expands to show options for customizing column and row headers.
-
In the Headers section, do one or more of the following:
-
To apply row styling to field names of the rows or columns, choose Style rows label or Style columns label depending on the label that you want to customize.
-
To customize the header font, navigate to the TEXT subsection of the Rows or Columns section and do one or more of the following:
-
To change the color of the header text, choose the color swatch underneath Text styling, and then choose the color that you want the table text to be.
-
To change the font or font size of the header text, open the Font or Font size dropdown and choose the font or font size that you want.
-
To bold, italicize, or underline the header text, choose the appropriate icon from the style bar.
-
-
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 the rows label or column field names, choose the eye icon next to Rows label or Column field names.
-
Header background color
You can customize table headers' background color.
To customize the background color of table headers
-
In the Properties pane, choose Headers.
-
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
-
In the Properties pane, choose Headers.
The Headers section expands to show options for customizing column and row headers.
-
In the Columns section, choose the background color icon, and then choose a color.
-
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
-
In the Properties pane, choose Headers.
-
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
-
In the Properties pane, choose Headers.
The Headers section expands to show options for customizing column and row headers.
-
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
-
Select the hierarchy pivot table that you want to change and open the Format visual menu.
-
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.
-
