+ Reply to Thread
Results 1 to 2 of 2

Cell protection

  1. #1
    Forum Contributor
    Join Date
    02-11-2016
    Location
    tanzania
    MS-Off Ver
    2007
    Posts
    319

    Cell protection

    How to insert a password in a single column or single row?

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Cell protection

    You can't, not really.

    What you CAN do is UNlock ALL other cells except the ones you want protected...

    With the sheet UNprotected
    Press CTRL + A to select ALL cells in the sheet
    Format - Cells - Protection - UNcheck "locked"
    Click OK

    Now highlight the cells you DO want to protect (a single column or single row)
    Format - Cells - Protection - Check "Locked"
    Click OK

    Now protect the sheet as usual, making sure to check "select unlocked cells"

+ 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. Cell protection
    By Abhijit2011 in forum Excel General
    Replies: 3
    Last Post: 03-14-2012, 01:05 PM
  2. Excel 2010 - Copying sheet with protection manually, protection stays... not with VBA
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2012, 12:38 PM
  3. Cell Protection
    By squidg in forum Excel General
    Replies: 1
    Last Post: 03-09-2011, 07:50 PM
  4. Cell Protection
    By Wellie in forum Excel General
    Replies: 5
    Last Post: 09-06-2010, 02:47 PM
  5. Cell protection
    By sudheesh.e in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-18-2008, 09:26 AM
  6. [SOLVED] Is this cell protection?
    By DestinySky in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2005, 05:05 PM
  7. Cell Protection
    By Neil_Pattison in forum Excel General
    Replies: 3
    Last Post: 10-03-2005, 04:47 AM
  8. Cell Protection
    By Liz - HADC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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