To create a spreadsheet use shortcut c + b.
Creating and importing
Press c + b, choose Spreadsheet from the Create menu, or choose New → Spreadsheet in Drive. Uploaded.xlsx, .xlsm, and .csv files open in a read-only preview with Import notes. Edit in Macro creates an editable copy. The original file is unchanged.
Import and export → Import… in the bottom-right corner imports a file into an open spreadsheet as new sheets or as a replacement.
Imports keep formulas, formatting, conditional formatting, dropdowns, notes, charts, images, and shapes. Macros in .xlsm files are removed.
Editing
Type in a selected cell or double-click it to edit. Formulas start with=. Function suggestions and arguments appear while typing a formula. Click or drag across cells to insert a reference.
The toolbar has number formats, fonts, colors, borders, alignment, wrapping, and find and replace (cmd+f).
Drag the fill handle to fill a series. cmd+d fills down. cmd+r fills right.
Format and data includes:
- Dropdown…
- Sort
- Trim whitespace
- Goal Seek…
@ in a cell to mention people, documents, channels, emails, or dates.
Charts and images
Insert chart or image adds a chart from the selected cells. Chart types: column, bar, line, area, pie, doughnut, scatter, combo, radar, bubble, stock, and contour. Charts update when their data changes. Double-click a chart to edit it.Sheets
Click + to add a sheet. Double-click a tab to rename it. Drag tabs to reorder. Right-click a tab to duplicate, move, or delete it. Formulas can reference other sheets, for example='Launch budget'!B9.