+ Reply to Thread
Results 1 to 3 of 3

Make a column/row read only

  1. #1
    Registered User
    Join Date
    09-09-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Make a column/row read only

    Hi,

    Can someone help me in making a particular column or "n"number of columns/rows read only in a worksheet.

    Regards,
    Lavina

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Make a column/row read only

    take follwing steps

    select worksheet
    right click and select format cell and in protection tab uncheck "Locked"

    then select required column
    right click and select format cell and in protection tab check "Locked"

    then in protect sheet check "select unlocked cells" and unselect all other options
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  3. #3
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Make a column/row read only

    your could locked any row(s) and column(s) or cells seperatly or jointly and locked cells will be read only after protection

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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