Creating sheets, rows and columns
How to set up a sheet for data collection
Shift+Ato open a new blank sheet with one column.
ato add one blank row.
gafollowed by a number to add that many blank rows.
How to add a new blank column
zato add one blank column.
gzafollowed by a number to add that many blank columns.
^to edit the column name.
How to fill a column with a range of numbers
gsto select all rows (or use other commands to select a subset of rows to fill).
- Move the cursor to the column to be filled.
How to edit a cell
eto edit an individual cell.
- Type in the new value.
Enterto accept the value.
How to move the cursor to the next cell after a successful edit
Shift+Arrowto accept the current value and move the cursor into edit mode in the next cell.