<< 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 allows you to create "Tables in Worksheets". Below you will learn how to edit such a table.

The following procedures can be performed:

Adding another row or column

"Tables in worksheets" can easily be extended by another row or column, as follows:

▪When you enter a value into a cell that is located directly to the right of a table, the table is extended by another column automatically.

▪When you enter a value into a cell that is located directly below a table, the table is extended by another row automatically.

Tip: The above two methods for expanding tables can be disabled in case they are not wanted. To do so, disable the option Expand tables automatically in the dialog box of the ribbon command File | Options , on the Edit tab.

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

Changing the size of a table

The size of a table can be changed in either of the following ways:

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

▪When you choose the command Range on the contextual ribbon tab Table, a dialog box opens, allowing you to 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 area to edit the cell range.

Inserting rows or columns

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

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

Note: The new row will be added only inside the table – the cells outside the table are not affected.

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

Deleting rows or columns

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

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

Note: The row will be deleted only inside the table – the cells outside the table are not affected.

Deleting columns works accordingly with the command Delete columns .

Selecting cells in a table

Cells in a table can be selected like all other cells, using either keyboard or mouse.

Apart from that, additional helpers for selecting inside tables are provided on the contextual ribbon tab Table | group Selection. The following commands are available here:

▪ Select rows: Selects the current table row.

▪ Select columns: Selects the current table column.

▪ Select table: 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: 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.