 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / April 2004Printing Resizing Scaling - Preview - 10% (2)
Hi there, I have the exact same problem as Denis described in his posting in Febuary ( http://groups.google.com.au/groups?dq=&start=50&hl=en&lr=&ie=UTF-8&oe=UTF-8&grou p=microsoft.public.excel.printing&selm=adb601c3ec0e%249912f6c0%24a401280a%40phx. gbl ), where a spreadsheet that can't fit on one page without resizing is previewed at 10% of its original size, the paper appears to be only 10% of its correct size, and Excel spews forth "Margins do not fit page size." Has any solved it? Angus. Hi Angus, (posted in excel.printing with cc to Denis) First thing to do is to check for the last cell Ctrl+End it should be at the intersection of the last used row and the last used column. If it is not there are two macros that I would suggest. The first will usually fix all of the worksheets and do it very fast. The second will reset the last cell on the active sheet to match the active cell and verify that the change took place. Reset All Lastcells in the Active Workbook (#resetall) http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall Making the activecell the LastCell (#MakeLastCell) http://www.mvps.org/dmcritchie/excel/lastcell.htm#makelastcell The above is much more preferable to such things as modifying the print area that sometimes gets suggested but does not fix any underlying problems. The 10% of the pagesize sound like you are Page Break Preview from View, Page Break Preview; and back to normal with View, Normal. Would suggest using the normal Print Preview from File, print preview or from the toolbar icon and back to normal with the Close button at top. From Print Preview you can drag the margins to adjust the margins. You can also set the margins in File, Page Setup, Margins (tab) If you are close to one page, you can force to one page by changing the height and width to one page in File, Page Setup, Page (tab), Fit to 1 pages wide by 1 pages tall. Note these are independent settings you do not have to use both. Such as you can force the width to a number of pages wide and let the length continue depending on the data. You indicated your problem was the same as this link: http://google.com.au/groups?threadm=adb601c3ec0e%249912f6c0%24a401280a%40phx.gbl It's not often that a question goes unanswered but it does happen, so I am sending a copy of this reply to Denis as well as posting in the newsgroup. The printing newsgroup is not one of the most active. I expect that if the question had been posted in excel.misc the response would have been faster, but basically the same people look in several newsgroups so it really seldom makes a difference. This brings up the issue of anonymous and fictitious email because sometimes if a question goes unanswered for weeks an email copy might help the poster in case they gave up. As far as I know everyone here used correct email addresses which I think is far more an advantage than a disadvantage. --- 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 "Angus" <angus_monro@ieee.org> wrote in message > where a spreadsheet that can't fit on one page without resizing is > previewed at 10% of its original size, the paper appears to be only > 10% of its correct size, and Excel spews forth "Margins do not fit > page size." Hi David, thanks for the rapid reply. I think I'd better describe my symptom more accurately, as your diagnosis has been thrown by my shorthand description. Hence, Ctrl+End does indeed take me to the correct cell; I do normally use File|PrintPreview & the Close button to enter & exit the preview mode; and the "Fit to 1p by 1p" is the most reliable way to help reproduce the problem! Such is life ;-). Here's a script that reproduces the problem with 100% reliability on my system, in a pleasantly minimal way: Setup ----- 1. Start Excel 2003 (11.5612.5703) from the Start menu, so that we're working with a fresh workbook. (N.B. my paper size defaults to A4). 2. Put the string "a" in cell J1. Correct Behaviour (this section can be skipped!) ------------------------------------------------ 3. Doing a File|PrintPreview at the point gives the expected result: * the first (blank) page is displayed, filling as much of the application window as possible. * the status bar says "Preview: Page 1 of 2". * scrolling down gives the second page, which merely has 'a' on it. 4. Press the Close button. Incorrect Behaviour ------------------- 5. Go to File|PageSetup, select "Fit to 1 page(s) wide by 1 tall" and press OK. 6. Do a File|PrintPreview. This exhibits the fault: * a blank page is displayed, but now only fills 15% of the application window space that it had previously. * The status bar says "Preview: Page 1 of 24". 7. You can do either of two things at this point: a) press Close, thus voluntarily closing the preview mode. b) press the Page Down key 11 times. On the eleventh time, the preview mode disappears! Either way, Excel then displays a pop-up dialog saying "Margins do not fit page size." 8. Press OK. Undo Incorrect Behaviour ------------------------ 9. If you change the Scaling back to "Adjust to 100% normal size", then the Print Preview behaves again. Thanks for considering the problem. BTW, I don't understand why you felt a need to raise the issue of using correct, non-fictitious, non-anonymous e-mails - did you try mine and have problems? - Angus. Hi Angus, Someone will have to try your script in Excel 2003. I can't reproduce problem in Excel 2000, and I changed the papersize for the worksheet in the new workbook to A4 just to match yours. It should certainly help that you reduced the problem to something that consistently fails for you. I only mentioned the anonymous names because it is something that can occasionally interfere with getting the most out of newsgroups. Besides being faceless. Both you and Denis used your correct email addresses, but it should be apparent that if Denis had not -- he would never have received any kind of answer after the question went unanswered for months and is no longer on the server. BTW, I did try to reply through Google Groups, but there was no option to reply, I guess they don't allow it anymore for old messages. But as far as I know the email went through, so he may find an answer when yours is solved. --- 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 David, > [quoted text clipped - 51 lines] > > - Angus.
|
Reply to this Message |
 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.