How to Lock and Unlock cells in Excel

http://www.TeachExcel.com
How to prevent data from being deleted from your spreadsheets. How to lock and unlock cells in excel. Also allows for bulletproof forms to be created which can't be accidentally altered.

For more information, macro code, tutorials, and forums go to:

http://www.TeachExcel.com

• Category

  Education

[Tejas Modi]

In 2007/2010:

Select the Review tab.

In the Changes group, click the Protect Sheet button.



[prakash bisht]

PLZ HELP ME, THERE IS NO OPTION IN EXCEL 2007..I MEAN A TOOL

[SIE7EJL]

Thank you, Is there a way to select multiple sheets and protect them all at once? I tried "select all sheets" did the protection on the first one, but the rest were not protected.

[Cornelio Cagara]

thank you for sharing

[Enira Maria]

2003 ROCKS, 2010 SUX

BTW: Thank you!

[Je Wo]

Thank you! You don't know how big of a help you are!

[Diana Paul]

thanks!



[Sunny Batish]

thank you



[TheAGCteam]

I think its doing it like this but when you see the list with "allow selection unlocked cells" etc you have to scroll down and tick on "Sort" to allow them to sort, you may have to stick on a datafilter but I'm not sure.