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 / January 2006

Tip: Looking for answers? Try searching our database.

somehow I shrunk my page, going to 8x11/2  wont correct it !

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
badatexcel - 30 Jan 2006 15:31 GMT
in excel somehow I shrunk the page.  Going to 8x11 1/2 letter size wont
change it.
how can I correct it?
David McRitchie - 30 Jan 2006 21:31 GMT
change it,  correct it.   what does that mean?

You haven't described the problem,  what you had,
what you wanted to do,  what you did,  what you got instead.

Possible LastCell problem:
You might use  Ctrl+End  to find where the end of the data is
according to Excel.   If that does not match what you think it is
you might try running macro at (below)  which would fix all worksheets
in the entire workbook at one time.
  Why do my scrollbars go to row 500 -- my data ends in cell E50?, contextures.com, Debra Dalgleish
  http://www.contextures.com/xlfaqApp.html#Unused
Signature

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> in excel somehow I shrunk the page.  Going to 8x11 1/2 letter size wont
> change it.
> how can I correct it?
DavidC - 31 Jan 2006 03:32 GMT
Hi,

Have you reduced the sheet using the zoom function?
Check View\Zoom and see what value is selected, if it is greater than 100%
then you have 'zoomed in'.

Changing the paper size only changes how the sheet prints out not how it
appears on the screen unless you go to print preview.

Hope this helps

DavidC

> in excel somehow I shrunk the page.  Going to 8x11 1/2 letter size wont
> change it.
> how can I correct it?
David McRitchie - 31 Jan 2006 04:53 GMT
Oh,  printing wasn't mentioned,  I think you're on the right track, but I expect the
answer might be      View (menu),  Normal
to change back to normal after using    View, Page Break Preview
where you would see blue page numbers in the middle.

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> Hi,
>
[quoted text clipped - 12 lines]
> > change it.
> > how can I correct it?
DavidC - 31 Jan 2006 05:31 GMT
Good point, never thought of that direction.

DavidC

> Oh,  printing wasn't mentioned,  I think you're on the right track, but I expect the
> answer might be      View (menu),  Normal
[quoted text clipped - 23 lines]
> > > change it.
> > > how can I correct it?
David McRitchie - 31 Jan 2006 05:51 GMT
very much the same direction as your answer, size on display and
nothing to do with printing.

It just highlights the importance of describing what the problem is
and how you know what you get is not what you want,  in other words
as someone I used to work with whenever a someone came in or phoned
up with a programming problem (they always thought it was a compiler problem,
and it never was)  --   I invariably heard him say ---
      "What does it do instead of work"

which usually forced them to describe the problem as they saw it.

> Good point, never thought of that direction.
 
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.