Customize cell formatting in tables and pivot tables
Prerequisites
-
You have the Insights Author license.
- You have created a table or pivot table. See Use tables as visuals or Use pivot tables for instructions.
Page location
Insights > Analyses > Click an analysis > Click a table
Procedures
Row height is measured in pixels.
- Click the Format visual icon in the upper-right corner of the visual. The Properties panel opens.
- Expand Cells.
- Enter the height in the Row height (pixels) field. You can enter a whole number from 8 through 500.
Format the cell text
- Click the Format visual icon in the upper-right corner of the visual. The Properties panel opens.
- Expand Cells.
-
In the Text 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 cells doesn't automatically increase the row height. To increase the row height, see Customize the row height.
- 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 cells, click a horizontal alignment icon. You can choose left alignment, center alignment, right alignment, or automatic alignment. In pivot tables, horizontal alignment is available only for the Rows fields of a hierarchy pivot table.
- 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 cell background color
- Click the Format visual icon in the upper-right corner of the visual. The Properties panel opens.
- Expand Cells.
-
In the Background section, do one or more of the following:
- To alternate background colors between rows, select Alternate row colors. To give all cells the same background color, clear this option.
- Click the white square next to Odd rows, Even rows, or Background, and then select a color. You can choose one of the provided colors, reset the background color to the default color, or create a custom color.
Customize the cell borders
- Click the Format visual icon in the upper-right corner of the visual. The Properties panel opens.
- Expand Cells.
-
In the Borders section, do one or more of the following:
- 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.
Related topics