trying to automatic fit large amount of text in cell

R

rp2chil

Hi, I've researched the board and I can't find the correct answer.

We have several users updating a spreadsheet. In one of the cells users
have to enter text that could be up to 1000 characters. Is there a way that
when a user either pastes data or enter text that the columns or rows expand
to automatically fit the text.

Thanks so much

Using Excel 2003 and not a programmer :). Tnx much.
 
Top