Customize table style (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 table style options and explains how to customize the table style for an entire workbook or for an individual table, pivot table, or input table element. For information about customizing the default table style in an organization-wide workbook theme, see Create and manage workbook themes.
User requirements
The ability to customize table styles requires the following:
-
You must be assigned an account type with the Full explore 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 presets that automatically configure all table style options. You can 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 table style options
Customize any of the following table style components to meet branding and aesthetic requirements with table, pivot table, and input table elements:
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.
| Disabled | Enabled |
|---|---|
 |  |
Header format
The Header tab contains settings and tools that allow you to format table headers. Customizations include font type, size, weight, and color, as well as text wrap, text alignment, background color, and divider color.
Subheader format (pivot tables only)
The Subheader tab contains settings and tools that allow you to format subheader rows and columns. Customizations include font type, size, weight, and color, as well as text wrap, text alignment, and background color.
Cell format
The Cell tab contains settings and tools that allow you to format data cells. Customizations including font type, size, weight, and color, as well as text wrap, text alignment, and background color.
By default, cell styles apply to both value and total cells in pivot tables. To apply different styles to pivot table total cells, see Format pivot table totals.
Customize the default table style for a workbook
Updates to a workbook's default table style are applied to all new and existing table, pivot table, and input table elements. However, custom table styles applied to individual elements (new and existing) always override the default.
-
Open a workbook in Explore or Edit mode.
-
Select
Workbook settings in the side navigation, then click the Table style header to expand the section.
-
Select a table style preset, or customize the table style components as needed.
Customize the table style for an individual element
Apply a custom table style to an individual table, pivot table, or input table element.
-
Open a workbook in Explore or Edit mode.
-
Select the table, pivot table, or input table element you want to modify.
-
Select
Element format in the side navigation, then click the Table style header to expand the section.
-
Select a table style preset, or customize the table style components as needed.
Updated about 1 month ago