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.

Escape (editing)

Close the option list, 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".

• 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.
• Reduced motion jumps the selection, drops the row slide, the shake, the press scales, 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 not virtualized, so keep column counts moderate. 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 and tree-table for nested rows.
• 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.
• All filtering and sorting run on the client over the rows you pass. For server data, control sort and filters and fetch on change.

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