lock column width

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to lock a column width from other users but still allow them
to type in the cells?
 
KD said:
Is it possible to lock a column width from other users but still allow
them
to type in the cells?
Click to expand...

Sure. Format the cells so they're UNlocked. Then, protect the sheet (Tools,
Protect, etc). If your main concern is klutzes who changes things
accidentally and then say "Duhh.....nah....I didn't touch nuthin'...honest",
you don't need to password protect the sheet - just use the protect thing,
and don't enter a password. Users like that never find their way that deep
into the menus.
 

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

Can you lock the width of a column? 2
Can you lock the column width? 5
Locking column widths 2
How do i lock the column width in Excel? 1
Drop Box Width 3
Worksheet Column Widths Different For Different Users 2
Change Cell Width WITHOUT changing Column width 1
What's new today? 7

Back
Top