+ Reply to Thread
Results 1 to 3 of 3

How to make a column non editable in excel

  1. #1
    Registered User
    Join Date
    06-30-2016
    Location
    chennai
    MS-Off Ver
    97-2003
    Posts
    2

    How to make a column non editable in excel

    I have a column with unique values in excel and shared in sharepoint, others should not be able to edit that column. How to make that column as non editable?
    Kindly any one help please.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: How to make a column non editable in excel

    Hi,

    Welcome to the forum.

    To make a column non-editable:

    1. Select the whole worksheet, Right Click->Format Cells->Protection, uncheck the "Locked" check box.

    2. Select the column you want to protect, right Click->Format Cells->Protection, select the "Locked" check box.

    3. Review tab->Protect Sheet, select the "Protect worksheet and contents of locked cells" check box and protect the sheet using a password.

  3. #3
    Registered User
    Join Date
    06-30-2016
    Location
    chennai
    MS-Off Ver
    97-2003
    Posts
    2

    Re: How to make a column non editable in excel

    Thanks a lot for your reply

+ 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. make excel website editable for the viewer only
    By ThomasTV in forum Excel General
    Replies: 0
    Last Post: 03-25-2016, 05:16 PM
  2. How to make multiple excel columns as non-editable in multiple Tabs using VBA
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-18-2015, 01:27 AM
  3. Make column editable without deleting the formula
    By sandhya16 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-07-2015, 01:48 PM
  4. Excel 2010 Table - Formula column not editable?
    By outofthehat in forum Excel General
    Replies: 1
    Last Post: 09-25-2012, 03:05 PM
  5. make 2 cells equal and editable
    By mthemanj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2012, 01:24 PM
  6. Macro to make certain fields non editable
    By maximpinto in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2009, 06:15 AM
  7. How do I make editable PDF forms using Excel?
    By Haplo in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-15-2006, 07:15 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