Data gridPro

Arrow keys

Move the active cell.

Shift+arrows

Extend the range from the active cell.

Cmd/Ctrl+arrows

Jump to the first or last row or column. Add Shift to extend the range.

HomeorEnd

Move to the first or last column in the row.

Cmd/Ctrl+HomeorEnd

Move to the first or last cell of the grid.

PageUporPageDown

Move by one visible page of rows.

Cmd/Ctrl+A

Select every cell.

Ctrl+Space

Extend the range to the whole of its columns.

Shift+Space

Check or uncheck the rows in the range. Needs rowSelection.

EnterorF2

Edit the active cell, keeping its value. Arrow keys then move the caret.

Any character

Start editing and replace the value. Arrow keys then commit and move, like Excel.

Alt+ArrowDown

On a select cell, open its option list.

EnterorShift+Enter (editing)

Commit and move down or up. An invalid value stays open and is marked.

TaborShift+Tab (editing)

Commit and move right or left.

ArrowUporArrowDown (option list)

Move through select options. Enter or Tab picks the highlighted one.

Alt+ArrowDown (date editing)

Open the calendar and move focus into it. Arrow keys pick a day, Enter saves it, Escape returns to the text.

Escape (editing)

Close the option list or calendar, or cancel the edit.

Escape

Collapse the range to the active cell, or else clear checked rows.

DeleteorBackspace

Clear the range. Read-only cells are skipped.

Cmd/Ctrl+D

Fill down: copy the top row of the range into the rows below.

Cmd/Ctrl+CorXorV

Copy, cut, or paste. Works with Excel, Google Sheets, and Numbers.

Cmd/Ctrl+Z

Undo.

Cmd/Ctrl+Shift+ZorCmd/Ctrl+Y

Redo.

Shift+click header

Add the column as the next sort key. Plain click cycles ascending, descending, off.

Alt+ArrowLeftorArrowRight (header)

Narrow or widen the column by 16px.

EnterorArrowDown (searchorfilter input)

Return focus to the grid.

Escape (searchorfilter input)

Clear the input, or return to the grid when it is empty.

• The grid is one focusable role="grid" with aria-multiselectable, aria-rowcount, aria-colcount, and aria-busy while loading. The active cell is exposed through aria-activedescendant, not moving focus.
• Rows and cells carry aria-rowindex and aria-colindex, so counts stay right while rows are virtualized. The active and editing rows stay mounted when scrolled away.
• Cells report aria-selected and aria-readonly. Rows report aria-selected when checked.
• Headers are role="columnheader" with aria-sort. The sort button label names the direction, the sort priority, and the Alt + arrow resize keys.
• The cell editor is labelled by column and row name and sets aria-invalid on a bad value. On select columns it is a combobox that controls a listbox, with aria-activedescendant on the highlighted option.
• Row checkboxes are role="checkbox" and stay out of the tab order; the select-all box in the header is tabbable and shows a mixed state.
• Number filter inputs describe their syntax and set aria-invalid on an unreadable expression. Select filters open a labelled checklist.
• Edits, sorts, checks, copies, pastes, fills, undo, and redo are announced in a polite live region. The row count is also a polite live region.
• Totals cells carry a full aria-label, such as "Q1 sum $15,200".
• With groupBy the grid becomes role="treegrid". Group rows carry aria-level and aria-expanded, their toggle is a button that names the group, row count, and action, and subtotal cells carry full labels. Data rows carry aria-level too.
• The date editor is a combobox with a dialog popup. The calendar opens in a portal so the grid never clips it, and focus returns to the cell when it closes.
• Scrolling columns outside the view are not rendered, but every cell keeps its aria-colindex, and the active and editing cells stay mounted.
• With a data source, rows still loading render as placeholder rows with aria-busy.

