Columns in Excel spreadsheet cut off on pdf

We have a similar issue with printing being cut off.

We use Autocad products and when we send a drawing to other people, we use the following procedure:

plot to "Adobe PDF",
customize our settings for paper size, orientation, etc., and create a PDF. In the preview, everything is great. But.......

When we print it using our large size plotter, it cuts off about 1/3 of the drawing. This is not an isolated issue. It does it every time with our PDF's as well as ones sent to us by other people.

Thanks for any help....

It had previously been at 600 dpi for both Excel and Adobe. I tried 300 dpi and it didn't change anything on the spreadsheet. And looking at it in print view it not only still gives me an unwanted blank line, it actually seems to change the column width - or at least the place where it wraps is different. And it still gives me the blank line.

And in print view, it stretches out to add another word to the row. This is enough to drive me nuts (or nuttier than I already am). I'm usually pretty good about figuring this stuff out, but this has me completely stumped. I'm guessing it has to do with setting the rows to auto fit, but it has to be that way beause rows have differing amounts of text in them.

prior to either printing to pdf or using the pdfmaker, go to file>page setup and lower the quality setting to 300 dpi or so. Repeat for each worksheet in the book.

Then create the pdf again.

If you select the Adobe PDF printer (I did not say to print, just select), you can then preview and also see the layout in Excel of how the document will print. It is important with OFFICE products to have the printer selected as you edit a document if the layout for printing is important (this is an OFFICE feature, not Acrobat). Thus the document will flow correctly for the Adobe PDF printer. Adjust the layout in Excel until it is as you need, then print it to the Adobe PDF printer (or use PDF Maker). If you have a different printer selected as you edit and then print to the Adobe PDF printer, the output may be different than during editing (including bookmarks locations and such if PDF Maker is used).

I am just trying to explain the process so that you can layout what you want so it will print correctly to a PDF. Just as a repeat, this is an Excel issue and that is where it needs to be fixed. You should have seen the same messed up results when you select a print preview in Excel (with the Adobe PDF printer selected). That would be the key to tell you it is an Excel layout problem.

But when I do that, it simply creates the pdf with all the screwed up lines. Am I doing it wrong?

If you want to see how it will look on print out, be sure that you select the Adobe PDF printer and then go back to the edit. That will cause Excel to reflow the document so it should appear as it will print.

Thanks for the tip - I have been playing around with the column width and still notice weird stuff. I do see that by adjusting a smig that it does delete the extra line in the regular worksheet view. But then when I go to Print Preview or convert to pdf, that blank line shows up on some of the rows - even though it's not in the regular view. I've made sure it's not a scaling issue on Page Setup and have checked all other settings in both Excel and Acrobat, but still can't figure it out. Why wouldn't it show me in Print Preview the same column widths, etc. that I have set up on the worksheet? Arrg!

I really appreciate all answers and suggestions...

Malia,
Increase the width of your columns by just a smig and the blank line should disappear. Excel is text wrapping something we can't see. This has worked for me. :^)

That makes total sense, but I don't really care about blame - I was just trying to figure out how to fix the problem I had so I could get a dozen invoices out today for a new client. There's so much I don't understand about both Excel and Acrobat, but I thought this was a good place to start to get help. And I was right. That deal about changing the dpi to 600 on both applications seemed to be the thing that worked and I certainly don't understand that!

Oh well, the invoices are out and I still have a lot to learn...I still haven't figured out what the deal is with that blank line on some of the rows.
Thanks again, Malia