Hi,

I think what you want to do is best-fit the row heights. If so try this,
click the top left corner of the spreadsheet, the intersection of the row
numbers and column letters, to select the entire sheet. Put your mouse over
the line between the row numbers 2 and 3, when the mouse becomes a two headed
arrow double-click it.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"Boise Pete" wrote:

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.