Question Locked

Excel 2003 Row Height & wrapped text

0 helpful
11 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a couple of spreadsheets created years ago in earlier versions of Excel (I'm now using 2003) that have given me problems with row height.

When the row self adjusts to fit the wrapped text often the height cuts part of the text off (part of a row of text or sometimes rteducing it to one row only.

So I adjust it manually. BUT - if I sort the columns the row heights get screwed up again!

I have been told about merged cells but that doesn't seem to be the problem (the merged cells weren't part of the sort, although they were rows repeated at the top of each page) as I unmerged the one row, resorted and the same thing happened.

Any clues out there??

11 replies

by triathlete1981

are not my expertise, but i'm pretty familiar with exccel 2003. if you're changing the row height, the column width shouldn't change. that should be the same no matter how old your old excel version is.

if the wrapped text cell is cutting off the text at the top of the cell, seems it may be just a matter of adjusting the font size.

and besides, what sort are you talking about? if you're sorting wrapped cells that are all different sized, that's most likely your problem.

you talk first about adjusting cell dimensions and then go into merged cells and sorting.

i don't understand why people don't give their entries a second look before they officially post them.

by colin.hadden

Thank you M Ramirez for your wonderfully helpful and understanding reply. Maybe i should take a course in English so i can match your expertise in helpfulness and understanding.

Maybe i should take a couple of courses so I can match your unrivalled expertise with Excel (except of course for the small matter of older versions - what a wonderful admission that was!).

Yes i talked about dimensions (adjusting the height of a row manually to read all the text).

Yes I talked about merged cells (I was told that if there is a merged cell in the row or column that was affected that could be the reason.

Yes I am sorting a column with "different sized" rows (that's what you get if you have wrapped text don't you?????).

Yes I did read my post, and when it was posted it reflected the level of understanding I had of this matter (I wonder how Homer Simpson would word a post about the Theory of Relativity - Combined, of course).

The general idea is that I have columns with different amounts of text in each cell, hence the text in some rows needs to be wrapped as I cannot make the columns/cells wide enough. When I sort the new entries to interleave them into their correct place the row height doesn't travel with them, resulting in part of the text from the top down, not the side in - (silly me I should have realised that with wrapped text it would cut it off from the side!) being cut off so that instead of, say 3 lines of text I canonly see 2.5 or 1 or whatever.

Clear? I certainly hope so - I don't want to offend your sensibilities, great one.

by colin.hadden

Thnak you for that. I came across that problem early and corrected for it.

by jim

Did you ever get an answer?

by thumbsup2

The problem is that when you sort cells of different height, the data moves to the new row, but the formatting does not. Likewise, if you sort left to right. Formatting does not travel with the sort.

The only solution is to turn off word wrap, auto-fit the columns and rows to whatever width and height they need to be, do the sort, then go manually format the cells that you want to wrap.

It can all be done by creating macros, if you're so inclined.

by locolobo

you format all the cells in a column to wrap? Would that work?

by colin.hadden

Nope, no reply that worked although Thumbsup2 in the next post gives a hint.

Off to work out how to construct a macro.

Thanks.

by thumbsup2

For me, formatting all of the cells in a column to wrap will only work if all the cells happen to be already wrapped and are all the same height before the sort happens.

Otherwise, say I have one cell with 43 characters wrapped to two lines (so the line height fits two lines) and one cell which only contains 24 characters and doesn't need to wrap (so the line height fits 1 line). When I sort, the wide data inevitably gets moved to a row that didn't need to be 2 lines high prior to the sort. So, it ends up being partially hidden and needs to be autofit again.

Now, I must say that 2003 is "supposed" to be smart. So, if you set ALL of the cells in a column to wrap and highlight all rows and format them to "autofit height", the danged thing is SUPPOSED to autofit the row height to whatever data gets thrown into those wrapped cells after the sort. And, it seems to work just fine on my computer, for a NEW, unsaved spreadsheet. I can't make it fail, no matter what I do.

The problem seems to come when I'm working on a spreadsheet created in an earlier version of Excel or one that has been created in 2003 and saved as a backwards compatible version. It then acts as if it's just plain dumb! ;)

So, perhaps this is his/her problem. Maybe the spreadsheet just needs to be recreated as a new one and the formatting fixed. The first poster DID say they were working on a spreadsheet created long ago.

This discussion is closed to new replies.