creating pdf from excel - cells truncate!

[sadears59@comcast.met]

I'm attempting to create PDF from Excel. The conversion is fine EXCEPT, cells shorten, graphics move up. I never had this issue with Word...or PowerPoint. It's proving difficult. Any idea why this is happening? How to fix it? I've move graphics down more. Sometimes this works, sometimes not. It's probably a simple fix. Really need help. I have 3 other worksheets to do. I've spent ALL DAY (6a.m.-1p.m. so far) trying to make this work on the first worksheet. It's like banging my head against a very hard wall, and while I want to stop because it hurts, I can't.

     Stephanie

[Dov Isaacs · Accepted solution]

Actually, this type of problem occurs to some degree or another will all Microsoft Office applications.

Microsoft typically uses different font metrics and graphics coordinates on screen versus for print (which effectively PDF is). This causes content to shift, line breaks to occur unexpectedly, etc.

Trial and error is probably the only way to “get it right” other than being overly generous in setting cell sizes (heights and widths) in Excel.

          - Dov