protecting specific columns in a worksheet

  • Thread starter Thread starter Polochilde
  • Start date Start date
P

Polochilde

How can I protect two columns in a sheet. Eg. I could enter data in any cell
except in the cells of colums K and M.
 
Polochilde said:
How can I protect two columns in a sheet. Eg. I could enter data in any
cell
except in the cells of colums K and M.
Click to expand...

You need to lock the cells. How you do that depends on the version of Excel
you have - press F1 and read the help file for 'lock cells'
 
Select the whole worksheet ( Ctrl A )
Format menu ( Ctrl 1)
Protection tab> uncheck "lock" OK
Select columns K and M
Ctrl 1
Protection tab
CHECK " lock " OK
Protect whole worksheet :
tools>protection>protect sheet and
choose a password, password again > OK
 

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

Method for protecting cells which still allows quick editing 2
hide, unhide column or row after protect worksheet 4
protect worksheet but allow users to use specific columns/cells 1
Code to format cells on several worksheets 2
Sheet Protection 3
Password Protect Specific Range Of Cells 6
Protected Worksheet Tab Order 1
sorting 4

Back
Top