How can I protect cells~?
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How can I protect cells~?

  1. #1
    Guest

    Default

     
    I have a spreadsheet that has cells for numbers to be inputed and cells with formulas to calculate those numbers, I'd like to protect the cells with formulas from accidently being changed, can I lock those particular cells~?
    Thanks for any help~

  2. #2
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    If you select the cells you want the user to be able to change, select format, protection, and uncheck the locked box, then select tools protection to protect the sheet, this will give you the desired result.
    Richard

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com