How to Lock Cells in Excel

To lock a cell, or multiple cells, in Excel:

1. Go to the Review tab in the top ribbon of Excel.

2. Select the option to Unprotect Sheet (if it says Protect Sheet already, ignore this step).

3. Then go to whichever cell or cells you wish to lock and select them.

4. Go back to the Home tab in that top ribbon with those cell(s) selected, go to the Font section and click the bottom right corner arrow out.

5. Find the Protection tab in the window that pops up, and make sure the box for Locked is checked. Then press OK.

6. Go back to the Review tab and select Protect Sheet. A popup will show, press OK. This will then make the cell(s) you selected locked and unable to be edited.