Customize table styles (Beta)

🚩

This is a public beta feature that’s subject to quick, iterative changes. As a result, the latest product version may differ from the contents of this document.

Table styles make it easy to format and display your tabular data efficiently and effectively. Sigma provides style presets for out-of-the-box aesthetics and readability, and you can customize all style components independently for more personalized table designs.

This document describes Sigma’s table style options and explains how to customize them for any table, pivot table, or input table element.

User requirements

The ability to customize table styles requires the following:

  • You must be assigned an account type with the Explore workbooks or Create, edit, and publish workbooks permission enabled.
  • You must be the workbook owner or be granted Can explore or Can edit workbook permission.

Table style presets

Sigma features two table style presets that automatically configure all style options. Use a preset as a one-click style solution or as the starting point for a custom design.

Spreadsheet

The Spreadsheet preset (default) is designed for ongoing analysis and collaboration. It’s ideal for ensuring readability and including additional context, like tooltips and images.

Presentation

The Presentation preset is designed for table viewing. It’s ideal for aligning with company branding and adding visual appeal to your workbook.

Customizable style options

Customize any table style component to meet all branding and aesthetic needs with table, pivot table, and input table elements. For more pivot table options, see Additional pivot table style options.

Header format

The Header format setting allows you to customize components of the table header cells, including font type, size, weight, and color, as well as text wrap, text alignment, background color, and divider color.

Cell format

The Cell format setting allows you to customize components of the table data cells, including font type, size, weight, and color, as well as text wrap, text alignment, and background color.

Cell spacing

The Cell spacing setting allows you to adjust the padding around text within table cells. You can select one of four options: Extra small, Small, Medium, and Large.

Extra small Small
Medium Large

Grid lines

The Grid lines setting allows you to control cell borders. You can select one of four options: No grid, Vertical grid, Horizontal grid, and All grid.

No grid Vertical grid
Horizontal grid All grid

Banding

The Show banding setting allows you to alternate the background color of the data rows.

DisabledEnabled

Additional pivot table style options

Row header

The Row header format setting allows you to customize components of the row header cells, including font type, size, weight, and color, as well as text wrap, text alignment, and background color.

Column header

The Column header format setting allows you to customize components of the column header cells, including font type, size, weight, and color, as well as text wrap, text alignment, and background color.

Subtotals

The Subtotals setting allows you to customize the font weight, font color, and background color of the subtotal column.

Grand totals

The Grand totals setting allows you to customize the font weight, font color, and background color of the grand totals row.

Position

The Position setting allows you to move the totals to the first or last column and row.

FirstLast

Customize table style

  1. Open a workbook in Explore or Edit mode.

  2. Select the table, pivot table, or input table element you want to modify.

  3. Select Element format in the side navigation, then click the Table style header to expand the section. When modifying a pivot table, click the Totals header to access styling options for subtotals and grand totals.

  4. Select a table style preset, or customize the table style components as needed.