As described in the introduction of the section Tables in worksheets, the ribbon command Insert | Table allows you to create "Tables in Worksheets". Below you will learn how to change the formatting and other properties of such a table.
First of all, the cells in a table can be formatted just like any other cell, using the entire palette of commands and options that PlanMaker provides for this.
In addition, there is the ribbon command Table | Properties especially for tables. This provides formatting options that are only applicable to tables.
You can use this command as follows:
| 1. | Move the cell frame to any cell within the table that you want to format. |
| 2. | Choose the command Properties  on the contextual ribbon tab Table. |
| Alternatively: Right-click on the table to open the context menu and select the entry Table settings |
| 3. | A dialog box with the options described below opens. Make the desired changes and confirm with OK. |
The following settings can be made in this dialog box:
Applying a different table style
Tip: You can also apply this option directly via the Table styles 
icon on the ribbon tab Table | group Style.
The first tab of the dialog box contains the Style listbox. Here, you can choose a table style for the table.
Applying a different table style changes the entire appearance of a table. Primarily, table styles modify the background colors of the table's rows and columns. The little preview images shown in the list give you an impression which colors each of the styles will apply.
Showing/hiding header row and total row
Tip: You can also apply these options using directly the commands on the ribbon tab Table | group Style.
Below the Style list, there are more options for customizing the appearance of a table. The first two options have the following function:
▪Header row
| This option enables/disables the header row (displayed above the table). The header row displays a column title for each of the columns. |
| In the header row, you can also see a small arrow displayed to the right of each of the column titles. These arrows indicate the presence of the AutoFilter that is applied automatically to each table. To filter data, click on one of these little arrows. A menu opens, allowing you to choose from different kinds of filters for the values in the corresponding column. |
| For more information on AutoFilters, see AutoFilter. |
▪Total row
| This option enables/disable the total row (displayed below the table). The total row displays calculations summing up the values contained in the table columns. |
| By default, the total row calculates just the sum of the values in the rightmost column of the table. However, when you click on one of the cells in the total row, a little arrow appears to its right. This arrow opens a menu where you can choose which kind of calculation the cell should perform. This allows you to calculate the sum, average and other calculations for any given table column. |
| For more information, see Using the total row of tables in worksheets. |
Additional formatting options for table styles
Tip: You can also apply these options using directly the commands on the ribbon tab Table | group Style.
The other options on the Style tab have the following purpose:
▪Banded rows and Banded columns
| This option enables/disables alternating background colors for the table's rows and columns. Their color is defined in the table style, which you can also set in this dialog box (as described above). |
▪First column and Last column
| If you enable this option, the first and/or the last column in the table will be highlighted. |
| For most table styles, this is done by using boldface for the text in the respective column. However, some table styles additionally change the background color – this depends on the table style definition. |
Extended properties on the "Properties" tab
The Properties tab in the dialog box contains extended properties for tables, as follows:
▪Name
| Here you can change the name of the table. |
| The name of a table can be used in cell references (see Tables in worksheets and cell references). |
| Please note that the following rules apply for table names: |
| 1. Table names must be unique. |
| 2. Table names must always begin with a letter or an underscore. |
| 3. Table names must not contain blank spaces or other invalid characters. (For maximum compatibility, it is recommended to use solely letters, numbers and underscores.) |
| 4. Table names must not be structured like cell references (e.g. A1). |
▪Title and Description
| Here you can specify a title and a short description for the table. |
| This makes it easier to process your worksheet for people who are blind or have low vision and therefore use tools like a screen reader. |