Specifications

20 – Using PlantScape Data in Other Applications
462 R400
To edit a formula array:
1 Select all the cells which form the formula array.
2 Click the formula in the formula entry line near the top of the window.
3 Edit the formula as necessary.
4 Press <Ctrl>+<Shift>+<Enter> to place the formula back into the formula
array cells.
To change the number of cells in a formula array:
1 Follow Steps 1 and 2 of the editing instructions.
2 Copy the formula to the clipboard (press <Ctrl>+<C>).
3 Delete the cells.
4 Select the required cells for the new formula array.
5 Paste the formula from the clipboard (<Ctrl>+<V>).
6 Press <Ctrl>+<Shift>+<Enter> to place the formula back into the formula
array cells.
For more information on these topics refer to Microsoft Excel’s online
documentation.
plscpcg.book Page 462 Monday, May 28, 2001 10:11 AM