Skip to Content

Copying and pasting multiple cells

You can also copy and paste multiple values into one or more cells using the following guidelines:

  • If you copy a selection of cells and attempt to paste them into a single cell, the Growth Plan Editor automatically pastes all the originally selected cells into the equivalent number of cells in the destination area overlaying the cells in the new location according to the source selection.
  • If you copy a selection of cells and attempt to paste into a smaller area of cells, the Growth Plan Editor pastes according to best fit. The rule is that pasting is prioritized for values positioned in the left upper most quadrant of the source selection. 
  • If the destination range of cells into which you are pasting is larger than the source range of cells, the cells are duplicated according to the left to right, up, down sequence until the entire range of destination cells are filled. 
Warning

Note

If you select cells, and then collapse the view of their associated children, a dithered border appears around the selected cells to alert you that there are hidden child cells there. If you drag this selection to another area, these hidden cells are moved into the destination location as normal. 

To change a value

Use the following procedure to change values.

  1. Right-click a cell and choose Context => Change Value.
  2. Type a new value in the dialog box that opens.
  3. Click OK.

To clear contents of a value

Right-click a cell and choose Context => Clear Contents to set the cell to zero.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Performance Predictor for Mainframes 1.9.10