Sheets

Work with cells#

• Type values and formulas; Insert a function lists the functions you can use. Edit formula opens the current cell’s formula.
• Sum the column above and Average the column above add a total under a column of values.
• Insert row above, Insert column left, Delete row, Delete column, and a fill colour for cells.
• Add sheet, Rename this sheet and Delete this sheet manage the tabs at the bottom.

Review#

Comment on this cell, track changes with Accept and Reject, and see who filled in each cell. Cells filled before the sheet started recording authors show as Unattributed.

Linked cells#

A cell can hold a live field — a value from a record, such as a deal’s amount — and update when the record changes. Unlink this cell from its record keeps the current value as plain text. See Live fields.

Import and export#