Skip to content

Editing Data

This page covers everything about changing the contents of cells: typing, the whole-row form, copying, and clearing.

Editing a cell

  1. Tap a cell to select it.
  2. Tap it again to start editing — a text field opens right in the cell with the keyboard.
  3. Type your value.
  4. Tap return / Done on the keyboard to commit.

The keyboard adapts to the column type — number, currency, and percentage columns bring up a number pad, for example.

Return moves you down

When you press return to finish editing a cell, the selection automatically moves to the cell below — so you can type down a column quickly without tapping each cell. (If the next row is hidden by the free-tier limit, the selection stays put.)

Direct-manipulation columns

Some column types don't open a text field — you edit them directly:

  • Checkbox — tap the box to toggle it on/off.
  • Rating — tap a star to set the rating; tap the current rating again to clear it.
  • Select — tapping opens a value picker (a list of existing values plus a field to add a new one) instead of a keyboard.

See Column Types for the full behavior of each.

Editing a whole row (the row form)

Editing cell-by-cell across a wide table means a lot of horizontal scrolling. Instead, open the row form:

  1. Start editing any cell (tap, then tap again).
  2. Tap the expand icon at the right edge of the cell being edited ("Edit whole row").
  3. A form opens showing every column of that row as a labelled field, stacked vertically — no scrolling sideways.

Inside the form:

  • Each field is labelled with its column name (the header value, or "Column A", "Column B"… if there's no header).
  • Swipe left to go to the next row; swipe right to go to the previous row. The edges of the neighbouring rows peek in so you can see where you are.
  • Or use the Previous / Next chevrons at the bottom, with a "3 of 28" position indicator.
  • Tap Done to close the form.

The form respects filters and the free-tier limit — it only pages through the same rows you can reach in the grid.

Copying cells

Long-press a cell (or a cell inside a selected range) to bring up its menu, then tap Copy:

  • If the pressed cell is inside a selected range, the whole range is copied. Columns are joined with tabs and rows with newlines, so it pastes cleanly into Excel, Numbers, Google Sheets, or any spreadsheet.
  • Otherwise just that one cell is copied.

Filtered-out rows are skipped, so a copy always matches what you see on screen.

Clearing cells

From the same long-press menu, tap Clear Contents:

  • If the pressed cell is inside a selected range, the whole range is cleared.
  • Otherwise just that cell is cleared.

Clearing empties the cells but keeps the rows and columns (unlike Delete, which removes them entirely). Filtered-out rows keep their data. Clearing is a single undoable action.

Other cell actions

The long-press menu also offers:

  • Open Link — for link columns, opens the URL in your browser.

Undo / redo

Every edit, copy-into (paste is done via the system), clear, and structural change can be reversed with Undo and re-applied with Redo from the toolbar.