What is the range finder and how do you use it?

A

Angeleyez

In a task based quiz we were asked to use the range finder to determine
whether a value in F4 referred to the value in D4 and E4. After doing so we
were to close the range finder.

I have the Excel2003 textbook and can not locate this action anywhere, not
is is visible in online help.

If anyone could fill me in as to what the range finder is and how to use it,
that would be great, thanks.
 
B

Bernard Liengme

If D4 has a formula that includes F4 (say =F4*4) then when D4 is double
clicked the cell F4 will have a coloured border - range finder. When you
activate another cell the range finder goes away.
best wishes
 
G

Gord Dibben

Maybe?

Tools>Formula Auditing>Trace Precedents

Uses arrows to show which cells are referenced in F4.

Hit "remove all arrows" when done.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the Range Finder? 1
Networkdays with cells yet to be entered (creating nested if) 2
need help on MAX 12
Multiplication problem- Please Help! 8
Email Excel Cell Range using Macro 2
use active cell to determine range 2
using named range in VBA 10
Help on lookup functions 2

Top