Automatic Cell Re-sizing

[Tappie]

I have created a spreadsheet that is to be completed by
several people.

Some of the cells in the spreadsheet are protected appart
rom the ones to be completed by the users. On those
cells 'Wrap Text' is enabled, is it possible to make those
cells re-size automatically when they type to much text to
fit in the viewable area ?

Any help would be much appreciated....

Thanks

Tappie

 

[Jim Rech]

If you're saying that you have unlocked cells with Wrap Text set then, as
long as they are not merged cells and you haven't manually adjusted the
cell's row height, their row heights should adjust automatically as entries
are made.

If you have manually changed the row heights that turns off auto fitting
since Excel assumes you want a specific height. To get back auto fitting
use Format, Row, Autofit.

--
Jim Rech
Excel MVP
|I have created a spreadsheet that is to be completed by
| several people.
|
| Some of the cells in the spreadsheet are protected appart
| rom the ones to be completed by the users. On those
| cells 'Wrap Text' is enabled, is it possible to make those
| cells re-size automatically when they type to much text to
| fit in the viewable area ?
|
| Any help would be much appreciated....
|
| Thanks
|
| Tappie
|