Results 1 to 2 of 2

Locking of Cells with Formulas for editing

Threaded View

shashi.excelcrazy Locking of Cells with... 05-16-2018, 12:09 PM
AliGW Re: Locking of Cells with... 05-16-2018, 12:21 PM
  1. #1
    Registered User
    Join Date
    09-15-2017
    Location
    India
    MS-Off Ver
    2013
    Posts
    5

    Locking of Cells with Formulas for editing

    Hi Everyone,

    I am looking in the attached excel sheet to lock cells with formulas and keep other cells (Which does not have formulas) open for editing.

    When i am locking the cells in the review option complete sheet is getting locked and nothing can be edited. Facing issues with it.

    Steps to do it in excel would be highly appreciated.

    Thanks you guys,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Locking cells to protect formulas only
    By taylorsm in forum Excel General
    Replies: 4
    Last Post: 04-26-2016, 03:53 PM
  2. Locking cells for editing
    By Vokey9 in forum Excel General
    Replies: 1
    Last Post: 03-08-2016, 12:20 PM
  3. locking tables for editing
    By superchew in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-21-2014, 11:29 PM
  4. Locking cells so formulas are never removed
    By boomtown25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2014, 06:36 PM
  5. Replies: 1
    Last Post: 06-21-2012, 07:07 AM
  6. Locking and Editing Cells
    By jmozulay in forum Excel General
    Replies: 0
    Last Post: 10-19-2007, 08:40 AM
  7. Locking Formulas to Cells
    By spartikus in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-22-2006, 01:10 PM

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