Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel printing problem
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 |
#2
|
|||
|
|||
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. "Winnie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel ver 10 "Encounters a Problem" on starting | Excel Discussion (Misc queries) | |||
sorting problem in excel 2000 | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
Excel 2000 to Excel 2002 problem | Excel Discussion (Misc queries) |