Excel adjust row heights

Microsoft Excel 2007
November 3, 2009 at 07:40:56
Specs: Windows XP
I'm creating a workbook to generate invoices, with an "input" worksheet for people to enter data and an "invoice" worksheet which will be protected so users cannot edit it but is based on the input worksheet and will be used to print the invoice.

The input worksheet will use concatenate and char(10) to produce multi line information in each row which will have a varying number of lines.

The invoice worksheet will display the results from these formulae.

Depending on the invoice to be produced the number of rows used will vary.

I want the invoice to display the rows with heights adjusted to accomodate the number of lines produced and to reduce the height of rows to zero if the row has no information displayed.

With a macro I can hide the rows with no information but have not found a way to automatically adjust the heights of the other rows.

Any suggestions would be appreciated.



See More: Excel adjust row heights

Report •

November 3, 2009 at 07:54:58

How about using Text boxes to hold text.

You can link the contents of a text box to a cell or cells.

Click on a text box frame and enter a cell reference in the formula bar.

e.g., Text in Cell A1
Formula for text box: =A1

Text boxes will wrap text for you and you shouldn't have to worry about hiding rows or adding Char(10) for new lines.

Text boxes can also be set to autosize. Right click text box and select Format Text Box, then alignment Tab.


Report •

November 3, 2009 at 08:46:20
Thanks Humar, text boxes seem to be a good solution, they are one of those features I'd never used before.


Report •

Related Solutions

Ask Question