Compressing row heights for a spreadsheet with wrapped text

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.
 
J

Joerg Mochikun

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
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top