Perculiar Excel error

[RobertCasey]

Hello. I have constructed a Hazard and Risk Assessment using Excel, and so I have a large table with a lot of small font multiline text in most of the the cells (with wordwrap switched on). However, when the table is printed, the text in many of the cells "strays" slightly over the gridlines into adjacent cells before moving to a newline. With so many cells, this looks quite messy. On screen, everything looks fine so I suspect its something to do with the printer driver (or maybe the fonts) but I can't seem to tweak anything that will solve it. Has anyone else experienced this strange behaviour and if so, do you know how it can be corrected? Thanks.

 

[CajunCenturion]

Are you using a true-type font?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[RobertCasey]

Yes indeed. Should I change to a non-TrueType?

 

[jghrist]

Is your View|Zoom set to less than 100%? This will make the screen spacing different than the print spacing even with true-type fonts.

You might solve your problem by using an indent greater than the default zero in the cell format alignment.

Indent: "Indents cell contents from any edge of the cell, depending on your choice under Horizontal and Vertical. Each increment in the Indent box is equivalent to the width of one character."

 

[BillPSU]

Display fonts and print fonts are somewhat different and is probably your problem.

 

[Denial]

I suspect BillPSU is correct. I have struck this problem with wide, wordwrap-enabled, text-containing cells: I could find no satisfactory way around it. The best I could come up with was to turn wordwrap OFF and insert my own line-breaks (using alt-return). This introduces its own set of problems, including additional tedium when you want to revise the text.