Sheet Mode

How to Fill Multiple Cells with the Same Value (Drag-Fill)

Category
Sheet Mode
Updated
23 Sep 2026
Reading time
1 min

Pro This feature is part of CataLord Pro, and it is included in the 14-day free trial.

Drag-fill copies one value down (or up) a column in a single gesture, just like in Excel. It is the fastest way to set the same value on many products.

Prefer reading? The steps follow.

Filling cells with drag-fill

  1. Click the cell that holds the value you want to repeat.
  2. Grab the small square handle at the bottom-right corner of the cell.
  3. Drag across the rows you want to fill; target cells highlight in blue.
  4. Release the mouse. Every highlighted cell now holds the same value.

This works for every cell type: prices, categories, tags, images, dropdowns, and the rest.

Tip: Filled the wrong range? Press Ctrl+Z to undo. Nothing is written to your store until you save.

Try it on your own catalog

The free plugin covers the single-screen editor, the variant builder and AI descriptions. No card, no account.