Creating sheets, rows and columns

How to set up a sheet for data collection

1. Type Shift+A to open a new blank sheet with one column.

2. Press

   a. a to add one blank row.

   or

   b. ga followed by a number to add that many blank rows.

How to add a new blank column

1. Press

   a. za to add one blank column.

   or

   b. gza followed by a number to add that many blank columns.

2. Press ^ to edit the column name.

How to fill a column with a range of numbers

1. Press gs to select all rows (or use other commands to select a subset of rows to fill).
2. Move the cursor to the column to be filled.
3. Press gi.

How to edit a cell

1. Press e to edit an individual cell.
2. Type in the new value.
3. Press Enter to accept the value.

How to move the cursor to the next cell after a successful edit

1. Press Shift+Arrow to accept the current value and move the cursor into edit mode in the next cell.