• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

Hopw do you lock ONLY a specific row of cells and ONLY a specific column of cells but leave the rest of the sheet accessible

Created a serial ID column that I would like to lock/protect and hide.  I also would like to lock/protect the header cells.  I tried the help feature but cannot figure it out, can someone elaborate for me please?
0
topgun0621
Asked:
topgun0621
1 Solution
 
Rob HensonFinance AnalystCommented:
The default setting is Locked but the sheet needs to be protected to activate it.

Assuming Excel 2003 but later are similar:

Select the cells that you want accessible.

Open the Format Cell window and choose Protection tab and deselect the Locked tick.

Click OK and then from the Tools menu select Protection > Protect Sheet. Choose what options you want available, (long list at the bottom) and set a password if so required.

Click OK.

Cheers
Rob H
0
 
jppintoCommented:
0
 
Arno KosterCommented:
If you only want to have the id column and some header cells locked, i sugges you select the complete worksheet, unblock it using cell properties, select the id column and block it again, select the header cells and block them again, and finally activate worksheet protection via the menu.
0
 
topgun0621Author Commented:
ok got it thanks robhenson
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now