# Table and pivot table formatting options in Quick Table and pivot table options You can customize tables and pivot tables in Quick to meet your business needs. You can customize table headers, cells, and totals by specifying the color, size, wrap, and alignment of text in each. You can also specify the height of rows in a table, add borders and grid lines, and add custom background colors. In addition, you can customize how to display totals and subtotals. If you have applied conditional formatting to a table or pivot table, it takes precedence over any other styling you configure. When you export table or pivot table visuals to Microsoft Excel, the formatting customizations that you applied to the visual aren't reflected in the downloaded Excel file. **To format a table or pivot table** + In your analysis, choose the table or pivot table that you want to customize, and then choose the **Format visual** icon. ![\[Image of the Format visual icon.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-tables-icon.png) The **Properties** pane opens at left. Following, you can find descriptions for options for customizing each area of your table or pivot table in the **Properties** pane. **Topics** + [ # Headers ](format-tables-headers.md) + [ # Cell formatting ](format-tables-pivot-tables-cells.md) + [ # Totals and subtotals ](format-tables-pivot-tables-totals.md) + [ # Row and column size in tables and pivot tables in Quick ](format-tables-pivot-tables-resize-rows-columns.md) + [ # Customize pivot table data ](format-tables-pivot-tables-layout-options.md) # 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. # Cell formatting Cell formatting ## Row height Row height You can customize table row height. **To customize the height of rows in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 1. For **Row height**, enter a number in pixels. You can enter a whole number from 8 through 500. ## Cell text Cell text You can customize the formatting for cell text within a table. **To format the cell text in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 1. For **Text**, do one or more of the following: + To change the color of the cell 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 cell text, open the **Font** or **Font size** dropdown and choose the font or font size that you want. + To bold, italicize, or underline the cell 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 cells doesn't automatically increase the row height. Follow the previous procedure for increasing row height. + To change the horizontal alignment of text in cells, choose a horizontal alignment icon. You can choose left alignment, center alignment, right alignment, or automatic alignment. Horizontal alignment can only be configured for the **Rows** fields of a hierarchy pivot table. + To change the vertical alignment of text in cells, choose a vertical alignment icon. You can choose top alignment, middle alignment, bottom alignment, or automatic. For tabular pivot tables, the value for **Automatic** is vertical. For hierarchy pivot tables, the value for **Automatic** is middle. ![\[Vertical and horizontal cell alignment options in the Format visual menu.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-pivot-table-alignment.png) ## Cell background color Cell background color You can customize table cells' background color. **To customize the background color of cells in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 1. For **Background**, do one or more of the following: + To alternate background colors between rows, select **Alternate row colors**. Clearing this option means that all cells have the same background color. + If you choose to alternate background colors between rows, choose a color for **Odd rows** and a color for **Even rows** by choosing the background color icon for each and selecting a color. You can choose one of the provided colors, reset the background color to the default color, or create a custom color. + If you choose not to alternate background colors between rows, choose the background color icon and select a color for all cells. You can choose one of the provided colors, reset the background color to the default color, or create a custom color. ## Cell borders Cell borders You can customize table cells' borders. **To customize the borders for cells in a table or pivot table** 1. In the **Properties** pane, choose **Cells**. The **Cells** section expands to show options for customizing cells. 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. # Totals and subtotals Totals and subtotals On tables and pivot tables, you can configure the display of totals or subtotals. Tables can display totals at the top or the bottom of the visual. Pivot tables can display totals and subtotals on rows and columns. ## Add totals and subtotals to tables and pivot tables in Quick Position totals and subtotals You can add total columns to your table and pivot table visuals. You can also add subtotal columns to your pivot table visuals. **To display or hide totals and subtotals for a pivot table** 1. To display totals, open the **Properties** pane and choose **Total**. + To show totals for rows, toggle the **ROWS** switch on. Totals are displayed on the bottom row of the visual. Choose **Pin totals** to keep the totals visible as you scroll through the table. + To show totals for columns, toggle the **COLUMNS** switch on. Totals are displayed on the last column of the visual. 1. To display totals, open the **Properties** pane and choose **Subtotal**. + To show subtotals for rows, toggle the **ROWS** switch on. Totals are displayed on the bottom row of the visual. + To show subtotals for columns, toggle the **COLUMNS** switch on. + For **Level**, choose one of the following: + Choose **Last** to only show the subtotal of the last field in the chart's hierarchy. This is the default option. + Choose **All** to show subtotals for every field. + Choose **Custom** to customize which fields show subtotals. After you add row totals to your table or pivot table visual, you can also choose to position the totals at the top or bottom of the visual. You can also change the position of column totals in pivot tables. **To position row or column totals in a table or pivot table** 1. In the **Properties** pane, choose **Total**. 1. (Optional) For **Rows**, choose **Show totals**. 1. (Optional) For **Columns**, choose **Show totals**. 1. (Optional) In the **Rows** menu, open the **Position** dropdown and choose the position that you want the totals to be displayed. Choose **Top** to position totals at the top of the table, or **Bottom** to position totals at the bottom of the table. 1. (Optional) In the **Columns** menu, open the **Position** dropdown and choose the position that you want the totals to be displayed. Choose **Left** to position totals at the left of the table, or **Right** to position totals at the right of the table. You can't change the position of the subtotals of a pivot table visual. If your pivot table uses a hierarchy layout, the subtotal rows are positioned at the top of the table. Tabular pivot table subtotals are displayed at the bottom of the table. ## Customize labels for totals and subtotals Customize labels You can rename the totals in table and pivot table visuals to provide better context for account readers. By default, the totals and subtotals appear without a label. **To rename totals in a table or pivot table visual** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Label**, enter a word or short phrase that you want displayed for the total. In pivot tables, you can also add labels to column totals and subtotals. To do so, enter a word or short phrase for **Label** in the **Columns** section. 1. (Optional) For tabular pivot tables, you can also add group names to subtotals. To add a group name to row subtotals, choose the **Plus (\$1)** icon next to the **Label** field to add the group name parameter that you want. You can also enter a word or short phrase to this field. You can also make changes to the text size and font color of the total and subtotal labels of your table and pivot table visuals. **To format totals and subtotals text** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Text**, do one or more of the following. + To change the color of the total or subtotal 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 total or subtotal text, open the **Font** or **Font size** dropdown and choose the font or font size that you want. + To bold, italicize, or underline the total or subtotal text, choose the appropriate icon from the style bar. In pivot tables, you can also add format text for column totals and subtotals. To do so, repeat the above steps in the **Columns** section. ## Totals and subtotals background color Background color **To customize the background color for totals and subtotals** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Background**, choose the background color icon, and then choose a color. You can choose one of the provided colors, reset the background color to the default color, or create a custom color. In pivot tables, you can also add background colors for column totals and subtotals. To do so, choose a the background color icon for **Background** in the **Columns** section. ## Totals and subtotals borders Borders **To customize the borders for totals and subtotals** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 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. In pivot tables, you can also add borders for column totals and subtotals. To do so, repeat the above steps in the **Columns** section. ## Applying totals and subtotals styling to cells Apply styling In pivot tables, you can apply any text, background color, and border styling you apply to totals to cells in that same column or row. Row subtotals appear differently depending on the layout that your pivot table uses. For tabular pivot tables, explicit subtotal headers appear on the visual. For hierarchy pivot tables, explicit subtotal headers do not appear. Instead, authors apply subtotal styling to individual fields from the **Format visual** menu. Collapsed headers cannot be styled as subtotals. **To apply totals and subtotals styling to cells** 1. In the **Properties** pane, choose **Total** or **Subtotal**. 1. For **Apply styling to**, choose the visual that you want to apply subtotal styling to. You can choose from the following options. + **None**– Removes styling options from all cells. + **Headers only**– Aplies styling options to all headers in the pivot table. + **Cells only**– Applies styling options to all cells that aren't headers in the pivot table. + **Headers and cells**– Applies styling options to all cells in the pivot table. # Row and column size in tables and pivot tables in Quick Row and column size Authors and readers can resize rows and columns in a table or pivot table visual. They can adjust both row height and column width. Authors can also set the default column width for columns in a pivot table visual. **To resize a row in a table or pivot table** + In the table or pivot table visual, hover your cursor over the line that you want to resize until you see the horizontal cursor appear. When it appears, select the line and drag it to a new height. You can adjust the row height by selecting the horizontal lines on cells and row headers. ![\[Resize a row in a table or pivot table.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/resize-table-row1.gif) **To resize a column width in a table or pivot table** + In the table or pivot table visual, hover your cursor over the line that you want to resize until you see the vertical cursor appear. When it appears, select the line and drag it to a new width. You can adjust the column width by selecting the vertical lines on cells, column headers, and row headers. ![\[Resize a column in a table or pivot table.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/resize-table-row2.gif) **To set the default column width for columns in a pivot table** 1. Select the pivot table that you want to change and open the **Format visual** menu. 1. In the **Pivot options** section, navigate to the **Value column width (pixels)** field and enter the default value that you want in pixels. # Customize pivot table data Customize pivot table data You can customize how Quick readers view pivot tables so that they are easier to read and understand at a glance. You can choose to hide a pivot table's plus and minus icons, hide columns that only have a single-metric value, and hide collapsed columns from view. These options can help Quick authors remove clutter from their pivot tables and provide an easier reader experience for Quick users. This is not the same as choosing a pivot table layout. For more information on pivot table layout options, see [Choosing a layout](create-pivot-table.md#pivot-table-layout). These options can also be accessed from the **Combined row fields menu** of a pivot table. The layout that you choose for your pivot table determines how this menu is accessed. For more information on accessing the **Combined row fields** menu, see . **To make changes to a pivot table's layout** 1. In the **Format visual pane**, choose **Pivot options**. 1. In the **Pivot options** menu, select the following options to customize the view: + **Hide \$1/– buttons** – Hide the plus and minus icons from your pivot table by default. Readers can still choose to show the plus and minus icons and expand or collapse columns and rows. + **Hide single metric** – Hide columns that only have a single metric value. + **Hide collapsed columns** – Automatically hide all collapsed columns in a pivot table. This option is only available for tabular pivot tables.