<< Click to Display Table of Contents >> Tables in worksheets |
The ribbon command Insert | Table 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.
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
▪Removing tables from worksheets
▪Formatting tables in worksheets