How do I expand multiple rows to the correct height?

  • Thread starter Thread starter dennismartinek
  • Start date Start date
D

dennismartinek

On a weekly basis, I have to run some reports that are exported to Exce
2002. While I know how to format a column to justify and wrap text
what I haven't figured out and its driving me nuts, is how to:

Take the 600-1000 rows and have them properly format to each specifi
rows' height, based on the justified text in the formatted column.

I know that I can click on each row individually and have it format th
row height one at a time. I want to highlight ALL of the rows and aut
format them to the correct height, not a predefined height such a
15.00.

Can someone please help me to free up my weekends?

Thank you
 
I want to highlight ALL of the rows and auto
format them to the correct height, not a predefined height such as
15.00.
Click to expand...

What happens if you select the entire sheet (CTRL+A), then Format -- Row --
AutoFit?

HTH,
Andy
 
Andy,

Thank you so, so much!

I knew that there had to be an obvious and easy solution...I have m
weekends back!

I wish I could return the favor, but it appears you know much mor
about Excel than I could ever hope to know!

My best,

Denni
 
<<"I wish I could return the favor">>

I'm sure he would accept any form of libation as return of the favor.
No need to restrict it to XL!

message Andy,

Thank you so, so much!

I knew that there had to be an obvious and easy solution...I have my
weekends back!

I wish I could return the favor, but it appears you know much more
about Excel than I could ever hope to know!

My best,

Dennis
 
Back
Top