DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Identify those cells you want to allow others to edit
|
|
|
Access the Review tab.
|
|
|
Change the workbook to Read-Only status.
|
|
|
Select the Backstage view.
|
Detailed explanation-1: -Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password. In your Excel file, select the worksheet tab that you want to protect.
Detailed explanation-2: -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-3: -Select File > Info. Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK. Confirm the password in the Reenter Password box, and then select OK.