Set your column that contains your descriptive text and then format the
column for word wrap. After selecting the cells, right-click on one of the
selected cells, select format cells, and then click on the Alignment tab. In
the Text Control panel click the Word Wrap check box. You may also want to
set the vertical alignment in the cell to top.
--
Kevin Backmann


"greenearth" wrote:

I wish I knew how to ask this - but I just don't know the terminology. I have
been using excel to create estimates and invoices for many years. Also for
many years, I've wished I could create a way for the estimate/contract to
"auto-expand" as I type in row after row of product description - quantity -
unit price - totals and so forth. I want this because there is lots of text
after the product listing, and right now I have to hide rows or add rows
according to my needs. I link the cells on my actual printable estimate to
another series of sheets where I calculate my costs and markup. I've asked
many people over the years how to do this, but no one ever can give me an
answer - though I've seen spreadsheets that work the way I want (I just don't
know how to get in touch with the authors!). I understand this may be a
macro/VBA issue but If someone out there could even just point me in the
right direction I would appreciate it.