# Headers
Headers

## Expand all headers
Expand 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.

1. Choose **Expand all below**.

## Header height
Header height

You can customize table header height.

**To customize the height of headers in a table**

1. In the **Properties** pane, choose **Headers**.

1. 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 **Properties** pane, choose **Headers**.

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

## Header text
Header text

You can customize table header text.

**To customize header text in a table**

1. In the **Properties** pane, choose **Headers**.

1. 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**

1. In the **Properties** pane, choose **Headers**.

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

1. 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
Header background color

You can customize table headers' background color.

**To customize the background color of table headers**

1. In the **Properties** pane, choose **Headers**.

1. 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 **Properties** pane, choose **Headers**.

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

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

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

## Header borders
Header borders

You can customize header borders' color.

**To customize header borders in a table**

1. In the **Properties** pane, choose **Headers**.

1. 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 **Properties** pane, choose **Headers**.

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

1. 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.

1. 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.