Auto fit row height for one column
 

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?

Auto fit row height for one column
 

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

On Sun, 13 Sep 2009 16:26:01 -0700, jolowe
wrote:

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?

Auto fit row height for one column
 

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.

jolowe wrote:

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?

--

Dave Peterson

Auto fit row height for one column
 

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.

"Dave Peterson" wrote:

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.

jolowe wrote:

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?

--

Dave Peterson