Sheets
Spreadsheet basics
The grid, moving around it with the keyboard, selecting, formatting cells, and working in more than one tab.
Open Sheets from the app launcher and press New spreadsheet. The grid never runs out: keep scrolling down or to the right, or keep pressing an arrow key, and more rows and columns appear, the way they do in Excel. Only the part you actually use is saved, so an empty row costs nothing. It saves continuously, the same way documents do, and the chip in the top right says whether it is Saved, Saving, Reconnecting or has hit a Save issue.
On the Sheets home, the ... button on a spreadsheet's card (or a right-click on the card) has Rename, Duplicate and Delete. Duplicate copies every tab, named after the original with "copy" at the end.
Moving around#
The grid takes the keyboard seriously, because that is the whole speed of a spreadsheet. Start typing on a selected cell and it begins editing with what you typed.
Select more than one cell and a small readout appears beside the formula bar with Sum, Avg, Min, Max and Count for the selection, plus the range you have selected written as A1:C10. Click a column letter or a row number to select the whole column or row; hold shift, or drag across the letters, to take several. Drag the small square at the bottom right corner of a selection to fill it down or across; formulas move their references with them as they go, and a reference written with a dollar sign, such as $B$2, stays put.
Right-click a cell, or a column letter or row number, for Cut, Copy, Paste, Format cells, Insert image and Clear. A range you copy inside Nemi pastes with its formatting, and its formulas move their references to where they land; pasted into another Nemi spreadsheet it keeps its formulas too. Pasted anywhere else (an email, Excel, Google Sheets) it arrives as the values the cells show, not the formulas behind them. Copy one cell, select a larger range and paste, and the whole range is filled with it.
Column and row size#
- Drag the edge of a column header or a row number to resize it. Double-click that same edge to put it back to the default.
- The label next to the spreadsheet name says where your data is, for example Data in A1:F120.
Formatting cells#
The formatting bar under the spreadsheet name holds undo and redo, bold, italic, underline and strikethrough, the text and fill colours, alignment, wrap, Insert image and Clear. Each one is a single press and applies to everything you have selected, not just the active cell. On a phone the formatting sits in a bar at the bottom of the screen instead: press Format cells there. A right-click on a cell offers Format cells too, with the same options in one panel.
Format cells
Bold, italic and underline also have the usual shortcuts, ⌘B, ⌘I and ⌘U, and work on a whole selection at once. A cell holding a bare web address becomes a link you can open with ⌘ and a click.
Tabs#
One spreadsheet can hold several tabs, listed in the sidebar. Add one with the plus, and right-click a tab to rename, duplicate, move up or down, or delete it; a double-click renames it straight away. Duplicating a tab copies its cells, its column widths, its row heights and its pictures. A workbook always keeps at least one tab.
- Two tabs cannot have the same name, and capitals do not make a name different: next to a tab called Orders you cannot make one called orders. Nemi says Another tab is already called that. when you try.
- Renaming a tab also rewrites every formula that points at it, so a total that reads
=SUM(Orders!B2:B40)goes on working after Orders becomes Sales. One ⌘Z takes the new name and the rewritten formulas back together. - When you reload a spreadsheet, or come back to it in the same browser tab, it opens on the tab you were looking at. The address of the page names that tab too, so a link you copy opens on it.
A tab can also be filled from another Nemi app, so your form responses, your files or your photos arrive as ordinary rows: see Connecting a tab to app data.
How many spreadsheets you can have#
| Plan | Docs, sheets, canvases and forms | Version history |
|---|---|---|
| Free | 100 | 7 days |
| Starter | 500 | 30 days |
| Creator | 2,000 | 90 days |
| Pro | 10,000 | 365 days |
| Max | Unlimited | Unlimited |
| Business | Unlimited | Unlimited |
One shared ceiling across the four apps, and it is an anti-abuse cap rather than an upsell. Full comparison in Plans.
Can several people be in one sheet?
Yes. Everybody in the workspace can open and edit it, you see each other's avatars while you work, and authorship is recorded per cell. It behaves exactly like writing together in Docs.
Is there an undo across the whole sheet?
⌘Z undoes your own last change, including a big paste or an import. It is per person: it will not undo what a collaborator did.
How big can a sheet get?
Large imports work, and the grid only draws the rows you are looking at so it stays responsive. If a sheet has become slow, the usual cause is thousands of formulas recalculating rather than the number of rows.
Related
Still stuck? Email support@nemilab.com and tell us what you were trying to do.