I'm using Excel 2010 to print a sort of diary of my daily activities for work. Oftentimes I need to include more than one line of text per cell. It looks fine on my screen as I'm typing and it also looks correct on the print preview screen, but when it actually comes out of the printer, the bottom line of text in each cell is often crowded and sometimes letters like "y" and "g" have their "tails" cut off. The more lines of text I have per cell, the more crowded it gets, but even in cells with only one word, the bottom edge of the cell is right at the bottom edge of the text.

Things I've already tried that haven't helped:

* The text is already aligned to the top of the cell. Changing it to align to the middle or bottom doesn't change anything.
* I can't figure out how to adjust the cell padding, but there's a reasonable amount of space between the top of the cell and the bottom, and the text is top-aligned, so I doubt this is what's wrong.
* The cells are already resizing to fit the text, but I tried Format/AutoFit Row Height anyway. It didn't make a bit of difference.
* Reducing or eliminating a visible border around the cells made no difference.
* Changing the font made no difference.
* Setting or not setting the print area has no effect.
* It doesn't matter whether Page Setup is set to "adjust to 100% of normal size" or "fit to 1 page wide by 1 page tall" (assuming what I'm trying to print should fit on one page).
* I've changed the top and bottom margins and inserted manual page breaks to try to give the cells more room to spread out on the page, but they didn't.
* The obvious solution, adding a hard return at the bottom of each cell, works to keep the text from getting cut off but wastes space and is distracting.
* I've tried starting from a new spreadsheet, using a different printer, and having someone from another computer print for me. I know the equipment is capable of printing a spreadsheet correctly because I also use Excel for our monthly scheduling calendar. I created the schedule from scratch and it took a lot of tweaking to get it the way I wanted, so I have a reasonable grasp of the most basic skills here.

Attached is a picture of what I'm talking about. I printed the page out and scanned it. (Again, it looks fine in Excel. The two blank spaces in the middle of a line are where I erased someone's name.) It's most noticeable in the cells that have 3 lines of text. In cells that have 4+ lines of text (which I don't have to do often) it actually cuts part of the bottom line off; once it was so bad the words were actually sliced in half with the lower half completely missing. As for the reason I'm doing this in Excel instead of Word, I'm typing in the time I clock in and out each day and using formulas to calculate the number of hours I work daily and sum up my total hours for the week.


Attachment 416958