Wrap text, in an Excel CELL, which is linked to another sheet.
 

Can I wrap text and autoexpand a cell that is linked to another excel sheet?
I can do it when not linked.
Di
Thank You

Wrap text, in an Excel CELL, which is linked to another sheet.
 

Yes.

What happened when you tried?

What is in the cell that you are linked to on the other sheet.


Gord Dibben MS Excel MVP


On Fri, 10 Aug 2007 21:02:00 -0700, dls25
wrote:

Can I wrap text and autoexpand a cell that is linked to another excel sheet?
I can do it when not linked.
Di
Thank You

Wrap text, in an Excel CELL, which is linked to another sheet.
 

I generate a report from ACCESS to excel. I have many columns, one is named
Comments, some times the comment is longer than what i have room (for in the
second sheet) . This is linked to a report that charts numbers and other
information.
It puts the comment in and wraps text, but will not auto expand. I need it
to auto expand.

"Gord Dibben" wrote:

Yes.

What happened when you tried?

What is in the cell that you are linked to on the other sheet.


Gord Dibben MS Excel MVP


On Fri, 10 Aug 2007 21:02:00 -0700, dls25
wrote:

Can I wrap text and autoexpand a cell that is linked to another excel sheet?
I can do it when not linked.
Di
Thank You

Wrap text, in an Excel CELL, which is linked to another sheet.
 

Is the target cell/row set to Autofit?

Is the target cell a merged cell?

Merged cells will not Autofit without event code.


Gord

On Sat, 11 Aug 2007 06:06:03 -0700, dls25
wrote:

I generate a report from ACCESS to excel. I have many columns, one is named
Comments, some times the comment is longer than what i have room (for in the
second sheet) . This is linked to a report that charts numbers and other
information.
It puts the comment in and wraps text, but will not auto expand. I need it
to auto expand.

"Gord Dibben" wrote:

Yes.

What happened when you tried?

What is in the cell that you are linked to on the other sheet.


Gord Dibben MS Excel MVP


On Fri, 10 Aug 2007 21:02:00 -0700, dls25
wrote:

Can I wrap text and autoexpand a cell that is linked to another excel sheet?
I can do it when not linked.
Di
Thank You

Wrap text, in an Excel CELL, which is linked to another sheet.
 

The cells that i want to wrap text and auto fit, are set.

Other cells in that row have merged cells.

Di

"Gord Dibben" wrote:

Is the target cell/row set to Autofit?

Is the target cell a merged cell?

Merged cells will not Autofit without event code.


Gord

On Sat, 11 Aug 2007 06:06:03 -0700, dls25
wrote:

I generate a report from ACCESS to excel. I have many columns, one is named
Comments, some times the comment is longer than what i have room (for in the
second sheet) . This is linked to a report that charts numbers and other
information.
It puts the comment in and wraps text, but will not auto expand. I need it
to auto expand.

"Gord Dibben" wrote:

Yes.

What happened when you tried?

What is in the cell that you are linked to on the other sheet.


Gord Dibben MS Excel MVP


On Fri, 10 Aug 2007 21:02:00 -0700, dls25
wrote:

Can I wrap text and autoexpand a cell that is linked to another excel sheet?
I can do it when not linked.
Di
Thank You

Wrap text, in an Excel CELL, which is linked to another sheet.
 

Unfortunately the merged cells in the row seem to override the autofit for the
entire row.

Dump the merged cells and make life much easier and less stressful.

Or see this google thread.

http://tinyurl.com/2netq8


Gord

On Sat, 11 Aug 2007 12:28:01 -0700, dls25
wrote:

The cells that i want to wrap text and auto fit, are set.

Other cells in that row have merged cells.

Di

"Gord Dibben" wrote:

Is the target cell/row set to Autofit?

Is the target cell a merged cell?

Merged cells will not Autofit without event code.


Gord

On Sat, 11 Aug 2007 06:06:03 -0700, dls25
wrote:

I generate a report from ACCESS to excel. I have many columns, one is named
Comments, some times the comment is longer than what i have room (for in the
second sheet) . This is linked to a report that charts numbers and other
information.
It puts the comment in and wraps text, but will not auto expand. I need it
to auto expand.

"Gord Dibben" wrote:

Yes.

What happened when you tried?

What is in the cell that you are linked to on the other sheet.


Gord Dibben MS Excel MVP


On Fri, 10 Aug 2007 21:02:00 -0700, dls25
wrote:

Can I wrap text and autoexpand a cell that is linked to another excel sheet?
I can do it when not linked.
Di
Thank You