+ Reply to Thread
Results 1 to 2 of 2

Lock cells so content or formula can't be changed

  1. #1
    Registered User
    Join Date
    11-14-2008
    Location
    London
    Posts
    3

    Lock cells so content or formula can't be changed

    Hi Guys,

    How do I lock cells in an excel spreadsheet so no one can change the formula or the contents of that cell?

    Thanks!

    R

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Hi,

    Select the cells or the entire sheet.
    Right click the selected area.
    Select Format Cell.
    Click on last tab (Protection). Make Sure that Locked Check Box is checked.


    Now, Click on Tool --> Protection --> Protect sheet and put password....


    Now no body will be able to see the formula.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1