+ Reply to Thread
Results 1 to 3 of 3

lock specific cells, not the worksheet

  1. #1
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    lock specific cells, not the worksheet

    I have been trying to lock a set of columns, but not the whole worksheet, and struggling with this, so I only want to lock specific cells within the sheet.

    I only get results of locking the whole sheet even though I choose a range with "allow users to edit ranges" or protect sheet option

    lock.JPG

    locked cells only.JPG

  2. #2
    Forum Contributor jomaor1's Avatar
    Join Date
    10-08-2018
    Location
    Brasil
    MS-Off Ver
    Excel 2016
    Posts
    177

    Re: lock specific cells, not the worksheet

    Hi,

    This will be a little confusing, but here we go:

    First Select all your cells (Ctrl + A), then Right Click, and go to "Format Cells", or just simply click CTRL+1,
    Go to "Protection" Tab and Uncheck the "Locked" Box. Click "OK".

    Select the cells you want to lock, and do the same procedure, but this time check the Locked Box.

    Now you can click Protect Worksheet, or Protect Workbook.
    John.

    "I excel at jumping to conclusions"

  3. #3
    Forum Contributor
    Join Date
    04-01-2015
    Location
    Sydney Australia
    MS-Off Ver
    Office 365 latest
    Posts
    171

    Re: lock specific cells, not the worksheet

    haha! MAGIC, thank you, that worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 05-30-2019, 12:13 PM
  2. [SOLVED] Need to lock specific cells through VBA (Or any other way)
    By anilanilpatni in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-01-2017, 05:03 AM
  3. [SOLVED] How to lock specific cells in the worksheet?
    By GRG Stevan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2015, 05:51 AM
  4. Lock worksheet is specific cell has value over 1M
    By staceynairn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2014, 04:04 AM
  5. Lock Specific cells in a worksheet.
    By excelkeechak in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-02-2009, 11:46 AM
  6. Can I lock cells or do I have to lock the worksheet?
    By jmbtexas in forum Excel General
    Replies: 4
    Last Post: 11-11-2008, 02:26 PM
  7. Can't lock specific cells.
    By manoa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2007, 12:37 PM

Tags for this Thread

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