Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Showing Duplicate rows in excel | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |