> Hello All,
>
[quoted text clipped - 9 lines]
>
> Sri
Havent heard of the rule before but did find (2) sites mentioning it:
http://72.14.235.104/search?q=cache:WParWuqbf88J:www.wiseowl.co.uk/microsoft
-excel-training/microsoft-excel-advanced-training.asp+amazing+40%25+rule+exc
el&hl=en&gl=us&ct=clnk&cd=1
http://72.14.235.104/search?q=cache:yzjvihTAPwAJ:www.utteraccess.com/forums/
access/access585626.html+amazing+40%25+rule+excel&hl=en&gl=us&ct=clnk&cd=6
If you set the zoom below 40% you can see the named ranges on a
worksheet. Maybe that's amazing.
> I have recently come across a statement called " The Amazing 40% rule" in
> excel, tried to search in google, but got no information on this yet...
>
> Can anyone help me to understand this? May be a link to the site where its
> explained in detail?

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Sri - 06 Sep 2006 18:18 GMT
Thanks Debra, I thought so, its less than 39%....
but do you have any idea why is this strange thing happenning??

Signature
Regards
Sri
> If you set the zoom below 40% you can see the named ranges on a
> worksheet. Maybe that's amazing.
[quoted text clipped - 4 lines]
> > Can anyone help me to understand this? May be a link to the site where its
> > explained in detail?
Dave Peterson - 06 Sep 2006 18:33 GMT
I'm not Debra, but it's a feature in excel to make your life easier.
> Thanks Debra, I thought so, its less than 39%....
>
[quoted text clipped - 18 lines]
> > Contextures
> > http://www.contextures.com/tiptech.html

Signature
Dave Peterson
Dave Peterson - 06 Sep 2006 18:32 GMT
Could be:
http://www.wiseowl.co.uk/microsoft-excel-training/microsoft-excel-advanced-train
ing.asp
In the "Range names and absolute references" section. So it looks like they
could be writing about range names showing up at less than 40% zoom.
I do like the Outstanding Page Break Preview Mode better, though.
> If you set the zoom below 40% you can see the named ranges on a
> worksheet. Maybe that's amazing.
[quoted text clipped - 9 lines]
> Contextures
> http://www.contextures.com/tiptech.html

Signature
Dave Peterson
Debra Dalgleish - 06 Sep 2006 20:52 GMT
Yeah, I wouldn't really rank it as amazing. But I'm not in marketing, so
what do I know?
> Could be:
>
[quoted text clipped - 18 lines]
>>Contextures
>>http://www.contextures.com/tiptech.html

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Dave Peterson - 06 Sep 2006 21:56 GMT
But you are on Amazon!
> Yeah, I wouldn't really rank it as amazing. But I'm not in marketing, so
> what do I know?
Debra Dalgleish - 06 Sep 2006 22:53 GMT
Hey! Oh, never mind.
> But you are on Amazon!
>
>>Yeah, I wouldn't really rank it as amazing. But I'm not in marketing, so
>>what do I know?

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html