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

    mmfansler

    Joined:
    Apr 20, 2017
    Likes Received:
    0
    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
    1. Advertisements

  2. mmfansler

    Becky Webmistress Administrator

    Joined:
    Mar 25, 2003
    Likes Received:
    974
    Location:
    Manchester
    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
    #2
    1. Advertisements

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.
Similar Threads
  1. walker_2010
    Replies:
    1
    Views:
    1,054
    andyburgess
    Jul 14, 2005
  2. loupero
    Replies:
    0
    Views:
    475
    loupero
    Feb 6, 2006
  3. devik
    Replies:
    12
    Views:
    89,624
    farha
    Sep 12, 2016
  4. BS6600

    Outlook Outlook 2003 - can send New but can't Reply

    BS6600, May 5, 2009, in forum: Microsoft Office
    Replies:
    5
    Views:
    2,081
    JaLing
    May 7, 2009
  5. Kellyzeroes
    Replies:
    0
    Views:
    1,131
    Kellyzeroes
    Jul 13, 2011
  6. anniek

    Outlook outlook can send but not receive emails

    anniek, Jun 15, 2012, in forum: Microsoft Office
    Replies:
    1
    Views:
    572
    goodfellow
    Jun 15, 2012
  7. Johnnyspa
    Replies:
    2
    Views:
    1,072
    Johnnyspa
    Oct 30, 2012
  8. hakan

    Word Lock specific drop downs on a Word Document

    hakan, Sep 24, 2015, in forum: Microsoft Office
    Replies:
    0
    Views:
    343
    hakan
    Sep 24, 2015
Loading...