<< Click to Display Table of Contents >> Editing tables in worksheets

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 edit such tables:

In this case, you have the following options:

Adding another row or column

An additional row or column can be easily added to "tables in worksheets" as follows:

▪If you enter a value in a cell that is immediately to the right of the table, the table automatically expands to include the column with this value.

▪When you enter a value in a cell that is just below the table, the table automatically expands to include the row with this value.

Tip: The above two methods for expanding tables can be disabled if you do not want them. To do so, open the dialog box of the ribbon command File | Options , choose the Edit tab and disable the option Expand tables automatically.

▪When you press the Tab key in the last cell of a table (the bottom right cell), another row is added to the table automatically. This works here even if the "Total row" is enabled, as it is then automatically moved by one row.

Changing the size of a table

You can also change the size of a table at any time as follows:

▪A little arrow is displayed in the bottom right corner of a table. When you drag this arrow around with your mouse, the table is resized accordingly.

▪If you choose the command Range on the contextual ribbon tab Table, PlanMaker opens a dialog box in which you can edit the cell range covered by the table.

▪You can also use the context menu by right-clicking in the table and selecting the entry Modify table range to edit the cell range.

Inserting rows or columns

To insert a new row in a table (and only in this table), proceed as follows:

This will add a new row above or below the current row in the table.

Note: These two commands will insert the new row only into the table itself and not into the cells that surround this table.

Inserting new columns works accordingly with the commands Insert left or Insert right .

Deleting rows or columns

To delete a row from a table (and only this table), proceed as follows:

This will delete the row (including its content) from the table.

Note: This command removes the row only from the table itself and not from the cells that surround this table.

Deleting columns works accordingly with the command Delete columns .

Selecting cells in a table

Cells in a table can be selected as usual with a mouse or keyboard, of course.

The commands on the contextual ribbon Table | group Selection are available as additional options for selecting within tables. Here, you can choose from the following commands:

▪ Select rows: This selects the current table row.

▪ Select columns: This selects the current table column.

▪ Select table: This selects the entire table.

There is another command which is not available on the ribbon by default, but you can easily access it by right-clicking on the table via the context menu:

▪Select Select column data: This selects only those cells in the current column that contain data. Column headings or cells in the total row will not be included in the selection.