Resourced's tables share one set of spreadsheet mechanics: select a range of cells, edit or clear them together, copy blocks to and from Excel, and step back through changes with undo. This article covers those mechanics once.

The same mechanics work in the products table on the start page, the SKU and pricing tables on an article's detail page, the BOM connection table on a product, and the admin tables — VAT, markup and margin targets, currencies and exchange rates, mode of transport, tariff codes, permissions, seasons, user configuration and lookup tables.

Click a cell to select it. Drag across cells, or hold Shift and click a second cell, to select a block. The arrow keys move the selection around the table, and Ctrl/⌘ + A selects the whole table — in the products table that means every article matching the current filter, including rows that haven't loaded yet.

Bulk actions work off this selection: in the products table, Edit, Export BOM and Delete act on the rows your selected cells touch, and row deletion in the admin tables works the same way.

Click a selected cell, or press Enter on it, to open its editor. The change fills every selected cell in that column, so a value can be set down a whole size run — or a whole filtered range — in one go.

When the selected cells hold different values, the editor shows the range behind the field (4 - 9 above). Leaving the field empty keeps the existing values instead of clearing them. To actually empty cells, select them and press Delete — columns that cannot be empty are skipped, so a value like a season name is never cleared along with the rest.

Tab and Shift + Tab move from one cell's editor to the next, Ctrl + Enter commits and moves on, and Space flips a switch in an open cell — a whole row or column can be typed through without reaching for the mouse.

Copy a selected block with Ctrl/⌘ + C and paste it straight into a spreadsheet. Ctrl/⌘ + Alt + C copies with headers — the column names, row names and the table's own name come along — so a block can be sorted or rearranged in the spreadsheet and pasted back onto the right cells.

Pasting a block after clicking a cell fills every row the block covers; pasting a single value, or a paragraph of text, goes into the open editor. A pasted block that names a row or column the table doesn't have, names one twice, or holds a value a column can't take is refused with a message rather than written to a guess.

Edits appear the moment you make them rather than after the server answers, and a burst of edits is sent together instead of one request per change. A cell still waiting on the server carries a small dot in its corner, and the browser warns you if you reload while a write is still saving.

Ctrl + Z steps back through your edits and Ctrl + Shift + Z steps forward again. Undo puts back exactly what a change took away — in the BOM connection table that includes connections moved aside to make room.