aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

How to Make Some cells Read only in Excel Sheet and other should be editable

Jun 21, 2010
In Excel sheet we can make some cells read only and some cells editable by using these following steps

1) First Select whole Excel Sheet by Ctrl+A After that

2) Right Click on excel sheet you will find Format Cells Option that screen look like this

 3) Click on Format Cells option you will find one window like this

4) In that window you will find tab menu in that you should click on Protection tab you will find two options

    Locked and Hidden. Here we should uncheck the Locked option and click OK button

5) Now click on particular cell you want to protect, right click on that go to Format Cells Option -> Protection and click on that check the locked option

6) After Completion of that in Home tab right side you will find Format Option like this find the options those are marked with red circle

7) Click on Format Option you will find Protect Sheet Click on that option one small window will open in that check select locked cells and select unlocked cells and if you want lock the cells with password enter password in the textbox .

Like this we can make the some cells read only

i think it help you

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Anonymous said...


Anonymous said...


Anonymous said...

Thank you!

Murali krishna said...

Thank you.

Anonymous said...

Thank you very much.

Anonymous said...

hello Suresh sir how to add vertical line in repeater control???Please help me...

Nikita said...
This comment has been removed by the author.
Nikita said...
This comment has been removed by a blog administrator.
Anonymous said...

Doesn't work. Cells are still editable. Please post full instructions and don't leave anything out.

PatrickDew said...


I've tried the lock cells option but it asks to protect the excel sheet. Is there any way out via VBA?

Thank you

Gaurav Khurana said...

thanks a lot.. it worked just 3 simple steps.. thanks for the explanation

Unknown said...

i really liked this, i has worked for me
i would feel good if u also help me to make a full column readonly

Anonymous said...

Thank you!

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.