In that menu, select “format cells.”.

Lock selected cells in excel 2013. To lock cells for editing: The next image depicts the data having items and the. 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. On the review tab > protect sheet. On the home tab, click the format cell font popup launcher.

Supposing you need to lock cell a3 and a5 in current worksheet, the following vba code will help you achieve it without protecting the whole worksheet. Select the cells in the spreadsheet that you want to unlock. Here, we will restrict data entry in an excel cell only to decimal numbers.

In the first step, click the. Place a checkmark in the box next to the option labeled locked. 6. Lock selected cells with the common sail countersign.

On the home tab, in the cells group, click format, and then click format cells. Get instant live expert help on i need help. Here is an example below:

2.format cells can be selected by right. To lock cells for editing: After the format cells window opens, press on the protection option, and.