Spreadsheet operations

Mass edit tables support the following standard spreadsheet operations.

Name	Operation	Method
Selection	Select 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 cell	Edit 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/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 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 pane	Freeze 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.

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