To lock cells in Microsoft Excel, follow the methods below. A Format Cells dialog box is open. In the dialog box, click the Protection tab. On the Protection tab page, check if the lock checkbox is ...

Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...