Cell References

Formulas can reference cells like a spreadsheet:

• Single cell: A1
• Range: E3:E4
• Whole column: B:B

References are 1-based (row 1 is the first data row).

Click-to-Insert References

When your cursor is in a place where a reference is valid (for example right after = or ( or ,), you can click a cell in the grid to insert its reference into the formula text.

• Click a cell to insert a single reference (e.g., E3)
• Shift+click a second cell to convert the last inserted reference into a range (e.g., E3:E4)

Tip

This works both when editing in the formula bar and when editing a formula directly inside a cell (inline).