Copy and paste a single LOB value into multiple LOB cells
Save time by copying and pasting single LOB (line of business) values into multiple LOB cells.
Procedure
- 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 pasteCommercial
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 and then click in the first target cell in the LOB column.
- Hold down Shift and then click in the last target cell to highlight the selected range of target cells
- Right-click in the highlighted area and click Paste.