Previous Next JavaScript must be enabled to correctly display this content

## 4.6.4 Modifying Multiple Rows and Cells in an Editable Interactive Grid

Quickly modify the values of multiple rows and cells with the Actions, Selection submenu.

- About Selection Modes in an Editable Interactive Grid
  You can select rows or groups of cells in an interactive grid by toggling between selection modes.
- Changing Selection Mode in an Editable Interactive Grid
  Switch between Cell Selection mode and Row Selection mode by using the Actions, Selection submenu.
- Copying to Multiple Rows in an Editable Interactive Grid
  Copy the value of a row and apply it to a group of rows by using Copy Down in the Actions, Selection submenu.
- Copying to Multiple Cells in an Editable Interactive Grid
  Copy the value of a cell and apply it to a group of cells in the same column by using Copy Down in the Actions, Selection submenu.
- Filling Cells in an Editable Interactive Grid
  Apply a single value to a group of cells in an editable interactive grid by using Fill in the Actions, Selection submenu.
- Clearing Cells in an Interactive Grid
  Delete the contents of multiple cells by using Clear in the Actions, Selection submenu.

Parent topic: Using an Editable Interactive Grid

### 4.6.4.1 About Selection Modes in an Editable Interactive Grid

You can select rows or groups of cells in an interactive grid by toggling between selection modes.

Row Selection

  Row Selection is the default selection mode in interactive grids. Check boxes appear next to every row in the left-hand column, so you can select multiple individual rows at once by mouse-click. You can also press the arrow keys on the keyboard to navigate up and down between rows, or hold the Shift key at the same time to select multiple adjacent rows.

  With multiple rows selected, you can use the Selection menus to apply a single change to the entire selection.

Cell Selection

  You can switch to Cell Selection mode in the Selection submenu in the Actions menu or by pressing F8.

  In Cell Selection mode, the check boxes disappear, and you can select individual cells by mouse-click. You can also hold the Shift key and use mouse or the arrow keys to select multiple adjacent cells.

  With multiple cells selected, you can use the Selection menus to apply a single change to the entire selection.

Parent topic: Modifying Multiple Rows and Cells in an Editable Interactive Grid

### 4.6.4.2 Changing Selection Mode in an Editable Interactive Grid

Switch between Cell Selection mode and Row Selection mode by using the Actions, Selection submenu.

Interactive grids are in Row Selection mode by default. You can switch to selection modes to select groups of rows or cells.

1. To switch selection modes, do one of the following:
   - Click the Actions menu, select Selection, and click Cell Selection or Row Selection.
   - Press F8 on your keyboard (Tip: ensure only one or no objects are selected).
   The selection mode switches.
2. To switch back, repeat this step.

Parent topic: Modifying Multiple Rows and Cells in an Editable Interactive Grid

### 4.6.4.3 Copying to Multiple Rows in an Editable Interactive Grid

Copy the value of a row and apply it to a group of rows by using Copy Down in the Actions, Selection submenu.

To apply the value of an existing row to a group of rows below it:

1. Ensure you are in Row Selection mode.
2. Select the row you want to copy.
3. Do one of the following to select the rows you want to change:
   - Using the mouse, click the adjacent check boxes. Using the check boxes enables you to apply changes to non-contiguous rows.
   - Using the keyboard, hold Shift and press the Down arrow key to quickly select a group of adjacent rows below the first row. If you select too many rows, keep holding Shift and press the Up arrow key to de-select rows.
4. Click the Actions menu, select Selection, and select Copy Down.

   Tip:

   You can also use the Selection Actions menu in the header row to quickly access several Selection submenu options (including Copy Down).

The first row is copied to the rows selected below it.

Tip:

Undo changes to the data by returning to Row Selection mode, selecting the affected row(s), and clicking Actions, Selection, Revert Changes. Revert Changes applies to whole rows, not cell ranges.

Tip:

You can also Copy row data, and then Paste to overwrite data in an existing row, or Paste Insert to insert a new row.

Related Topics

- About Editable Interactive Grids

Parent topic: Modifying Multiple Rows and Cells in an Editable Interactive Grid

### 4.6.4.4 Copying to Multiple Cells in an Editable Interactive Grid

Copy the value of a cell and apply it to a group of cells in the same column by using Copy Down in the Actions, Selection submenu.

To apply the value of an existing cell to a group of cells below it:

1. Ensure you are in Cell Selection mode.
2. Select the cell you want to copy.
3. Do one of the following to select the cells you want to change (all cells in a single selection must be contiguous):
   - Using the mouse, hold the Shift key and click the last cell in the group.
   - Using the keyboard, hold the Shift key and press the down arrow key to select cells.
4. Click the Actions menu, select Selection, and select Copy Down.

   Tip:

   You can also use the Selection Actions menu in the header row to quickly access several Selection submenu options (including Copy Down).

The first cell is copied to the cells selected below it.

You can also select cells in adjacent columns and use Copy Down to copy the value of the different cells in each column to cells below it (values do not copy across columns).

Tip:

Undo changes to the data by returning to Row Selection mode, selecting the affected row(s), and clicking Actions, Selection, Revert Changes. Revert Changes applies to whole rows, not cell ranges.

Tip:

You can also Copy cell data, and then Paste to overwrite data in an existing cell, or Paste Insert to insert a new row containing only the data in that cell.

Related Topics

- About Editable Interactive Grids

Parent topic: Modifying Multiple Rows and Cells in an Editable Interactive Grid

### 4.6.4.5 Filling Cells in an Editable Interactive Grid

Apply a single value to a group of cells in an editable interactive grid by using Fill in the Actions, Selection submenu.

You can also apply a single value to all the cells in a row (or a group of rows) by using Fill in Row Selection mode.

To apply a single value to all the cells in a row or group of rows:

1. Ensure you are in Cell Selection mode by selecting Actions, then Selection, and then Cell Selection. You can also press F8.
2. Select the first cell of the group.
3. Press and hold the Shift key, and use the mouse or arrow keys to select a group of cells.

   Tip:

   All selected cells must be adjacent for a single Fill action. Repeat this procedure for non-adjacent cells.
4. Select the Actions menu, select Selection, and select Fill.
   The Fill Selection dialog displays.
5. Enter a value. Click OK.
6. (Optional) Change back to Row Selection mode by selecting Actions, then Selection, and then Row Selection. You can also press F8.

The entered value applies to the selected cells.

Tip:

Undo changes to the data by returning to Row Selection mode, selecting the affected row(s), and clicking Actions, Selection, Revert Changes. Revert Changes applies to whole rows, not cell ranges.

Parent topic: Modifying Multiple Rows and Cells in an Editable Interactive Grid

### 4.6.4.6 Clearing Cells in an Interactive Grid

Delete the contents of multiple cells by using Clear in the Actions, Selection submenu.

You can also clear all of the cells in a row (or a group of rows) by using Fill in Row Selection mode.

To delete the contents of a group of adjacent cells:

1. Ensure you are in Cell Selection mode (select Actions menu and then Selection, or press F8).
2. Select the first cell of the group.
3. Press and hold the Shift key, and use the mouse or arrow keys to select a group of cells.

   Tip:

   All selected cells must be adjacent for a single Clear action. Repeat this procedure for non-adjacent cells.
4. Select the Actions menu, select Selection, and select Clear.

The value of the selected cells is replaced with an empty text string.

Tip:

Undo changes to the data by returning to Row Selection mode, selecting the affected row(s), and clicking Actions, Selection, Revert Changes. Revert Changes applies to whole rows, not cell ranges.

Parent topic: Modifying Multiple Rows and Cells in an Editable Interactive Grid