All updates
ImprovedEditor5 Nov 2026

Easier spreadsheet formulas

Spreadsheet formulas now close their own brackets, explain each function as you type and tell you what an error means.

Typing =sum(E2:E9 into a Total cell, with a hint explaining SUM and the range outlined on the sheet, then pressing Enter to close the bracket and show the total

What’s changed

Writing a formula in a spreadsheet block now works more like Google Sheets.

Less to type

Press Enter without typing the last bracket and the sheet adds it for you. After an opening bracket or an operator, press an arrow key to point at a cell instead of typing its name.

Help as you type

Function suggestions now say what each function does. Inside the brackets, a hint shows the arguments and explains the one you're on. Press F1 to hide it if it's in your way.

Typing =ro into the Total cell shows ROUND and ROUNDBANK with what each does, then a hint for ROUND explains the argument being typed
Suggestions say what each function does, and the hint follows your caret.

Cell references in your formula match the colours on the sheet, and the bracket next to your caret is highlighted with its partner.

Lock a reference with F4

Put your caret on a reference and press F4 to switch between A1, $A$1, A$1 and $A1.

Typing = in the Total cell, pressing the up arrow to point at E9, then pressing F4 to cycle through $E$9, E$9 and $E9
Point at a cell with an arrow key, then press F4 to lock it.

Errors that explain themselves

Cells with a formula error now have a small red triangle. Hover over the cell to see what went wrong. Where the sheet can work out the cause, it names it, such as the empty cell you're dividing by or a function with the wrong number of arguments.

Entering =E9/C10 in the Total cell shows #DIV/0! with a red triangle, and hovering explains that C10 is empty so the formula is dividing by zero
Hover over a cell with a red triangle to see what went wrong.

Read using formulas in spreadsheet blocks for more detail.

More updates