Creating tables in worksheets

<< Click to Display Table of Contents >>

Creating tables in worksheets

FreeOffice: Creating tables in worksheets is not included in SoftMaker FreeOffice.

As described in the introduction of the section Tables in worksheets, the ribbon command Insert | Table enables you to have "tables in worksheets". Here, you will learn how to create such a table:

To create a "table in a worksheet", proceed as follows:

1.Optional: In a range of adjacent cells, enter the data from which you want to create a table.

Tip: It is useful if you have provided this cell range with a column heading in the first row of each column. (If there are no column headings, PlanMaker will generate automatic headings named Column1, Column2, etc.)

2.Select the cell range (including the column headings).
3.Choose the ribbon command Insert | Table table_insert_icon by clicking directly on the icon itself.
Tip: If you click on the icon's arrow rather than directly on the icon itself, PlanMaker will open a list of predefined styles which can be applied directly.
4.The program displays a dialog box with the following options:
Source range: This is the cell range from which the table is to be created. The currently selected range is suggested by default. As a rule, you only have to confirm this default range.
Source range contains titles: Here, you can specify whether the first row of the source range consists of column headings, as recommended above. When you disable this option, PlanMaker will generate automatic column headings named Column1, Column2, etc., and indents these headings with an additional row above the source range.

As soon as you confirm your selection in the dialog box, a "table" is created for the source range. More specifically, the following happens:

No changes are made to the table cells and their contents

The cells in the source range remain normal table cells even after a table has been created. Thus, you can still edit them, format them, etc.

Automatic formatting with a "table style"

However, it is immediately noticeable that the cells in the source range have been automatically reformatted: By default, the first row (containing the column headings) is shaded in a medium blue, the rows below are shaded alternately in light blue and white (unless you have selected a different style). For more information, see tip from step 3.
This automatic formatting is performed via a table style. Whenever you create a table, it is automatically reformatted with the default table style. Alternatively, numerous other table styles with different colors and styles are available. On the contextual ribbon tab Table, you can switch to another style at any time using the commands Table styles or Properties.

AutoFilter applied automatically

There is a small arrow filter_arrow to the right of each column heading in the first table row. These arrows indicate the presence of an AutoFilter that has been automatically applied to the source range of your table.
By default, the filter is disabled and all data in the table is displayed. If you click on one of the arrows, the menu of the AutoFilter opens for the corresponding column. In this menu, you can apply different types of filters or even sort the table data.
For more information on AutoFilters, see AutoFilter.