Skip to main content
Participating Frequently
May 9, 2008
Question

Columns in Excel spreadsheet cut off on pdf

  • May 9, 2008
  • 13 replies
  • 95302 views
I'm using Adobe Acrobat Standard 7.0.9 and Excel 2003 SP3. The last few characters on one of the columns on the spreadsheet are cut off once converted to pdf. It looks fine on the spreadsheet in the print view, etc., but it changes once converted. It even expands to add a word that is on the next line on the spreadsheet, but cuts off the last couple of characters. I've tried formatting the column to Auto Fit or to fixed width with the same result. I have the rows set to Auto Fit so that the words wrap. But even when I change that to fixed, it does the same thing.

Please help - I've got a client wanting a dozen invoices out today and I just discovered this problem!
This topic has been closed for replies.

13 replies

Inspiring
May 10, 2008
What I was trying to point out was that you are likely looking at an Excel issue. I am not saying Acrobat may not be an issue, but in many cases it is an issue of either being sure that the proper printer is selected while you are checking things out (MS Office products and most similar products reflow the document for a best print out). In other cases, Acrobat gets blamed for changing things that are actually a setting in the application, not Acrobat. Look to both sides of the issue to be sure things are working correctly. Since you indicate you are seeing the same thing in Excel, that suggests an Excel issue. In general, if the print preview looks the same as the PDF, the problem is in the applications, not Acrobat. Bill
Participating Frequently
May 9, 2008
Hey Bill, thanks so much for the quick reply! But doing what you suggested only resulted in creating a pdf that had the same problem.

But in looking at some other answers, they said to check the print settings to make sure page setup of both the Excel document and Adobe was set for 600 dpi. Then I discovered that the print settings had it adjusting the scaling to 74%, even though I hadn't specified that originally. It printed hard copy too small with that, so I changed it to 100%. Of course then, I had to adjust the columns' widths.

In any case, once I did all that, it fixed the cutting off part of the column problem. However, I noticed another glitch after that - on some rows it would place an extra blank line at the end - both in Excel and on pdf. I made sure I had all rows set to Auto Fit, and still can't figure out why some rows do that and others don't. Aargg - it's always something!

If you have further wisdom, I'd love to hear it.

Thanks a bunch,
Malia
Inspiring
May 9, 2008
Change the printer to the Adobe PDF printer and then use the print view again. Your print view as probably for your paper printer and when you printed to a PDF, Excel reflowed the document and caused the problem.