Monday, September 10, 2012

How To Lock Selected Cells in MS Excel 2010

Some of us wanted to lock some selected cells in MS Excel in order to protect formula and other data that if edited would jeopardize the integrity of the document. Here are the steps to lock it.

1. Place the cursor in any cells of the sheet and press "Control A" (all cells are selected).

2. Press right click and select format cells.