As described in the introduction of the section Tables in worksheets, the ribbon command Insert | Table enables you to create "tables in worksheets". Here, you will learn how to format such tables and change other properties of the 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 purpose.
There is also 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 properties. |
| 3. | A dialog box appears with the options described below. Make the desired changes and then confirm with OK. |
In this dialog box, you can make the following settings:
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 list. Here, you can apply a different table style to the table.
Applying a different table style changes the entire appearance of a table. First and foremost, this concerns the coloring of the table (via shades). The small thumbnails in the list show which colors are included in each style.
Showing/hiding header row and total row
Tip: You can also apply these options directly using 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 AutoFilter that is applied automatically to each table. To filter data, click on one of these little arrows. The program opens a menu in which you can set different types of filters for the values in the corresponding column. |
| For more information on using AutoFilters, see AutoFilter. |
▪Total row
| This option enables/disables the total row (displayed below the table). The total row displays calculations that sum up the values contained in the table columns. |
| By default, only the sum of the values in the last column is displayed. If, however, you click on one of the cells in the total row, a small arrow will appear to the right of it. Clicking on this arrow opens a menu in which you can choose what kind of calculation the cell should perform. For example, you can display the sum, average, or other calculations for any columns in the table. |
| 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 directly using 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 colored shading for the rows or columns of the table. 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 also change the background color – this depends on the respective table style. |
Extended properties on the "Properties" tab
On the Properties tab of the same dialog box, you will find the following advanced properties for the table:
▪Name
| Here, you can change the name of the table, which was automatically generated when the table was created and also included in the list of named ranges at the same time. The name can also be changed there. For more information, see Naming cell ranges. |
| 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 to 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 with other programs, only use letters, numbers, and underscores.) |
| 4. Table names must not be structured like cell references (for example, A1). |
▪Title and Description
| Here, you can enter a title for the table and a short description for its contents. |
| This is useful for people who, due to impaired vision, use special tools such as a screen reader to have the individual components of the worksheet read to them. |