Work with numbers in Sheets

Create a spreadsheet from New, Sheet in Drive, from a template (Budget, Invoice, Project tracker, Attendance, Sales report), or by importing a .xlsx, .csv or .tsv file.

• Click a cell and type. Start with = for a formula, for example =SUM(B2:B20). While you type, Sheets 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 spreadsheet apps 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