← All articles

Grid, Board & Gallery — Select a range, copy, paste, and fill

The cursor stretches into a rectangle: hold Shift with the arrow keys, Shift-click another cell, or press and drag across cells. Ctrl+A selects the whole page; Esc collapses back to one cell. Ctrl+C copies the rectangle in a format Excel and Sheets understand, and Ctrl+V pastes a block straight from them — a whole column of statuses, a grid of numbers — starting at the selection's top-left corner. Pasting one value onto a selected range fills the range. Delete clears every editable cell in the selection, Ctrl+D fills the selection down from its top row, and the small square at the selection's corner is a fill handle — drag it down to repeat the selected values over the rows below, alternating pattern and all. Every one of these lands as a single undoable step, and the toast offers Undo on the spot. Cells you can't write — computed fields, sealed records, fields that are read-only for your role — are skipped and counted, never mangled.
Nothing here answered it? Ask us directly — we usually reply within one working day.

Made with RowFold