DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the best way to only protect specified ranges in one sheet?
|
|
Protect Workbook
|
|
|
Protect Sheet
|
|
|
Format
|
|
|
Hide
|
Explanation:
Detailed explanation-1: -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-2: -On the Review tab, click Protect Sheet. In the Allow all users of this worksheet to list, choose the elements that you want users to be able to change. Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box.
There is 1 question to complete.