How to protect and password-protect a Google Sheets worksheet or workbook?

To protect and password-protect a Google Sheets worksheet or workbook, follow these steps:

1. Open the Google Sheets document that you want to protect.
2. Click on the "Data" menu at the top.
3. Select "Protect sheets and ranges" from the drop-down menu.
4. A sidebar will appear on the right side of the screen. Click on the "Set Permissions" button.
5. In the "Set Permissions" window, click on the drop-down menu next to "Range" and select either "Sheet" or "Workbook" to specify the level of protection you want.
   • If you choose "Sheet", you can protect individual sheets within the workbook.
   • If you choose "Workbook", you can protect the entire workbook, including all the sheets.
6. After selecting the level of protection, specify the options as per your needs, such as who can edit, view, or comment on the protected sheets or workbook.
7. To add a password, click on the "Set Password" button.
8. In the "Set Password" window, enter a password in the "New Password" field and re-enter it in the "Confirm Password" field.
9. Click on the "Set" button to set the password.
10. Finally, click on the "Done" button to enable protection and password-protection on the selected sheets or workbook.

Now, whenever someone tries to access or edit the protected sheets or workbook, they will be prompted to enter the password you have set.