MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting certain cells to read only

Posted by CJ on January 04, 2002 6:18 AM

Is there a way of locking certain cells in a spreadsheet so as they cannot be altered and they are read only?

Thanx :o)

Posted by Scott on January 04, 2002 6:35 AM

If you format the cells as locked Format-Cells and then on the Protection Tab, select "Locked". Then when you protect the sheet: Tools-Protection-Protect Sheet, These cells will be locked. You may want to make sure any cells that you want the user to have access to are NOT locked when you protect the sheet.

Posted by lenze on January 04, 2002 6:44 AM

Another way you can do this is through Data Validation. After you have a cell populated with the desired contents, Choose Data Validation and use the Custom option. For the formula enter =""

This will prevent someone from entering data in the cell and does not require the sheet to be protected. This can be particularly useful if you have macros that require the sheet to be unprotected to run