+ Reply to Thread
Results 1 to 3 of 3

Protecting all the cells in a worksheet that are formulas

  1. #1
    Forum Contributor
    Join Date
    07-25-2008
    Location
    texas
    Posts
    178

    Protecting all the cells in a worksheet that are formulas

    As opposed to clicking on each cell and seeing if its a formual, can I just protect all the cells on a worksheet that contain formulas?
    Last edited by jartzh; 02-17-2012 at 05:05 PM.

  2. #2
    Registered User
    Join Date
    11-06-2011
    Location
    Massachusetts, USA
    MS-Off Ver
    Excel 2010
    Posts
    52

    Re: Protecting all the cells in a worksheet that are formulas

    Yes, that can be done.

    Select the entire sheet, and de-select “Locked” on the Protection tab of Format Cells. Press F5, click Special, select Formulas and OK. Now all the cells with formulas are highlighted. Go back to the Protection tab of Format Cells and select Locked. Turn on protection for the sheet (including a password if you like) and you are all set.

  3. #3
    Forum Contributor
    Join Date
    07-25-2008
    Location
    texas
    Posts
    178

    Re: Protecting all the cells in a worksheet that are formulas

    Thanks Canuck Chuck.
    That did it.

+ 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