Can you lock the value of a cell but not the format?

Excel Discussion in 'Microsoft Office' started by mmfansler, Apr 20, 2017.

  1. mmfansler


    Apr 20, 2017
    Likes Received:
    I am creating a status document. I want to lock the number value in a cell but allow the users to change the color format or fill of the cell. Is this possible?
    mmfansler, Apr 20, 2017
    1. Advertisements

  2. mmfansler

    Becky Webmistress Administrator

    Mar 25, 2003
    Likes Received:
    Yep you can do that. On the ribbon select the Review tab, and then click on Protect Sheet. It will then take you to an option box where you can add a password and specify what you want users to be able to do.

    Welcome to the forum! :)
    Becky, Apr 21, 2017
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.