"Workbooks and formulas (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.

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.

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.