Compressing row heights for a spreadsheet with wrapped text

  • Thread starter Thread starter Boise Pete
  • Start date Start date
B

Boise Pete

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.
 
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
 
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.
 
Back
Top