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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Is the target cell/row set to Autofit?

Is the target cell a merged cell?

Merged cells will not Autofit without event code.


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

Other cells in that row have merged cells.

Di
 
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
 
Back
Top