Skip to content Familiarize yourself
- Familiarize yourself with the interface: rows (numbered), columns (lettered), and cells (intersections of rows and columns).
- Learn R1C1 notation, which is a fancy name for how to find “the location of each cell. R stands for Row and C stands for Column. Every cell has a location on the spreadsheet. For example, the first cell is A1 becuase it is on the first column (A) and first row (1).
Basic Data Entry
- Click on a cell to select it.
- Type your data directly into the cell.
- Press Enter to move to the next row or Tab to move to the next column.
- Start with an equals sign (=) in a cell. You can also use the (+) sign.
- You can reference another cell by just typing in the R1C1 code for each cell. If you are trying to get the contents in the first cell, just type =A1 (becuase it is in Column A and Row 1)
- Enter a basic formula, e.g., =A1+B1 to add values in cells A1 and B1.
- Once you are done typing a formula, press Enter to calculate the result.
- Select the cells you want to format.
- Use the toolbar to change font, size, color, or alignment.
- Apply number formats (e.g., currency, percentage) using the number format dropdown.
Saving and Sharing
- Subset automatically saves all of your spreadsheets under your account and workspace.
- Use the share buttonto collaborate with others if needed. You can also add people to your workspace and they will automatically have access to every file you create.
