Create a table

Create a table

What is a table?

Table allows you to organize, analyze and format data swiftly. You can sort, filter, and summarize information to gain insights and maintain layout.

How to create a table

To create a table:
  1. Go to Insert > Table .
  2. Select the range you wish to convert into a table.
  3. Select Contains Header if your table has a header row.
  4. Click Ok.
Notes
Once the table is created, the table name will be added to defined names and cannot be edited in the Define Name dialog.
Also, whenever you scroll down the table, the table's row headers will get detected automatically and will appear in the respective column header of the worksheet, eliminating the need to freeze the row headers.

How to delete a table

To delete a table:
  1. Right-click on the table you wish to delete.
  2. Select Table > Delete Table and Keep Formats from the contextual menu.
  3. Alternatively, select the Table icon from the side pane and click Delete Table and Keep Formats or Delete Table and Formats.
Notes
Choosing Remove Table and Keep Formats will convert the table style to standard cell range, and the associated defined name will get deleted. However, the appearance of the range will still be in a table style and the cell formats applied to it will remain intact. Choosing Remove Table and Formats will convert the table style to standard cell range, and the entire table, along with formats, will get deleted.

How to change the table style

To change the table style:
  1. Select the table and click the Table icon from the side pane.
  2. Pick a table style and color from the available options.
  3. Right-click on any of the table styles for table style actions.
    1. Apply and Clear Formatting - Apply the selected table style and clear existing formats, if any.
    2. Apply and Maintain Formatting - Apply the selected table style and keep the existing formats intact.
    3. Set as Default - Set the selected table style as the default one. Whenever a new table is created, the default table style will be applied.     
  4. You can also enable/disable Header Row, First Column, Total Row, Last Column, Banded Rows, and Banded Columns from the side pane. 


Edit the source range of a table  

To edit the source of a table:
  1. Select the table and click the Table icon from the side pane.
  2. Click on the Select Range icon in the range field.
  3. Select the new range for the existing table.
Notes
The header of the new table must remain in the same row of the existing table, and the new table must overlap the existing table.
 

How to rename a table

To rename a table:
  1. Select the table you wish to rename.
  2. Click the Table icon from the side pane.
  3. Click the name field in the side pane and enter a new name for the table.
Notes
The new table name will get automatically updated in the defined name.