How to unlock a locked excel cell
- coldplay.xixiOriginal
- 2021-01-15 17:30:19135584browse
How to unlock excel cells: First click "Unprotect Cell" in "Review"; then select the cell, press [Ctrl 1], and uncheck "Lock" in the Protection tab ; Finally, re-protect the worksheet.
The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
Related learning recommendations: excel tutorial
How to unlock excel cells:
1. Locked cells, After the cell is protected, the following prompt will appear when changing the content and cannot be modified.
#2. To unlock, first click "Unprotect Cell" in "Review", as shown in the figure below.
3. Then select the cell, press Ctrl 1, and uncheck "Lock" in the Protection tab, as shown in the figure below.
4. Finally, re-protect the worksheet, as shown in the figure below.
Related free learning recommendations: Programming Video
The above is the detailed content of How to unlock a locked excel cell. For more information, please follow other related articles on the PHP Chinese website!
Related articles
See more- What is the shortcut key to unlock ps
- How to unlock ps layers if they are locked
- What does OEM unlocking mean?
- How pandas reads excel files
- What should I do if excel keeps prompting that the reference is invalid?
- How to count the number of identical items in excel
- Excel search shortcut key is ctrl plus what