DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How to unlock cells?
|
|
Select cells, Right click, Click format cells, go to Protection tab, check locked cells, check Hidden, then Ok.
|
|
|
Go to Review tab, protect group click on Allow Edit Range, Enter password.
|
|
|
Select cells, Right click, Click format cells, go to Protection tab, Uncheck locked cells, click OK.
|
|
|
Leave formatting as it is, go to Review tab, and Turn on Worksheet Protection
|
Explanation:
Detailed explanation-1: -You can also press Ctrl+Shift+F or Ctrl+1. In the Format Cells popup, in the Protection tab, uncheck the Locked box and then click OK. This unlocks all the cells on the worksheet when you protect the worksheet. Now, you can choose the cells you specifically want to lock.
Detailed explanation-2: -Luckily, there are some shortcuts you can use to quickly lock or unlock cells in Excel. To lock a cell, simply select the cell and press the Ctrl + 1 keys. To unlock a cell, select the cell and press the Ctrl + 2 keys.
There is 1 question to complete.