Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2006

Tip: Looking for answers? Try searching our database.

Amazing 40% rule

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sri - 06 Sep 2006 16:03 GMT
Hello All,

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?

Thanks

Regards

Sri
Jef Gorbach - 06 Sep 2006 17:16 GMT
> 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
Debra Dalgleish - 06 Sep 2006 17:51 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.