The grid
The grid is the main view of a project. Each row is a record. Each column is a field.
Editing
Section titled “Editing”Click a cell to select it. Type to replace its content, or press Enter to edit in place. Copy, cut, and paste work across one cell or a selected range, including between qrate and other spreadsheet apps.
Every edit goes on the undo stack, including row and column changes. Press Ctrl+Z to undo and Ctrl+Shift+Z (or Ctrl+Y) to redo. Undo and redo also cover adding, removing, and reordering rows and columns, so a structural change is as safe to try as a cell edit.
Rows and columns
Section titled “Rows and columns”Right-click a row or column header for a menu to add, remove, rename, freeze, or reorder it. A frozen row or column stays in view while you scroll.
Search and replace
Section titled “Search and replace”Open search with Ctrl+F. Search moves through matching cells in the grid. Open replace with Ctrl+H to replace one match or all matches at once.
Filtering
Section titled “Filtering”Click the filter icon in a column header to open its filter. It lists every distinct value in that column as a checklist. Uncheck a value to hide the rows that hold it. The grid shows only rows that pass every active column filter at once.
Filtering hides rows. It does not change or delete data, and it does not affect export or diagnostics, which both still see every row.
Gallery view
Section titled “Gallery view”Switch the grid to a gallery of thumbnails from the view menu. The gallery shows one tile per row, using the file or photo linked to that row. It is a way to review a collection by image instead of by cell, useful for photo collections in particular.
Right-click a cell and choose Add note to attach a free-text note to it. A cell with a note shows a small corner marker. Notes are for your own reviewing use. They are not exported.