> ## Documentation Index
> Fetch the complete documentation index at: https://learn.nextedy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Perform Bulk Editing

> Edit multiple risk items at once using keyboard shortcuts, multi-row selection, and cascading relationship propagation.

export const LastReviewed = ({date}) => {
  if (!date) return null;
  const formatted = new Date(`${date}T00:00:00Z`).toLocaleDateString("en-US", {
    year: "numeric",
    month: "long",
    day: "numeric",
    timeZone: "UTC"
  });
  return <p className="mt-10 text-sm text-gray-400 dark:text-zinc-500 not-prose">
      Last reviewed on {formatted}
    </p>;
};

## Select Multiple Cells

To perform bulk operations, first select the target cells:

1. Click a cell to select it as the starting point
2. Hold **Ctrl** (or **Cmd** on macOS) and click additional cells to add them to the selection
3. Alternatively, click the first cell, then **Shift+Click** the last cell in a range to select a contiguous block

<Tip title="Row Selection">
  Click the row header to select an entire row. Hold **Ctrl** and click additional row headers to select multiple non-adjacent rows.
</Tip>

## Copy Values to Multiple Cells

The most efficient bulk editing technique is copy-paste across selected cells:

1. Select the source cell containing the value you want to replicate
2. Press **Ctrl+C** to copy the cell value
3. Select all target cells where you want to paste the value (using Ctrl+Click or Shift+Click)
4. Press **Ctrl+V** to paste the value into all selected cells

<Frame>
  <img src="https://mintcdn.com/none-17b4493f/-Icoak49xQVOW38R/risksheet/diagrams/guides/advanced/bulk-editing/diagram-1.svg?fit=max&auto=format&n=-Icoak49xQVOW38R&q=85&s=61c1df9be0058cc98e819908632e1d2d" alt="diagram" style={{ maxWidth: "560px", width: "100%" }} width="560" height="200" data-path="risksheet/diagrams/guides/advanced/bulk-editing/diagram-1.svg" />
</Frame>

<Warning title="Merged Cells">
  Copy-paste works only on unmerged cells. If your selection includes merged cells (common in multi-level FMEA hierarchies), only the unmerged cells receive the pasted value. Merged cells accept paste operations only into the merge root cell.
</Warning>

## Bulk Edit with Cascading Updates

When you edit an enumeration field across multiple selected rows, Nextedy RISKSHEET automatically propagates dependent enumeration updates to all selected items. This keeps data consistent across bulk operations.

**Example:** Changing the `Risk Category` from "Mechanical" to "Electrical" on three selected rows simultaneously updates each row's `Risk Type` options according to configured relationship mappings.

### How It Works

1. Select multiple rows by clicking row headers while holding **Ctrl** or **Shift**
2. Edit a parent enumeration field (e.g., `severity`) on any of the selected rows
3. Risksheet applies the new value to all selected rows
4. Dependent child columns update automatically based on the configured dependent enum mapping

<Tip title="Cascading Changes Are Fully Undoable">
  All cascading relationship updates from a bulk edit are tracked as a single undo action. Press **Ctrl+Z** to revert the parent change and all automatically updated child fields across all affected rows at once.
</Tip>

## Keyboard Shortcuts for Bulk Operations

| Shortcut        | Action                                            |
| --------------- | ------------------------------------------------- |
| **Ctrl+C**      | Copy selected cell value                          |
| **Ctrl+V**      | Paste value into all selected cells               |
| **Ctrl+Z**      | Undo last operation (including cascading updates) |
| **Ctrl+Y**      | Redo last undone operation                        |
| **Ctrl+Click**  | Add cell to selection                             |
| **Shift+Click** | Select range of cells                             |

<Note title="Fill-down not available">
  The **Ctrl+D** fill-down shortcut (similar to Excel) is not currently available in this version. Use the Ctrl+C / Ctrl+V workflow described above as an alternative for filling values down through a column.
</Note>

## Autocomplete for Consistent Data Entry

When editing text or link columns across multiple rows, Risksheet provides autocomplete suggestions to speed up data entry and maintain consistency:

* **Text fields**: As you type, existing values from the same column are suggested for consistency across risk items
* **Link columns**: Type a work item ID or title to search, or click the  dropdown arrow to browse available items
* **New item creation**: For link columns with `canCreate` enabled, type a new value and select **Add new \<type>** to create and link a new work item inline

<Tip title="Auto-Selection">
  When autocomplete returns exactly one matching item for a non-task link column, Risksheet auto-selects it. This significantly speeds up bulk data entry when linking to items with unique identifiers.
</Tip>

Autocomplete includes unsaved local changes, so you can reference items created earlier in the same session before saving to the server.

## Verify Your Bulk Edit

After performing bulk edits:

1. Review the modified cells — changed values appear with a visual indicator until saved
2. Check that dependent enum columns updated correctly on all edited rows
3. Save the document to persist changes to Polarion

You should now see all bulk-edited values saved, with dependent fields correctly reflecting the cascading relationship rules.

## See Also

* [Configure Dependent Enums](/risksheet/guides/advanced/dependent-enums) — set up cascading relationships between columns
* [Configure Multi-Select Enums](/risksheet/guides/advanced/enum-multiselect) — enable multi-value selection on enum columns
* [Use Undo and Redo](/risksheet/guides/advanced/undo-redo) — revert bulk operations
* [Configure Calculated Columns](/risksheet/guides/columns/calculated-columns) — formulas that recalculate after bulk edits

<LastReviewed date="2026-06-18" />