+ Reply to Thread
Results 1 to 4 of 4

How Can I Lock the Excel Cell?

  1. #1
    Registered User
    Join Date
    01-09-2016
    Location
    Delhi
    MS-Off Ver
    2007
    Posts
    6

    How Can I Lock the Excel Cell?

    I want to lock the cell A6 in worksheet.

    I just want that user cannot input the value in cell A6...How is that possible???

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: How Can I Lock the Excel Cell?

    Click on the cell > Ctrl+1 > Protection > Locked Should be checked.

    By Default all cells are locked, so you might have to unlock all cells 1st and then lock the one required.

    Then goto the Review Tab, and protect sheet.
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    01-09-2016
    Location
    Delhi
    MS-Off Ver
    2007
    Posts
    6

    Re: How Can I Lock the Excel Cell?

    O my god, Unbelievable.....THANKS VERY MUCH................

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: How Can I Lock the Excel Cell?

    No Problem..

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. lock Excel cell after value is entered!!
    By gr8spot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2015, 09:37 AM
  2. Lock a cell based on value in another cell. Excel for MAC 2011 NOT PC
    By phstol in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-13-2013, 06:29 PM
  3. Replies: 1
    Last Post: 09-12-2013, 10:38 PM
  4. lock cell in excel
    By SUNIL KUMAR SAMAL in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-20-2013, 01:19 AM
  5. Excel 2007 won't lock cell.
    By fhanewbie101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2007, 03:53 PM
  6. How can Excel vba detect if Caps Lock or Num Lock is on?
    By abc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-02-2005, 02:20 AM
  7. [SOLVED] RE: What is Excel hotkey for cell lock, C1 to $c$1
    By Duke Carey in forum Excel General
    Replies: 0
    Last Post: 11-09-2005, 04:20 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