You can add single or multiple cells to a Data Grid. The procedures below list the steps that you follow in order to insert a single cell. To insert more than one cell, either drag over a block of cells, or see Keyboard Shortcuts for other ways of making multiple selections. The number and location of the cells that you select determines the number and location of the cells that are inserted immediately above or to the left of your selection.
Example:
If you select a block of four cells and choose to insert additional cells to the left of those cells in the Data Grid, a block of four new cells will be inserted to the left of the selected block of cells.
However, if you select four cells in different parts of the Data Grid and choose to insert additional cells to the left of those cells, one additional cell will be inserted to the left of each selected cell.
ATTENTION: Be aware that the insertion of additional cells has the effect of moving existing cells to the right or further down from their present position in a Data Grid. You need to ensure that you make the necessary provisions to avoid losing the content of any cells that exist to the far-right or the last row in a Data Grid. Also be aware that causing an existing cell to move into a different field type may affect the resulting value of that cell.
You can use one of two procedures to add an individual cell to a populated Data Grid:
To insert a new cell and move existing cells to the right:
- Select the cell to the right of the point at which you want to insert an additional cell.
- Right-click on the cell.
A context-sensitive menu is displayed. - Select the Insert option.
The Insert window is displayed..png)
- Ensure that the Shift cells right option button is selected.
- Select the OK button.
The Insert window is closed. A new cell is added at the specified location. Existing cells to the right of the new cell are shifted to the right to make way for the new cell.
To insert a new cell and move existing cells down:
- If the bottom-most cell in the column to which a new cell is being added is populated, ensure that you make the necessary provisions to avoid losing the content of that cell.
- Select the cell above which you want to insert an additional cell.
- Right-click on the cell.
A context sensitive menu is displayed. - Select the Insert option.
The Insert window is displayed..png)
- Ensure that the Shift cells down option button is selected.
- Select the OK button.
The Insert window is closed. A new cell is added at the specified location. Existing cells that appear below the new cell are shifted down to make way for the new cell.