Firstly, open the data validation dialogue box like the previous.

Lock selected cells in excel 2013. In the “format cells” box, click the “protection”. Protect the sheet lastly.just select all cells. Let’s see the steps to do this:

To lock cells for editing: In the first step, click the. Type a password, and make sure that protect worksheet and contents of locked cells is selected.

To do this, select all of the rows and columns in your sheet. Lock selected cells with the common sail password; 1.unlock all cells in excel before locking any particular ones.

Select the whole worksheet by clicking the select all button. Type a password, and make sure that protect worksheet and contents of locked cells is selected. Select the cells in the spreadsheet that you want to unlock.

Press ctrl + a or click the select all button to select the entire sheet. In that menu, select “format cells.”. Lock selected cells with the common sail countersign.

Here, we will restrict data entry in an excel cell only to decimal numbers. This will select only the cells that contain formulas. On the protection tab, clear the locked check.