Sorting Changes Row Height

[annacady]

I have a workbook containing 3 worksheets. The first worksheet is an "input sheet" (raw data, a couple of columns of numbers and two columns of text (one of those columns has wrapped text). All cells in the other 2 worksheet are linked to the first worksheet with absolute cell references for printing purposes depending on how the first worksheet is sorted. The input sheet is sorted by either of the first two columns of numbers.

Each time the sort is changed, the column with wrapped text puts extra space in only some of the cells so there is an empty line at the top of those cells. It does not happen in every cell that is wrapped, just in some. Often it happens in a row where the wrapped text cell has very little text and there is no wrapping.

I have checked the input form to see if there are extra spaces in there, but there are not any I can find. I have tried to reformat the errant columns on both the input form and the worksheets with the absolute references but the extra spaces stay. I have gone through and manually adjusted those rows where the height has the empty space, but the next sort, the spaces come back, not always in the same rows. I have formatted with "auto row height". What am I missing?

 

[AnotherHiggins]

That happens when a cell in "pinched" a little to tight. Widen the offending column a smidge (that's a technical term ), then autofit the column*. Now select all rows and autofit the row hight.

The problem is that there is a point where the data is a little too wide for the column, but not wide enough that Excel wraps the text. You wind up with a row that is one increment taller than appears necessary.

*to autofit, you can either go to Format > Row/column > Autofit or just hover your cursor over the line between rows/columns so a line with two arrows appears, then double click.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[annacady]

Thank you thank you. It was so nice to see a global fix instead of row by row each time the sheet was printed.

 

[AnotherHiggins]

Glad to help!


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.