Spreadsheet operations

Mass edit tables support the following standard spreadsheet operations.

Name

Operation

Method

Selection

Select one or multiple cells.

  • To select a cell, click it.

  • To select multiple adjacent cells, click and hold a cell, and move the cursor over the desired cells.

  • To select multiple non-adjacent cells, hold Ctrl and click the desired cells.

Edit cell

Edit a single cell. You can modify the fields with different methods, depending on their input type.

Double-click a cell, or select a cell and press Enter.

Copy/paste

Copy the value of a cell into one or multiple cells.

Select a cell, press Ctrl+C, select one or multiple other cells, and press Ctrl+V.

Drag and drop

Copy the value of a cell to cells in the rows below.

Select a cell, then click and drag down the small square in the bottom-right corner of that cell. This draws a rectangle over adjacent cells, and when you release the mouse button the selected value is copied into all cells inside that rectangle.

Freeze pane

Freeze a part of the table in place.

Freeze part of the table in place, so it remains on-screen as you scroll through the rest of the table. Frozen rows and columns must be adjacent, and only one area can be frozen at a time. To freeze part of the table, select one of the following and then click Freeze panes:

  • To freeze everything above a specific row, select that row.

  • To freeze everything to the left of a specific column, select that column.

  • To freeze all rows above a specific cell, and all columns to the left of it, select that cell.

Fill entire column

Copy the value of one cell to all other cells in the same column.

Right-click a cell, select Fill entire column from the context menu, and click Save to apply the changes.

To undo, click Undo once to revert the entire column update.

Note

You can’t use the Copy/paste operation with dateTimeOffset or relations fields.

Do you have some feedback for us?

If you have suggestions for improving this article,