Yes - it works! Thank you very much for the tip & help. This will be very
useful.
Regards
Amanda
"*αναγιώτης" wrote:
Hallo,
Sorry, for for the late answer but I just saw your post yesterday, when this
problem came up to me too.:-)
The solution is easy in Excel 2003:
Select any empty cell
Type "="
Click on the upleft corner of your worksheet to select all the cells.
Usually next to "=" will be written 1:65536
Then press ENTER.
Excel will complain ciclular reference.
Click on OK.
Select the cell were is written the above.
Double click on the button "Trace Precedents"
Ups!!! Here are all the arrows!!
--
Η ΜΑΚΕΔΟΝΙΑ ΕΙΝΑΙ ΕΛΛΑΔΑ
"Birmangirl" wrote:
...Is there a quick way to display more than one set of Trace Precedents
arrows in a single worksheet? I can show the precedents one at a time and
turn them off with one command, but I'd like to display selected sets
(without having to repeat the action multiple times) before I email the file
to another user. Is creating a macro the only way?
Thanks in advance
Amanda
|