Compressing row heights for a spreadsheet with wrapped text
 

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.

Compressing row heights for a spreadsheet with wrapped text
 

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.

Compressing row heights for a spreadsheet with wrapped text
 

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.