MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protection


Posted by Lori Flynn on January 31, 2002 7:44 AM

Is there a way in excel to protect a spreadsheet in such a way that will allow input on certain cells but disallow any formatting changes like adding rows & columns or unhiding rows & columns?

Thanks.


Posted by JohnG on January 31, 2002 7:50 AM

Select the cells that you want to enter data in and right click, select protection and deselect lock. next go to tools and select Protection, Protect worksheets.