<< 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.
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.