Tables

Tables are a range of cells that constitute a single object with its own name, internal structure (areas) and formatting style.

Tables have a unique name within the document (by default, Table1, Table2, and so forth) and consist of the following areas:

The table name, column and area names are used in structured references.

When working with a table, you can perform the following operations:

Edit column names. Column names are automatically updated in the structured references of the table. If the name you enter already exists in the table, a sequence number will be automatically added to it, for example, the name “Date” will become “Date1”.
Insert rows and columns between the existing rows and columns (but not at the end of the table).
Copy tables within one document or from document to document, provided that both documents are open in MySpreadsheet. The copied table is automatically assigned a unique name. In all structured references, the name of the original table is automatically replaced with the name of the copied table.
Quickly configure column sorting and filtering using automatically generated sort and filter buttons in column headers. You cannot sort rows in tables.
Customize the table: Choose a design style from those available in the collection, include or exclude table areas.
Expand the range of the table by adding new data to adjacent cells.
Select the type of calculation in the total row.
Convert a table to a regular range of data.