XL: Document Displayed/Printed in Unreadable, Compressed Print

ID: Q96255


The information in this article applies to:


SYMPTOMS

In Microsoft Excel, if the print area of your document contains 592 or more rows and if the Fit To option (under Scaling in the Page Setup dialog box) is set to a number of Pages Wide By to reduce the page width, your worksheet may be scaled down 10-percent and the document will be printed and displayed in print preview as a few pages of unreadable, compressed print. This scaling problem occurs if you specify a number of pages Tall in the Fit To option.


STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem does not occur in later versions of Microsoft Excel for Windows.


MORE INFORMATION

In the Page Setup dialog box, under Scaling, you have two available options:


   Reduce/Enlarge To - this option allows you to specify a percentage
   for reducing or enlarging a document. 



   -and- 



   Fit To - this option allows you to compress your document to fit on
   a specified number of pages. For example, if the range you are
   printing is 4 pages wide when the scaling is 100-percent and it
   contains 600 rows, setting the Fit To option to 3 Pages Wide By 30
   Tall will cause the whole sheet to be scaled 10-percent. This
   occurs even though at 100-percent scaling the 600 rows easily fit
   on fewer than 30 pages. 


WORKAROUND

To work around this problem, do one of the following:


REFERENCES

"User's Guide 1," version 4.0, pages 536-538

Additional query words: 4.00a shrinks compress scrunched garbled can't read legible compresses 10 percent per cent fitto fit to


Keywords          : kbprint 
Version           : WINDOWS: 4.0, 4.0a; MACINTOSH: 4.0
Platform          : MACINTOSH WINDOWS 
Issue type        : kbbug 

Last Reviewed: March 30, 1999