|
OfficeTips Home || VBA Section || General Section || Download Section || Privacy Policy |
Use Range Finder to Troubleshoot Formulae |
|
Yet another useful feature while you
are troubleshooting a formula is the Range Finder.
Double-click a cell that contains a formula. Excel
highlights each cell or range of cells, which is referenced by the
formula, with a different color.
To change a cell or range reference
to a different cell or range, drag the color-coded border of the cell or
range to the new cell or range. To include more or fewer cells in a
reference, use the drag handle in the lower-right corner of the border
to select more or fewer cells. When you finish updating the references,
press Enter. If the formula is an array formula, press Ctrl+Shift+Enter.
Related tips: |
Copyright 1999-2018 (c) Shyam Pillai. All rights reserved.