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
 
Top