Table customization

When working with several tables on the same sheet, you can distinguish them by applying different styles and formatting.

Changing the style of a table is only possible for the entire table.

To customize the appearance of the table, follow the steps below:

1.Open the table settings pane.

2.In the Table Style field, select one of the most recently used styles or click to view all available styles in the collection. The collection contains 60 styles and 1 additional style which is intended to reset the formatting.

3.In the Display field, enable or disable the display of the header and total.

4.In the Alternate Colors field, enable or disable alternating dark and light shades for column and row colors.

You can reset a style applied to a table in several ways:

•By selecting the style intended for formatting reset. This style is labeled with the word None in the Table Style field.

•From the style collection window by clicking Clear at the bottom of this window.

If you made a mistake in the table name when creating the table, you can rename the table as follows:

1.Open the table settings pane.

2.Edit the name in the Name field.

3.Unfocus the field by clicking anywhere else in the field or by pressing Tab.