Create your password after that, when you see your data on the sheet, it will be encrypted. A pop-up window will ask you to create a password.

Then click on encrypt file option from the menu.

Now go to the main menu and click protect file again.

The Authorization request will only appear the first time you encrypt your data.

Click ok on Authorization required pop up window, then click accept.

The first time it will ask permission to access your Google drive to encrypt your document.

Then from the drop-down menu, select encrypt file option.

Go up to the main menu bar and click protect file menu.

Your encrypted URL will appear in the first row of your spreadsheet.

Leave the first two rows empty and start adding your data from the third row.

Click on the protected sheet link, and it will ask you to make a copy of the sheet.

Make it easy by turning data into secure visual reports with Whatagraph.Ĭross-channel visual reports How to Protect Files on Google SheetĬongratulations, you have set up your password-protected Google Sheets it is easier to encrypt your files from now on. Go back to your spreadsheet, and you will see Protect File icon at the top of your spreadsheets' main menu.

At last, when you are finished here, close the window.

The confirmation pops up will appear, select ok.You will see Deploy as a web app, then click on the Deploy.When you see a new row for version 1, click on ok.

From there, click on files, then select Manage Versions and click on Save a new version.

It will open up a script in a new window.

Go to the Tools option and from there select Script Editor.

If you use a script from the tech blog Skipser, it will encrypt all your data in a document and protect it behind a password. But after that, you can skip the first part and straight go to the next step to encrypt and decrypt your files, and it will take only a few seconds.

How to Set up a Password Protect Google Sheetįor the first time, when you choose to password-protect your files, you will have to set it up. By encrypting data, you make your data more secure, and if, for some reason, someone accesses your account, they will be unable to read the data without a password. In case you still want to increase security for your files - you can. How to Access the Encrypt Spreadsheets on Your Phone.How to Change the Password of an Encrypted File.How to Set up a Password Protect Google Sheet.

Is google drive secure code