> For the complete documentation index, see [llms.txt](https://docs.rowsncolumns.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rowsncolumns.app/configuration/features/structured-references/schema-based-tables-and-columns.md).

# Schema based tables and columns

Tables in Spreadsheet 2 gives you the same amount of control that you get in Excel/Google sheets. Users can add dynamic columns, calculated columns with a formula, create columns from another table etc.

## Column order

Column orders can be easily changed by selecting a column from the column header and moving them left or right.

All formulas and references are automatically updated.

<figure><img src="/files/aCU7nJr8NzdCBHM36QwY" alt=""><figcaption><p>Re-arranging columns</p></figcaption></figure>