Formula Microscope and a bigger grid

Inspect the steps behind a formula. Click ƒx to see intermediate results, follow references or jump to the cell contributing to an error. Formula Microscope.

Make room for a larger sheet. Drag the grip at the lower right, or use Expand Window and Restore Compact Window from the command palette.

Drag ranges into a formula. Adjacent cells stay available while you type a long formula. Try typing =SUM( and dragging over the cells to add. Grid and shortcuts.