USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Select the cell, right-click and select Format Cells. Go to the Protection tab and select/unselect Locked
|
|
|
Select the cell, go to the Review tab and select Lock Cell in the Protect group
|
|
|
Select File, go to Properties in the Info tab and type the cells you want to lock/unlock
|
|
|
This is crazy! You can’t lock or unlock cells.
|
Detailed explanation-1: -Select the cells you want to lock, right-click within the selection and click “Format Cells”. Switch to the Protection tab, check “Locked”, and click “Ok”. Remember that locking cells is not effective until you protect the worksheet. So, go through the processes for protecting the worksheet again.
Detailed explanation-2: -On the worksheet, select just the cells that you want to lock. Bring up the Format Cells popup window again (Ctrl+Shift+F). This time, on the Protection tab, check the Locked box and then click OK.
Detailed explanation-3: -Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.
Detailed explanation-4: -To prevent a user from moving, sizing, or deleting a control, right-click the selection, and then click Format Control. On the Protection tab, select the Locked check box.