Google Sheets is a great online tool for organizing and sharing data. However, there may be times when you need to protect sensitive information from unauthorized access. In such cases, it’s important to password protect and lock your Google Sheets. Here’s how you can do it:

Step 1: Open your Google Sheet and click on “File” on the top left corner of your screen, then click on “Protect sheets and ranges”.

Step 2: Select the range of cells that you want to protect. You can protect the entire sheet, or just specific rows or columns. You can also name the range to make it easier to manage in the future.

Step 3: Select “Set Permissions” and choose the level of access you want to grant to users. You can choose between “Can edit”, “Can comment” or “Can view”. If you want to password-protect the sheet, make sure to choose “Can view”.

Step 4: Enable protection by checking the box under “Protect sheet and range”. If you want to set a password, you can do so by ticking the “Set a password” box and entering a password.

Step 5: Click on “Save”. Your Google Sheet is now protected and locked with a password.

Step 6: To unlock the sheet, simply enter the password you set earlier. If you forget the password, there is no way to recover it, so make sure to keep it in a safe place.

In conclusion, password protecting and locking your Google Sheets is a simple process that can help you keep your sensitive data safe from prying eyes. By following these steps, you can ensure that your information is only accessible to those who need it, while keeping it secure and protected.