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
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 31

    Accepted Solution

    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

    LVL 19

    Expert Comment

    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

    ok got it thanks robhenson

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    Outlook Free & Paid Tools
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now