Excel Help is your friend:

"Change the row height to fit the contents:
- Select the row or rows that you want to change.
- Point to Row on the Format menu, and then click AutoFit."

Joerg

"Boise Pete" <Boise wrote in message
...
I am working with Excel 2000 and want to know if anyone has figured out how
to compress all rows in the spreadsheet so there are no apparent blank
lines
in any row. The spreadsheet contains cells with wrapped text of different
sizes (# of characters varies from one row to the next so you can't just
set
a fixed row height).

Does anyone know a command that will optimize row heights for a
spreadsheet
in Excel 2000?

Thanks.