Spreadsheet operations

Mass edit tables support the following standard spreadsheet operations.

SelectionSelect one or multiple cells.
  • To select a cell, single-click on 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 single-click on the desired cells.
  • Edit cellEdit a single cell. You can modify the fields with different methods, depending on their input type.Double-click or select a cell and press Enter.
    Copy/pasteCopy 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 dropCopy the value of a cell to adjacent cells in the same row or column.Select a cell, long-click the small square at the right-bottom corner of the cell, and drag it horizontally or vertically to copy its value.
    Freeze paneFreeze a part of the table in place.
  • To freeze up to a certain row or column, select the desired row or column header and click Freeze panes.
  • To freeze both rows and columns, select a cell, then click Freeze panes.
  • Warning

    An unexpected error occurs if you try to scroll through frozen cells. This is a known issue, and it will be fixed in a later release.

    Can we improve this article ? Provide feedback