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 contains. For more information, see Editing tables in worksheets.
▪Properties: This command opens a dialog box in which you can format inserted tables and change other properties of the table. For more information, see Formatting tables in worksheets.
▪Summarize as a pivot table: Use this command to create a pivot table directly from your table data. For more information, see Pivot tables.
▪Convert to range: This converts the table back to a "normal" cell range. For more information, see Removing tables from worksheets.
▪Delete table: This completely deletes the table and all its contents. For more information, see Removing tables from worksheets.
▪Select rows, columns, table: These commands can be used to select complete rows, columns or all cells of an inserted table. For more information, see Editing tables in worksheets.
▪Insert above, below, left, right These commands can be used to insert a new row or column into a table (and only into this table). For more information, see Editing tables in worksheets.
▪Delete rows, columns: These commands can be used to delete rows or columns within a table (and only within this table). For more information, see Editing tables in worksheets.
▪Table styles (and all other commands in the "Style" group): This command can be used to apply formatting options to inserted tables. For more information, see Formatting tables in worksheets.
On the following pages, you will find detailed descriptions of the commands of the ribbon tab Table.