Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Birmangirl
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
A 2 line text showing up in the Cell in Excel prints in 1 line Danny Excel Discussion (Misc queries) 6 July 12th 05 08:47 PM
Showing Duplicate rows in excel Jagz Excel Discussion (Misc queries) 3 January 1st 05 10:57 AM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 05:37 PM


All times are GMT +1. The time now is 04:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"