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
| Keys | Action |
|---|---|
F2 or Enter | Edit the cell |
Ctrl Arrow | Jump to the edge of the data |
Shift Arrow | Extend the selection |
Ctrl D / Ctrl R | Fill down or right |
F4 | Switch between A1 and $A$1 while typing a formula |
Alt Enter | New 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?