If you discover that a formula includes an incorrect cell or range reference, use the Range
Finder to add or remove cells from the reference, or to select a completely different group
of cells. Click the color-coded border on any cell edge to move the reference to a different
cell; click and drag the square handle in any corner of the colored border to extend the
selection. To record your changes, press Enter or click the green Enter Formula button next
to the formula bar.
Using Goal Seek to Find Values
After you’ve constructed a worksheet and built several intricate formulas, you might dis-
cover that you can’t easily ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.