format cells so they do not resize

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cindy - 17 Jan 2008 23:57 GMT

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?

Reply to this Message

Gord Dibben - 18 Jan 2008 00:54 GMT

Maybe Data>Validation 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

>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
[quoted text clipped - 6 lines]
>Can rows and colums be locked so they do not move and they can still enter
>in the fields created?

Reply to this Message