Copying and Pasting a Single LOB Value into Multiple LOB Cells
Procedure
To copy and paste a single LOB value into multiple LOB cells:
- Navigate to the LOB Mapping tab.
- Click in an Industry LOB or UNICEDE LOB cell that contains an LOB value.
-
Double-click the LOB value that you want to copy.
For example, double-click
Commercial
. Touchstone highlights the value. When there are two parts to the value, such as inResidential Building
, make sure that you highlight the entire value. -
Right-click the highlighted LOB value and do one of the following:
Select Copy from the shortcut menu.
Hold down Ctrl and press C.
-
Click in the LOB cell where you want to paste the LOB
value.
The cell becomes editable.
-
Right-click in the cell and do one of the following:
Select Paste from the shortcut menu.
Hold down Ctrl and press V.
If you right-click an existing value in a cell, Touchstone highlights the existing value so that you can paste over it. If there are multiple matches, Touchstone displays a list of matching values. Select the LOB value that you want to use.
For example, if you paste
Commercial
in a cell where the country is Denmark, you can then select2 – Commercial
or17 – Commercial & Industrial
. - Repeat steps 5 and 6 for each target cell.
-
To paste the value into contiguous cells:
- Copy an LOB value.
- Highlight the first target row.
- Move the pointer to the Industry LOB or UNICEDE LOB cell in that row.
-
Drag the pointer down the LOB column to highlight the contiguous target cells in the
column, right-click in the highlighted area, and paste the copied LOB value into the
target cells.
Alternatively, use standard Microsoft Windows multi-select (Shift + Click) to select contiguous cells:
Copy an LOB value, click in the first target cell in the LOB column.
Hold down Shift and then click in the last target cell.
Touchstone highlights the target cells.
Right-click in the highlighted area and click Paste.