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:
•Header row
•Data area
•Total row
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 customize the order of sorting and filtering of values in columns using automatically created filters in column headers.
•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.