Skip to content

Work with numbers in Grid

Formulas, formatting, charts and data tools in a Grid you edit together.

Open Grid from the app bar and choose New Grid or a template.

The templates are Budget, Invoice, Project tracker, Attendance and Sales report. You can also pick New Grid from New in Drive, or import an XLSX, CSV or TSV file. A Grid can hold several sheets, shown as tabs along the bottom.

  • Click a cell and type. Start with = for a formula, for example =SUM(B2:B20). While you type, Grid suggests functions and shows what each one needs. Click cells to put their address in the formula.
  • Everyone edits the same copy at once. Other people's selected cells are outlined in their colour with their name.
  • Drag the small square at the corner of a selection to fill a series: numbers, dates, weekdays, months, or "Item 1, Item 2".
  • Copy and paste works with other apps that have cells, and keeps values and basic formatting.
  • Use the toolbar for number formats (currency, percent, dates), fonts, colours, borders, merging and wrapping.
  • Format, Conditional formatting colours cells by their values: greater than, text contains, duplicates, top 10, or a colour scale.
  • Data has sort, filters, data validation (dropdowns, number ranges, checkboxes), remove duplicates, split text to columns, named ranges and pivot tables.
  • Insert, Chart draws a chart from the selected cells. It updates as the numbers change; drag it to move and use the corner to resize.
  • Select cells and choose Comment to discuss a number. The status bar shows the sum, average and count of what you select.

Handy shortcuts

KeysAction
F2 or EnterEdit the cell
Ctrl ArrowJump to the edge of the data
Shift ArrowExtend the selection
Ctrl D / Ctrl RFill down or right
F4Switch between A1 and $A$1 while typing a formula
Alt EnterNew line inside a cell
File, Download saves the Grid as an XLSX file, the current sheet as a CSV or TSV file, or a PDF of the selected cells, saved straight away. Print opens your browser's print window.
Was this helpful?

All guides

Getting started

Mail

Security & privacy

Encryption

Pinglar and calls

Calendar & tasks

Notes & People

Drive and office apps

Business

Account

Troubleshooting