Auto fit row height for one column

J

jolowe

I have a form that in columns A through O, the rows, are set to a specific
height. The last column on the form (L) is used to add notes on the patient.
The rows in this column need to expand (wrap) according to the amount of
information that needs to be added. Is there any way to expand a row in just
one column? If the entire row (A/O) expands it destoys the form and makes it
too large to fit on one sheet of paper (this is a must). I hope there is a
solution to this problem - I have tried everything I can think of, but if I
auto fit I have the row expantion problem and if I set the height you can not
read the entire note. Please can anyone help or is this impossible?
 
G

Gord Dibben

Column widths and row heights are the properties of the entire column or
row.

So................no, you cannot.

I hesitate to mention but merged cells may be an answer.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

You could merge cells (like L1:L2) so that it looks like one large cell, but I
bet that wouldn't do what you want--and working with merged cells is really a
pain.

How about adding a textbox from either the Drawing toolbar or from the control
toolbox toolbar and let it float over the cells you want.
 
J

jolowe

Thank you so much - I am working with your idea and I think I can make it
work. It never entered my mind to go "outside the box" with this problem.
What a great idea! Thanks again and have a good evening.
 

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