• The selection rectangle and active cell spring between ranges on motionTokens.spring.snappy. Scrolling moves them at once, and resizing a column snaps them.
• After a sort, rows slide to their new place on the spring curve for 700ms, and rows arriving from off screen fade in.
• Pasted, filled, undone, and redone cells flash a wash that fades out over 0.9s.
• The toolbar swaps to bulk actions with a short slide, fade, and blur. Status messages enter the same way.
• Totals, the selection summary, and the checked count roll with animated-counter.
• An invalid edit shakes once. Menus and the option list fade and scale in from their anchor.
• A group's chevron turns on the spring curve as it opens and closes.
• Reduced motion jumps the selection, drops the row slide, the shake, the press scales, the chevron turn, and the skeleton pulse, and keeps short fades.

• The grid scrolls in both directions inside maxHeight. The header and totals row stay sticky, and pinned columns and the row gutter stay on the left.
• Pinned columns are scaled down to about half of the grid width so a narrow grid still shows scrolling columns.
• Layout reacts to the grid's own width with container queries. Below 640px toolbar buttons become icons. Below 460px the row count and undo and redo buttons hide. Below 480px the status message wraps to its own line.
• On touch a pan scrolls the grid. A tap selects a cell on release, a second tap edits it, and only the fill handle takes over a touch drag.
• Row checkboxes and header menu buttons are always visible on devices without hover.

• Rows are virtualized: only the visible rows plus 6 above and below render, each positioned with translateY. Rows are memoized, so scrolling and typing re-render only the rows they touch.
• Filters and search use useDeferredValue, so typing a filter stays responsive on large data.
• The sorted and filtered view is recomputed only when sort, filters, search, visible columns, or the set of row ids change, not on every edit.
• Select column options are derived from up to 200 distinct values when options is not given; pass options for large or wide data.
• Columns are virtualized too: pinned columns always render, and scrolling columns render only within about 240px of the view, updated every 64px of horizontal scroll.
• Group rows are computed with the view, not on every edit, so an edited row stays in its group until the next sort, filter, or grouping change. Subtotals update at once.
• A dataSource keeps up to 40 blocks and aborts requests that a sort, filter, or search change makes stale. Undo holds up to 100 full row snapshots.

• Choose it when people edit many values in place like a spreadsheet. Use sortable-data-table for read-only records. For rows that roll up under a shared value, such as journal lines by account and period, use groupBy.
• Every row needs a unique, stable id. Column keys map to row fields. Keep rows from onRowsChange to persist edits.
• Use number, currency, or percent for numeric data so parsing, right alignment, totals, and the status bar sum work. Store raw numbers, not formatted strings.
• Mark computed or locked columns editable: false. Give select columns options so pasted and typed values are checked against them.
• Copy writes tab separated text plus an HTML table with formatted values, so Excel and Sheets read typed numbers. Paste reads an HTML table first, then TSV with quoted cells. A selection that is a whole multiple of the clipboard is tiled; values that do not parse are skipped and reported.
• The bulk Copy button copies checked rows with a header row through navigator.clipboard, and Export downloads CSV of checked rows. The toolbar Export downloads all filtered rows in view order.
• A sort reorders once, like a spreadsheet. Editing a value does not re-sort or re-filter, so rows never jump under the cursor.
• Undo keeps 100 steps and covers edits, fills, pastes, clears, and row deletes. Sort, filter, and column changes are view state and are not undone.
• Text filters match accent-insensitive substrings; prefix = for an exact match or ! to exclude. The quick search matches every word across visible columns.
• Filtering, sorting, and grouping run on the client over the rows you pass. For data too large to send at once, pass a dataSource: the grid asks for blocks of rows as people scroll and sends sort, filters, and search with each request.
• Use a date column for days. Values stay ISO day strings, so they round-trip with no time zone shift; sort and filter compare them as days, and the fill handle continues a daily or monthly series.
• Grouping reuses each column's aggregate for its subtotals, so one setting drives the group rows and the totals row. A grouped .xlsx export writes SUBTOTAL formulas, so Excel never counts a subtotal twice.
• For a small form table, turn off rowNumbers when rows already carry their own number, and selectionStats when the address and counts mean nothing to the reader.

The full library index for assistants is at /llms.txt.