---
title: "\"Workbooks and formulas (2026-11-12)\" (2026-11-12)"
description: "Move rows and columns, calculate across sheets, and open separate workbooks."
canonical_url: https://scratch.itsryan.me/changelog/2026-11-12-workbooks-and-formulas
---

# "Workbooks and formulas (2026-11-12)" (2026-11-12)

**Move, hide and resize at the grid edge.** Option-drag a row or column header to move it. Right-click a header to hide it. Drag the bottom of a row header to set its height. [Grid controls](https://scratch.itsryan.me/docs/grid.md#move-hide-or-resize-rows-and-columns).

**Use formulas across sheets.** Reference a cell or range on another sheet, calculate with saved named ranges, or use XLOOKUP to find a matching value. There are new date and text functions too. [Work across sheets](https://scratch.itsryan.me/docs/grid.md#work-across-sheets).

**Keep separate workbooks and move data between apps.** Open a local workbook, archive a sheet, or exchange TSV and Excel values. Each sheet now fits 2,000 rows and 96 columns. [Workbooks and file formats](https://scratch.itsryan.me/docs/grid.md#workbooks-and-sheet-archive).