Multi-cell Editing


Work on several cells at once: fill a selected range with one value, copy and paste, or clear a whole block.

▶ Tutorial: multi-cell

Multi-select → type → paste → commit

Select a range

Multi-select and bulk assignment

Values filled into a multi-selection in bulk

The status bar shows the selection count, the number of distinct values, and the content length in real time, for example Selected: 7, Distinct: 7, and Length: 7, so you can check the range before committing.

Type to fill

With multiple cells selected, type the new value directly on the keyboard to overwrite the whole selection; there is no need to edit cell by cell or double-click into edit mode first.

  1. Drag out a rectangular selection, or hold Cmd / Ctrl and click non-adjacent cells;
  2. Type the new value;
  3. Press Enter to confirm; every cell in the selection becomes the same value;
  4. Click Apply to commit, or Revert to discard.

Copy cells

Select cells and press Cmd+C (win: Ctrl+C) to copy:

  • With a single cell selected, the copy is plain text.
  • With multiple rows and columns selected, the content is written as table text separated by tabs, so it splits into columns automatically when pasted into Excel/Sheets.
  • If a single cell exceeds the size limit (measured in MB by default), it is not copied and Cell … is too long is shown.

Paste into cells

Press Cmd+V (win: Ctrl+V) to paste:

Selected rangePaste behavior
One cellThe whole text is written into that cell as-is (not split)
Multiple cellsSplit by tabs/newlines and filled into each cell in order
Multiple cells + clipboard holds 1 valueThat value fills the entire selection
Multiple cells + clipboard holds fewer values than cellsClipboard values are reused cyclically to keep filling

The last row is the key to bulk filling: copy a few values, select a large range, and paste, and the selection repeats those values in order. Multi-row, multi-column content copied from Excel also pastes directly, with rows and columns mapping across.

Set NULL for a range

Select multiple cells and press Backspace to set the whole selection to NULL; to use an empty string instead, use Set Empty from the right-click menu.

Before you apply

Three things are worth checking before committing:

  1. The Selected count in the status bar matches the range you meant to change, so you do not touch adjacent rows by accident;
  2. The table has a primary key, so the WHERE in OUTPUT can target a single row precisely;
  3. Changes exist only in the current result set; commit before switching tables or refreshing, otherwise uncommitted edits are lost.