MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protecting cells

Posted by Ellie on February 06, 2002 8:41 AM

I am creating an Excel spreadsheet. I want to have the title and column headings protected from the end user changing them. How do I just protect a certain number of cells without doing the entire worksheet??

Posted by Jacob on February 06, 2002 8:45 AM

Data Validation can do this NT

Posted by Mudface on February 06, 2002 8:50 AM

Re: Data Validation can do this NT

Select all the cells that will be used in your workbook. Click on Format-Cells-Protection and uncheck the Locked option. Select the cells you want to protect- Format-Cells-Protection, select the Locked option. Then click on Tools-Protection-Protect Sheet, enter a password if you want.