How to protect or lock a cell in Excel 2010 for read only access?
Do you want to protect a cell in Excel 2010 by making it read only and not allowing the user to edit it? Here’s a simple tip that lets the do the task.
By Default , all the cells in the worksheet is marked as “Locked” which means when you enable protection , then all the cells are marked as Read-only .
First, Disable the Locked Option on all the cells in the worksheet.
1. Press Ctrl + A and right click to select “Format Cells”.