Ribbon tab "Table"

<< Click to Display Table of Contents >>

Ribbon tab "Table"

As soon as you have created a "table in worksheets" using the ribbon command Insert | Table you can switch to the contextual ribbon tab Table for editing.

This ribbon tab always appears automatically when you place the cursor in the created table.

ribbon_tab_table

The contextual ribbon tab "Table"

The ribbon tab has the following buttons, from left to right:

Range: Here, you can change the cell range that the table includes. See Editing tables in worksheets

Properties: This command opens a dialog box, where you can format inserted tables and change other properties of the table. See Formatting tables in worksheets

Summarize as a pivot table: Create a pivot table directly from your table data. See Pivot tables

Convert to range: Convert the table back to a "normal" cell range. See Removing tables from worksheets

Delete table: Delete the table and all its contents completely. See Removing tables from worksheets

Select rows, columns, table: Select complete rows, columns or all cells of an inserted table. See Editing tables in worksheets

Insert above, below, left, right Insert a new row or column inside a table (and only inside this table). See Editing tables in worksheets

Delete rows, columns: Delete rows or columns inside a table (and only inside this table). See Editing tables in worksheets

Table styles (and all other commands in the "Style" group): Apply formatting options to inserted tables. See Formatting tables in worksheets

On the following pages you will find detailed descriptions of the commands of the ribbon tab Table.