Where a table allows editing, you change a value by double-clicking its cell. Changed cells are marked in the grid, and they stay unsaved until you save them, so you can always see what still needs attention.
Only one cell is open for editing at a time. Opening another cell saves the one you were on. Press Escape instead to cancel: the cell keeps its previous value and no change is recorded.
A checkbox cell works differently: ticking one changes the value straight away, with no edit mode, and the tick saves at once.
For the kinds of cell you can meet, see Cell types and formats.
A text cell suggests values that already exist in that column, listed in alphabetical order.
A date cell opens a Date Slicer calendar when you start editing it.
Clicking outside the calendar, or pressing Escape, also cancels the picker without saving. A date shows as the day, the month and the year; a date-and-time column adds the time after the date.
Select the cells you want to fill, then paste. The block of values lands at the top-left of your selection, and only cells you can edit take the values. A large paste shows a progress overlay while it works: the operation title, for example Pasting data... or Creating new rows..., a Progress bar, the rows done so far out of the total, and the percentage complete.
If a paste cannot be applied, a message titled Paste failed appears with the reason. Selecting, copying and pasting are covered in Select, copy and paste cells.
Three things count as unsaved changes: a value you edited, a row you deleted, and a row you added.
The draft is kept in the browser you are working in; another browser or computer does not have it.
A row you add sits at the bottom of every page until you save it. New rows ignore sorting and filters, so they stay visible while you work. See The data grid for how pages and filters treat them.
Some tables offer shared edits. Where that option is on:
If editing one ticked row changes only that row, the option is not on for that table; edit the rows one at a time.
Double-click the cell, type or pick the new value, and press Enter or click outside to save. A cell that does not respond to a double-click is not editable; see Cell types and formats.
Enter, or clicking to another part of the page, saves a text edit; Escape cancels it. In a date cell, click Apply to save and Cancel to leave the value as it was. A checkbox saves the moment you tick it.
It is locked. Point at its lock icon to read the reason; unless the column has its own reason, the message reads System columns can't be modified. See Cell types and formats.
One cell at a time. To put the same value in several checked rows in one go, the table must offer shared edits; then editing a cell in one ticked row fills that column across all ticked rows.
The column has no existing values to suggest yet. Type the value yourself; it saves like any other edit.
Turn on the Time toggle in the Date Slicer, set the time, and click Apply. A date-and-time column opens with the time part ready; choosing a day keeps the time already stored for the cell.
An edited value, a deleted row or an added row. While any of them exist, the toolbar shows Save N unsaved rows and Discard unsaved changes.
If you only edited or deleted rows, you can leave; the draft keeps those changes. If you added new rows, the Unsaved Changes dialog appears: Stay on Page keeps you there, and Discard & Continue leaves and clears the changes.
The grid keeps them in your browser, so a reload does not lose them, and it drops that copy after about a day. Save the rows when you are ready to keep the changes.
The table offers shared edits. With two or more rows ticked, editing a cell in one of them fills that column across all ticked rows. Untick the rows you do not want included, then edit again.