Link text box to a cell

S

SM

Hi
I have encountered the common problem that when typing a long paragraph(s)
in a merged cell with text wrap, that after the 1,000th character text wrap
no longer works and you have to hit Alt + Enter after every line. I have the
text that gets entered in one cell on a sheet linked to another cell on
another sheet via the ='Sheet Name'!Cell # formula. Is there any way I could
link a text box instead to the other cell so that I can get around the text
wrap issue?
Thanks
SM
 
T

T. Valko

I'm not sure this will solve your problem but you can try it...

Draw the text box...
With the text box active click in the formula bar and enter the linked cell
address. For example: =A1
 

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

Why wont 'autofit' and 'wrap text' remain in tact? 3
Wrap text in cell 1
Wrapping Text in Merged Cells 4
Why does my text in a cell with wrap text and auto height get cut 4
Text stops wrapping in cell. Tried AutoFit. 1
Wrap text, in an Excel CELL, which is linked to another sheet. 5
Linked cells and text wrap / autofit function 1
Excel Typed text appears in wrong cell 0

Top