JUST UPGRADED NEW COMPUTER AND VERSION OF EXCEL
OPERATING SYSTEM - ME TO X
EXCEL - VER 2002 TO VER 200
MONITORS SIZE REMAINS THE SAME - 20
PROBLEM -
On old computer, I could see approximately 50 rows in a spreadsheet at a time, apparently this was the default because it was true everytime I opened a new workbook
On new computer - I can only see about 25 at a time. I can change each spreadsheet by using zoom, but this is cumbersome. Is there anyway to change this? (it's making me crazy
Any help given will be greatly appreciated
Thanks
Gord Dibben - 23 Apr 2004 22:44 GMT
Nancy
I believe this will be a function of your Windows Display Properties and
resolution.
Right-click on desktop and "Properties".
Work with Themes and Settings.
I would first Save my current settings as a Theme so's I could get back to
them after I screwed up the settings.
Gord Dibben Excel MVP
>JUST UPGRADED NEW COMPUTER AND VERSION OF EXCEL.
>OPERATING SYSTEM - ME TO XP
[quoted text clipped - 5 lines]
>Any help given will be greatly appreciated.
>Thanks
Anders S - 23 Apr 2004 22:52 GMT
Hi Nancy,
Sounds like your screen resolution is to low. Exit all programs and right-click
the desktop area. Choose Properties. Under the tab Settings (or something
similar), there is a setting for the size of the desktop. Increase it to suit.
HTH
Anders Silven
> JUST UPGRADED NEW COMPUTER AND VERSION OF EXCEL.
> OPERATING SYSTEM - ME TO XP
> EXCEL - VER 2002 TO VER 2003
> MONITORS SIZE REMAINS THE SAME - 20"
> PROBLEM -
> On old computer, I could see approximately 50 rows in a spreadsheet at a time, apparently this was the default because it was true everytime I opened a new
workbook.
> On new computer - I can only see about 25 at a time. I can change each spreadsheet by using zoom, but this is cumbersome. Is there anyway to change
this? (it's making me crazy)
> Any help given will be greatly appreciated.
> Thanks
Nancy - 24 Apr 2004 19:36 GMT
You guys are terriffic....problem solved
But, of course, now I've run into something else
Situation -
Home office w/ 2 computers networked
Using Excel 2002, I had no problem retrieving and opening files (thru Excel or Word) from the other computer. Now, Excel 2003 will not allow me to go to my network places to pull up files. I'm not having this problem in any other program, just Excel and Word.
Any ideas
Thanks so much.