Step 8 : The Format Cells window pops up. Select Format Cells from the drop-down list, or press the shortcut keys CTRL + 1. Step 7: Go to the Home tab and click the Format option from the Cells group. Step 6: We need to select cell A2 to lock it. Step 4: Select the Protection tab, and check the Locked checkbox. Step 2: Go to the Home tab and click the Format option under the Cells group. Step 1: Press Ctrl + A to select the whole sheet. But, first, we need to follow the steps below to understand how to lock a single cell in Excel. The following image shows cell A2 having a text string. Let us understand the method to lock cells with an example. We can lock cells in excel using the steps mentioned above. Click on the Protect Sheet option from the drop-down list. Once again, go to the Home tab and select Format from the Cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |