Word Wrap Formatting Problems

I apologize if this has been asked before but I've been searching quite a bit and it's kind of hard to know what words to search for.

I want to use Word Wrap and AutoFit Row Height but it's causing me lots of problems. I have a fixed column width and I want to fit a certain amount of text in it. On my computer when I'm editing the cells in normal view, it looks good. But when I try to export as PDF (or use print preview to see what it would look like), the text takes up less lines than it does in normal view and I'm left with a blank line of text that I don't know how to get rid of. I also have hundreds of lines of this so editing each one is out of the question and it also wouldn't look uniform. An example is attached.

Any help would be greatly appreciated.

Hmm... here's the first thing I'd do.

1) Click the little box between "1" and "A" in the upper left-hand corner of the sheet. This should highlight everything.

2) Hover the mouse pointer over the divider line between two rows. It should change to a bar icon with an arrow sticking out above and below the bar.

3) Double click with that icon.

What this does is force every row down to the default height--unless you have word wrap enabled in your cells, in which case it forces them down to the minimum height that will contain all the text in the cell.

4) Check print preview to see if that fixes it.

If it doesn't, there's something less obvious that needs to be addressed that isn't obvious to me from the example you've kindly provided.

Originally Posted by daniel_gudman

Hmm... here's the first thing I'd do.

1) Click the little box between "1" and "A" in the upper left-hand corner of the sheet. This should highlight everything.

2) Hover the mouse pointer over the divider line between two rows. It should change to a bar icon with an arrow sticking out above and below the bar.

3) Double click with that icon.

What this does is force every row down to the default height--unless you have word wrap enabled in your cells, in which case it forces them down to the minimum height that will contain all the text in the cell.

4) Check print preview to see if that fixes it.

If it doesn't, there's something less obvious that needs to be addressed that isn't obvious to me from the example you've kindly provided.

Originally Posted by shg

In the cells you have shown, the font is 10pt Times New Roman, but the font for style Normal is 11pt Calibri. Change one or the other so that they agree.

Thanks for the replies but unfortunately neither of them seem to work. I hope I'm clear but from the example, what I want is for the 2nd line of text to be right under 1st line. Right now if you click print preview there is an extra line there and I don't know how to get rid of it.

Originally Posted by shg

Once more:

Change the font for style Normal to 10pt Times New Roman, or change the font in the cells of interest to 11pt Calibri.

Either works.

Am I doing something wrong? I still don't think it works. I don't want the text to spill over to the next column because I want to have other text there sorry for not including that in the example. I did what you suggested and this is what I got.

Originally Posted by shg

Yes, you are. You've created a new style, Style 1, instead of changing style Normal.

Do Format > Style, select Normal from the drop-down, select Font, and change it to 10pt Times New Roman.

Still not working

No, shg, your example doesn't work. Expand your text column so that cell B2 (the one ending in "cytoskeleton") is just a little wider than needed. Excel insists on inserting a blank line in the cell even though the text fits on one line. You might have to play with the exact width, but when you're writing a lot of text in a lot of wrapped cells, you run into it constantly.

At least it does this on my setup. Excel 2003, Vista64. Don't know what other Excel options might be relevant. I was hopeful when I saw your post, but found immediately that my Normal style matched the font in the badly wrapped cells. Tried changing Normal to include wrapped so that it would match exactly, but no help. So if this is the key, there's something else involved too. And BTW, I'm using a totally different font.

AFAIK there is no solution for this. Since it was also a big problem in Excel 98, I have little hope that MS has fixed it in the later version, which I dread going to due to their hiding the menus. I would love to find a solution, but this one isn't working.

Edward