Select Multiple Rows
To edit multiple items at once:- Click the first row header to select a row
- Hold Ctrl (Windows/Linux) or Cmd (Mac) and click additional row headers
- Or hold Shift and click a row header to select a range
- Selected rows are highlighted with a colored background
Edit a Single Column Across Rows
With multiple rows selected:- Click any editable cell in the column you want to change
- Enter the new value
- Press Enter or click outside the cell
- The same value applies to all selected rows
Copy and Paste Multiple Cells
To copy values across cells:- Select the source cell(s) by clicking
- Press Ctrl+C (Windows/Linux) or Cmd+C (Mac)
- Select the target cell(s)
- Press Ctrl+V (Windows/Linux) or Cmd+V (Mac)
- Values are pasted into all selected cells
Bulk Edit Workflow for Dependent Enums
When editing columns with dependent relationships (e.g., Risk Category → Risk Type):- Select multiple rows
- Edit the parent column (e.g., Risk Category)
- RISKSHEET automatically updates child columns (e.g., Risk Type) based on configured mappings
- Invalid child values are cleared or filtered
Bulk Link to Upstream Items
To link multiple risks to the same upstream item:- Select the rows you want to link
- Click the upstream link column cell
- Type to search or click the dropdown arrow
- Select the upstream item (e.g., Requirement, Hazard)
- Press Enter
- All selected rows now link to the same upstream item
When you link to an upstream item, nested columns (e.g., Requirement.Status, Harm.Severity) automatically fill for all selected rows.
Bulk Create Downstream Items
Bulk creation of downstream items (tasks, mitigations) is not directly supported. You must:- Create downstream items row-by-row using the + button
- Or use copy-paste to duplicate task links across rows (if tasks already exist)
Keyboard Shortcuts for Efficiency
| Action | Shortcut (Windows/Linux) | Shortcut (Mac) |
|---|---|---|
| Copy | Ctrl+C | Cmd+C |
| Paste | Ctrl+V | Cmd+V |
| Undo | Ctrl+Z | Cmd+Z |
| Redo | Ctrl+Y | Cmd+Y |
| Select range | Shift+Click | Shift+Click |
| Add to selection | Ctrl+Click | Cmd+Click |
Undo Bulk Changes
All bulk edits are tracked in the undo stack:- Press Ctrl+Z (Windows/Linux) or Cmd+Z (Mac)
- The entire bulk operation reverts
- If dependent columns were auto-updated, those changes also revert
Performance Considerations
Performance Impact: Rows Edited Columns Affected Performance 1-50 Any Instant 50-200 < 10 columns Fast 200-500 < 10 columns Moderate 500+ Many linked cols Slow*- Consider splitting into multiple risksheets
Verification
After performing bulk edits:- Scroll through the affected rows
- You should see consistent values across all selected cells
- Dependent columns (if configured) should reflect cascaded updates
- Save the RISKSHEET to persist changes
- Check the Polarion work item history to verify bulk updates were recorded