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

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
 
G

Gord Dibben

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
 
G

Guest

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.
 
G

Gord Dibben

Is the target cell/row set to Autofit?

Is the target cell a merged cell?

Merged cells will not Autofit without event code.


Gord
 
G

Guest

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

Other cells in that row have merged cells.

Di
 
G

Gord Dibben

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
 

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

Similar Threads

Link text box to a cell 1
format a linked cell 3
Linked cells and text wrap / autofit function 1
Renaming an excel file that is Linked. 5
Why wont 'autofit' and 'wrap text' remain in tact? 3
Wrap text in cell 1
Disable automatic text wrap? 2
Why does my text in a cell with wrap text and auto height get cut 4

Top