# 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="https://67932947-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHWsslZpYESUXxPccoyig%2Fuploads%2Fgit-blob-73fc732421a0c31f79b8c2e6725a82c131170e35%2FScreenshot%202023-05-13%20at%202.00.18%20AM.png?alt=media" alt=""><figcaption><p>Re-arranging columns</p></figcaption></figure>