Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2011-05-12
Medium Priority
Last Modified: 2012-05-11
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?
Question by:topgun0621
LVL 34

Accepted Solution

Rob Henson earned 2000 total points
ID: 35746551
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.

Rob H
LVL 33

Expert Comment

ID: 35746634
LVL 19

Expert Comment

by:Arno Koster
ID: 35746819
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.

Author Comment

ID: 35747213
ok got it thanks robhenson

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question