Tables in worksheets

<< Click to Display Table of Contents >>

Tables in worksheets

The ribbon command Insert | Table table_insert_icon allows you to create "tables" in a worksheet.

Note: The fact that this feature is named "table" may be a bit confusing, since the term "table" is often used to represent the content of a worksheet in general. However, since Microsoft has called this feature a "table" in Excel, we decided to keep this term in PlanMaker for compatibility reasons.

tables_in_tables_sample

So, how exactly does this feature work?

When you select a cell range and choose the ribbon command Insert | Table, PlanMaker will create a "table" from it.

This has the following effects on the cell range:

Automatic formatting with a "table style"

The selected cell range is reformatted automatically with a so-called table style. The default table style changes the background color of the table's rows to blue/white color. However, you can also use a different template or change the template later and thus change the formatting of the entire "table" at the touch of a button.

AutoFilter applied automatically

Apart from that, an AutoFilter is applied to the cell range that was used to create the "table". The AutoFilter adds little arrows to the right of each of the column headings in the table. When you click on one of these arrows, a menu opens, allowing you to set a filter on the cell contents of the corresponding column.

Total row

In "tables", you can easily activate a total row displayed below the table. The total row can display calculations summing up the values contained in the table (e.g. the sum of each column).

Special cell references

When you have created a "table" in a worksheet, you can make use of special types of cell references. For example, the cells in a certain table column can be addressed via its column heading – as in:
=SUM(Table3[Spring])

The following pages contain everything you need to know about the "table" feature. Topics covered:

Creating tables in worksheets

Ribbon tab "Table"

Removing tables from worksheets

Editing tables in worksheets

Formatting tables in worksheets

Using the total row of tables in worksheets

Tables in worksheets and cell references