Office 2003 SP3 on XPSP2
I have a user who has a multi-sheet workbook. Each sheet contains one or
more printable pages and the Page Scaling is set to 100%.
When he prints this workbook, occassionally one or more pages winds up
looking very squished. The data is centered at the top of the page, and each
column is compressed. Between 0 and 2 characters of the column are printed -
no more.
This seems to happen at random and on different pages.
I am puzzled about what could be causing this. Any ideas for troubleshooting
this problem?
I have an example I can send to you.
The top part of the page shows what prints out, and the bottom part of the
page shows what *should* print out.
Some data has been obscured but I think you can see what I mean.
Help!
Thanks,
Jennifer
Bob Flanagan - 08 Feb 2008 04:10 GMT
Try setting a print area on those worksheets. If that solves, most likely
Excel thinks you have an entry way far away from all your cells with
content, and you have fit to one page set on. Another solution is to delete
all the "empty" rows and columns below and to the right of your data. Then
save, close and reopen the workbook.
Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707
Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
> Office 2003 SP3 on XPSP2
>
[quoted text clipped - 23 lines]
> Thanks,
> Jennifer