Format tables

As with grids, formatting for tables is defined on the XLCubedFormats worksheet.

Tables automatically pick up the default formatting for the column headers and data area.

In addition, you can also define formats that'll only apply to specific sections of the table.

You can format specific columns easily by right-clicking the table and selecting "Format Column" or "Format Column Title" from the menu. This will show the formatting dialog and automatically create the relevant rows in the format sheet.

This can also be done manually on the format sheet. To do this, type the word Column as the column name, and then the name of the column.

You can then format the header and data areas. The example below makes the SalesTerritoryKey header bold and uses italic formatting for the data.

You can highlight specific values in a table by entering the column name and value and setting the data cell format. The example below highlights December in red and makes months starting with A bold.