Excel Protection

  • Thread starter Thread starter David Ball
  • Start date Start date
D

David Ball

Is it possible for me to protect only one column in
Excel? If so please can you tell me how to do it?
 
Select the column you want to unprotect. Click format, cells, click on
protection tab, uncheck the Locked check box. Then protect the sheet. It
will all be locked except for the column you selected.

Dan
 
Sorry....you want only one protected.....just do the opposite, lock the one
column you want protected, unlock everything else, then protect the sheet.
 
Everything is protected in Excel by default, and the protection is off by default. So to
protect something; first unprotect what should't be protected, then turn the protection
on. In this case:

1) Select everything (sqare above "1", Left of "A"). Menu Format > Cells > Protection,
uncheck Locked.
2) Select the column (say "E" column header). Same menu, re-check Locked.
3) Protect the worksheet with menu Tools > Protection > Protect sheet

There are a few things you can't do with protected sheets, no matter how many unlocked
things that's in it. Sorting, filtering, adding/deleting rows and columns, stuff like
that.
 
Back
Top