format cells so they do not resize

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

form buttons on sheet collapse on unhide - sometimes 5
Lock checkbox to cell? 3
Automatically resize a cell 3
highlight row of active cell 6
Change cell state with protected sheet 3
Protect Worksheet Macro 2
compare 2 x files with same colum labels but different aranged da 2
auto resizing of cells or rows 3

Back
Top