Drag results and expand formulas

Drag Sum or Avg from the footer into an empty cell. Scratch previews the formula before you drop it. Hold Option to insert the current value. The command palette can place either result by address. Grid guide.

Drag between the grid and Notes. Option-drag a selected range into Notes for a live table. Add Shift for a chart or Command for a link. Option-drag selected note text to the grid to annotate a cell or range. Notes guide.

Expand the formula bar with ⌥⌘E or the chevron. Long expressions wrap. Underlined references match their grid outlines, and the current argument and matching parentheses highlight as you move the caret. Collapse the bar to keep editing at the same position. Formula editing.