Skip to content

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.


    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.


    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.

Corporate Sponsors

Sponsor saulpw on Github