What determines collapsing of rows?

  • Thread starter Thread starter wal
  • Start date Start date
W

wal

Excel 2007

I created a workbook and then created another on the basis of the
first. Both contain the same types of data, with one column's cells
containing bulleted lists (with Alt-Enter-type line feeds).

Anyway, one workbook's rows expand and collapse according to the
amount of text in the "deepest" cell in the row. The other workbook's
row height remains constant unless I double cleck on the row-divider.
When I reopen the workbook later, however, the rows all collapse to
the same height, thus hiding much of the contents of the cells.

I can't find what setting I might have changed in one workbook or the
other. Wrap text is checked in all cells in both workbooks. The
settings in Excel Options > Advanced are the same as far as I can see.

Thanks for any help.
 
wal explained on 2/18/2011 :
Excel 2007

I created a workbook and then created another on the basis of the
first. Both contain the same types of data, with one column's cells
containing bulleted lists (with Alt-Enter-type line feeds).

Anyway, one workbook's rows expand and collapse according to the
amount of text in the "deepest" cell in the row. The other workbook's
row height remains constant unless I double cleck on the row-divider.
When I reopen the workbook later, however, the rows all collapse to
the same height, thus hiding much of the contents of the cells.

I can't find what setting I might have changed in one workbook or the
other. Wrap text is checked in all cells in both workbooks. The
settings in Excel Options > Advanced are the same as far as I can see.

Thanks for any help.
Click to expand...

I think what you're looking for is 'AutoFit', which does indeed have
ambiguous behavior under various circumstances. Sometimes, even
double-clicking the row divider doesn't behave like you expect! -Most
annoying...
 
Back
Top