Origin/destination box changes to Destination Formula Address
The destination formula address shows the range where the Enter Formula button will place the formula. You can change this destination using the Home button. Note that the destination can be a single cell or a range of cells.
Double-clicking the destination address will select the range identified by its address.
Unformat/Reformat
Clicking Reformat will re-indent the formula text according to the current settings. You can use this after you have manually edited the text.
|