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:
Troubleshooting a Long Formula
Using Named Ranges Instead of References

 

Copyright 1999-2018 (c) Shyam Pillai. All rights reserved.