Excel printing problem


G

Guest

Recently I was working on an Excel file with over 15 worksheets (from
different contributors).
I encountered problem with the print preview and actual printing: the image
shown on the computer screen and then on Print preview (subsequently on the
printed documents) was so different.

After I finished with checking my data, I adjusted the column widths and row
heights on all worksheets, set page margin etc... so they could be printed
nicely.
But when I switched to print preview, all rows and columns got screwed up,
some text in a single line in the cell were cut off, while other text were
shown to be squeezed upward.
I closed print preview and switched back to the Excel worksheet, everything
looks fine.

It did not happen to all worksheets, only some worksheets went like this,
others were doing what they are supposed to do, they print nicely.
Is there a option button that I could select so all worksheets could have
nice print out, i.e. the same as the worksheet view.

Winnie Fan
 
Ad

Advertisements

G

Guest

Winnie -

I suspect that your different sheets are using different fonts - fonts that
aren't the same as the workbook's Standard or Normal font.

On the menu, go to Tools |Options & look at the General tab. You'll see the
Standard font. Make sure all the cells on all the sheets use the Standard
font and what you see on screen will be LOTS closer to what what prints out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel printing problem(..) 3
Excel printing problem 1
Printing problem in Excel 1
excel printing problem 3
Excel printing problem 1
Excel printing problem 1
Printing problems in excel 1
Excel Printing Problem 4

Top