No. Google Sheets has no password you can set to open a file, and its protection tools don’t take a password either. Access runs through Google accounts and sharing instead. So protecting a sheet comes down to three settings, one for who can open it, one for who can change it, and one for what people can do with a copy.
How do you stop people opening a Google Sheet?
Set the sheet’s general access to Restricted and share it only with named people. With Restricted, only the people you’ve added can open the file, and they sign in with a Google account to do it.
- Click Share in the top-right corner.
- Under General access, choose Restricted.
- Read the list of people with access and remove anyone who shouldn’t be on it.
- Give each person the lowest role they need, Viewer, Commenter or Editor.
Avoid “Anyone with the link” for anything private, because it lets anyone on the internet who has the link open the sheet without signing in (Google Drive sharing help). On a work or school account, you can also set an expiry date on a person’s access, up to a year ahead.
How do you stop people changing part of a sheet?
Use Data > Protect sheets and ranges. It locks a tab or a block of cells so that only the people you choose can edit them.
- Open the sheet and click Data, then Protect sheets and ranges.
- Click Add a sheet or range, then choose Range or Sheet.
- Click Set permissions.
- Choose Restrict who can edit this range, then pick Only you, or Custom to name the people who can edit.
- Click Done.
If you only want to stop accidents, choose Show a warning when editing this range instead. People can still edit, but Sheets asks them to confirm first.
Protection only decides who can edit. Everyone who can open the file can still see a protected range, and Google says protection “shouldn’t be used as a security measure” because people can still print, copy and export the sheet. Hiding a tab doesn’t keep it private either. Editors can unhide it, and a viewer who makes a copy can unhide it in the copy.
For example, a sales team shares one sheet where reps update their own deals, and a Commission tab holds the rates. Protecting the Commission tab stops a rep changing a rate, but every rep can still read it. To keep the rates private, move them to a second file shared only with finance, and keep just the totals in the team’s sheet.
How do you stop people downloading or copying a sheet?
Turn off downloading, printing and copying for viewers and commenters in the share settings.
- Click Share, then the settings icon.
- Untick the box that lets viewers and commenters download, print and copy the file.
- Untick Allow editors to change permissions and share, so an editor can’t add people you didn’t choose.
These settings remove the menu options, but they can’t stop a screenshot.
What if the data really needs a password?
On a Google Workspace Enterprise Plus, Frontline Plus, Education Standard or Education Plus account, ask your admin about client-side encryption (supported editions). Google can’t decrypt a file encrypted this way, and only one person can edit it at a time (how encrypted files work).
On a personal account or a smaller Workspace plan, the dependable route is to keep the private part out of the shared file and share it with fewer people. A password prompt built in Apps Script only hides the data, which is still in the file, and editors can open the script and switch it off. A third-party encryption add-on means another company handles your data.
Whichever route you take, the file lives on Google’s servers, and Google accounts decide who gets in.
Request beta access to Biscuit
References
- Protect, hide & edit sheets, Google Docs Editors Help
- Share files from Google Drive, Google Drive Help
- Get started with encrypted files in Drive, Docs, Sheets & Slides, Google Docs Editors Help
- About client-side encryption, Google Workspace Admin Help
- Apps Script, Google for Developers
All links checked and active as of 27 October 2026.