Excel 2007 : Bottom Line Getting Cut Off

**Krisp42** · 08-09-2010, 03:43 PM

I keep running into this issue in a spreadsheet that keeps making its way back to me. The bottom line of text in some of the rows is getting cut off when I print. It also appears in print preview and when I PDF the document. I could fix this manually, but there are thousands of rows so you can see why I am trying to avoid this.

The file has no merged cells, none of the cells are anywhere near the character limit, autofit does nothing for this, and I've tried changing the cell alignment among other things in my search to fix this, to no avail.

Many months ago I remember searching and being able to fix this problem with a macro that increased the size of each row by a small about (2 pts or so) and that proved to be a good solution for me--but this time around, I can't find a code that does this, and my old document doesn't seem to have the code anymore--I either didn't save it or erased it for some reason. All of the rows are different sizes so I don't want to change all of the rows to the same height. I just want to increase the space in the cell around the text so it stops cutting off. Is there any way to either increase each row size by a few points, or increase the space between the text and the cell border?

**shg** · 08-09-2010, 04:26 PM

Using an exotic font?

When you PDF, are you embedding fonts?

**Krisp42** · 08-10-2010, 08:57 AM

No, just Times New Roman 10pt. I only seem to have this problem on this file, my other worksheets print and PDF just fine with similar settings.

**pvilla** · 06-14-2013, 03:34 PM

Has anyone found a solution to this issue? i have a user that is experiencing this issue but when i bring the excel spreadsheet to my computer and pick the same printer he is using, i do not have the problem.