---
title: "Spreadsheet operations"
slug: "spreadsheet-operations"
abstract: "List of the standard spreadsheet operations available in an editing table."
---
# Spreadsheet operations

Mass edit tables support the following standard spreadsheet operations.

| Name | Operation | Method |
| --- | --- | --- |
| *Selection* | Select one or multiple cells. | <ul><li>To select a cell, click it.</li><li>To select multiple adjacent cells, click and hold a cell, and move the cursor over the desired cells.</li><li>To select multiple non-adjacent cells, hold Ctrl and click the desired cells.</li></ul> |
| *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**:<br><br><ul><li>To freeze everything above a specific row, select that row.</li><li>To freeze everything to the left of a specific column, select that column.</li><li>To freeze all rows above a specific cell, and all columns to the left of it, select that cell.</li></ul> |
| *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.<br><br>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.