Protect the sheet lastly.just select all cells.

Lock selected cells in excel 2013. Select formulas under the go to special window. If prompted, enter the password to unprotect the worksheet. To do this, select all of the rows and columns in your sheet.

Now, go to the format cells dialogue box with shortcut ctrl+1. When the format cells window appears, select the protection tab. On the review tab > protect sheet.

Click on the tab labeled protection. 5. Select the whole worksheet by clicking the select all button. On the review tab > protect sheet.

To lock cells for editing: Do you want to protect the cells of an excel 2013 worksheet from being edited? Firstly, open the data validation dialogue box like the previous.

Let us understand how to lock cells in excel spreadsheet in detail with the following examples: Right click any selected cell, and select the format cell item from the. Here, we will restrict data entry in an excel cell only to decimal numbers.

Select the cells in the spreadsheet that you want to unlock. Right click the sheet tab, and select. Free help available in just 30 seconds.