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
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.
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.
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:
The first row is copied to the rows selected below it.
Tip:
Undo changes to the data by clicking Revert Changes in the Selection or Selection Actions menus.
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:
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 clicking Revert Changes in the Selection or Selection Actions menus.
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
Tip:
Undo changes to the data by clicking Revert Changes in the Selection or Selection Actions menus.
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:
The value of the selected cells is replaced with an empty text string.
You do not need to save the report because Clear directly affects the data in the database.
Tip:
Undo changes to the data by clicking Revert Changes in the Selection or Selection Actions menus.