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 / Printing / February 2008

Tip: Looking for answers? Try searching our database.

Strange Printing Behavior

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jennifer Q - 06 Feb 2008 21:53 GMT
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

Rate this thread:






 
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.