format cells so they do not resize
 

I created a order form and I do not want sales as they are typing to have the
cells or form expand. Freeze the cells at teh exact size they are now if the
test is longer they will have to put in a different info.

Example

Custoemr name field/cell do not want this cell to wrap or get larger.

Can rows and colums be locked so they do not move and they can still enter
in the fields created?

format cells so they do not resize
 

Maybe DataValidation to limit text length along with protection of the
worksheet except for the input cells.

Make sure that users can only select "unlocked cell" but no other functions.


Gord Dibben MS Excel MVP

On Thu, 17 Jan 2008 15:57:02 -0800, Cindy
wrote:

I created a order form and I do not want sales as they are typing to have the
cells or form expand. Freeze the cells at teh exact size they are now if the
test is longer they will have to put in a different info.

Example

Custoemr name field/cell do not want this cell to wrap or get larger.

Can rows and colums be locked so they do not move and they can still enter
in the fields created?