Spreadsheets guide

Getting started with Spreadsheets

Spreadsheets is a spreadsheet in your browser, with over 300 functions. Workbooks are saved to Files on this device. Nothing is uploaded.

Open Spreadsheets

Enter data and formulas

Select several cells and the status bar shows their Count, Sum and Average. The Functions list in the sidebar has every function, with a filter box.

1. Type a name for the workbook in the box at the top.
2. Click a cell and type. Enter moves down, Tab moves right. F2 or a double-click edits a cell.
3. Start a formula with =, such as =B2+C2 or =SUM(B2:B4). The result shows in the cell and the formula shows in the bar above the grid.
4. Type a cell or range, such as B7 or A1:C9, in the name box on the left of that bar to jump there.

Format and organise

Use B and I in the toolbar for bold and italic, and the number format list for decimals, thousands, percentages, currency and dates.

The Sheets menu, the + Add sheet button and the + next to the sheet tabs add sheets. Double-click a tab to rename it. View, Freeze panes at selection keeps the top rows and left columns in place.

In the sidebar, + Chart… and + Pivot table… (also in the Insert menu) open a dialog that makes a chart (column, bar, line or pie) or a pivot table from the selected cells. From template… starts from a ready-made workbook, such as a budget or a timesheet.

Save and download

A draft is also kept in this browser after every change.

1. Click Save (Ctrl+S). The first time, choose a place in Files.
2. To get a file, open File, Download and pick XLSX, CSV (the active sheet) or the .stab file.
3. To open an Excel or ODS file, use File, Open file from this device…, or drop the file on the window.

Tip: Print and PDF, find and comments are not built yet, and sort and filter work only by asking the AI button. To sort and filter by hand, open the sheet in Spreadsheet Viewer.

Keyboard shortcuts