I have 500 rows of data. All row heights are currently at 15.

For a given column width, I need to wrap the text for about 100 rows to fit
within the column width and make the text visible. Because of this, I need to
increase the row height for these 100 rows to accommodate the type size.

If I use the Auto Fit Row Height feature, it will increase the height of 100
rows to accommodate the type size. It will also, however, decrease the row
height of the remaining 400 rows to fit the type size. I do not want to
decrease the row height of these 400 rows but keep it at 15.

Is there an easy way I can do this without changing the row heights manually?

You don't say whether the rows are adjacent. If they are you should be able
to quickly select them all then format row height and set to your desired
height.
--
Russell Dawson
Excel Student


"Bill" wrote:

I have 500 rows of data. All row heights are currently at 15.

For a given column width, I need to wrap the text for about 100 rows to fit
within the column width and make the text visible. Because of this, I need to
increase the row height for these 100 rows to accommodate the type size.

If I use the Auto Fit Row Height feature, it will increase the height of 100
rows to accommodate the type size. It will also, however, decrease the row
height of the remaining 400 rows to fit the type size. I do not want to
decrease the row height of these 400 rows but keep it at 15.

Is there an easy way I can do this without changing the row heights manually?

Russell:

The 100 rows whose height needs to be increased are not all together
(adjacent). If they were, it would be easy. The 100 rows, whose height needs
to be increased, occur randomly.

Thank you,

Bill




"Russell Dawson" wrote:

You don't say whether the rows are adjacent. If they are you should be able
to quickly select them all then format row height and set to your desired
height.
--
Russell Dawson
Excel Student


"Bill" wrote:

I have 500 rows of data. All row heights are currently at 15.

For a given column width, I need to wrap the text for about 100 rows to fit
within the column width and make the text visible. Because of this, I need to
increase the row height for these 100 rows to accommodate the type size.

If I use the Auto Fit Row Height feature, it will increase the height of 100
rows to accommodate the type size. It will also, however, decrease the row
height of the remaining 400 rows to fit the type size. I do not want to
decrease the row height of these 400 rows but keep it at 15.

Is there an easy way I can do this without changing the row heights manually?