×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Perculiar Excel error

Perculiar Excel error

Perculiar Excel error

(OP)
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.

RE: Perculiar Excel error

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

RE: Perculiar Excel error

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

RE: Perculiar Excel error

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."

RE: Perculiar Excel error

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

RE: Perculiar Excel error

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources