How to Protect an Excel Sheet in Google Drive

How-to basics · Updated November 20, 2026

To stop people editing particular tabs or cells in an Excel workbook stored in Google Drive, open a converted Google Sheets copy and use Data > Protect sheets and ranges. If you need Excel’s own password-based worksheet protection, apply it in Excel instead: Google Drive stores the file but does not add Excel sheet protection. Choose the method that matches whether you want to control editing in Sheets or preserve an Excel workbook.

Sheet protection is mainly an editing safeguard, not a way to keep information secret. Anyone with access may still be able to view the protected content, and people with enough access may be able to copy or download it. Use Drive sharing permissions to control who can access the file at all.

What You’ll Need

  • A Google account with access to the workbook and permission to edit it, if you plan to protect tabs or ranges in Google Sheets.
  • The Excel workbook in Google Drive. Make a backup before converting it, especially if it contains macros, complex formatting, or features that may not transfer perfectly.
  • A list of the people who should be allowed to edit the protected areas, if you want to allow specific editors.
  • Microsoft Excel for desktop if you specifically need Excel’s worksheet protection feature while keeping the file in .xlsx format.

Step-by-Step

  1. Decide what you are trying to protect. If you want to stop some collaborators from changing a tab or selected cells while they work in a browser, use Google Sheets protection. If your goal is to prevent people from opening or downloading the workbook, change its Google Drive sharing settings. If the workbook must remain an Excel file with Excel’s own worksheet protection, use Excel’s Review tab and avoid converting the file. These options solve different problems, so choosing first helps prevent format surprises.
  2. Make a backup of the workbook. In Google Drive, find the Excel file, right-click it, and choose Organize > Make a copy if that option is available in your Drive menu. You can also download a copy as a backup. Give the copy a clear name, such as Budget backup before Sheets conversion. Conversion can change features that Google Sheets does not support, including some formatting, formulas, charts, or macros. Keep the original until you have checked the converted version.
  3. Open the workbook in Google Sheets and convert it. In Drive, right-click the .xlsx file and choose Open with > Google Sheets. In the opened workbook, select File > Save as Google Sheets. This creates a new Google Sheets file; the original Excel file normally remains in Drive. Open the new file and check that the tabs, key calculations, and important formatting look right. If you do not see Save as Google Sheets, confirm that you opened the file in Sheets and that you have permission to edit it. An Office file being editable in Sheets does not necessarily mean it has been converted.
  4. Choose the tab or cells to protect. In the converted Google Sheets file, select Data > Protect sheets and ranges. A panel opens on the right. Choose Add a sheet or range. To protect a whole tab, select Sheet and choose the tab name from the list. To protect only part of a tab, select Range and enter or select a range, such as B2:F25. Check the displayed sheet name and range before continuing; protecting the wrong tab or a range that is too small is an easy mistake.
  5. Set exceptions if some cells should stay editable. When protecting a whole sheet, you can use the option to except certain cells and enter ranges collaborators are still allowed to edit. For example, you might protect a price list tab but leave the quantity-entry cells open. Keep exception ranges as narrow as practical. If you are protecting only a range, confirm that the range does not include cells people need to update. The protection sidebar should describe the sheet or range you intend to lock.
  6. Set who can edit the protected area. Select Set permissions. Choose the option to restrict who can edit the range, then choose Only you or Custom, as offered in the panel. Use Custom to allow named collaborators who need to maintain that section. Confirm the selection to apply it. Google Sheets protection is not a password prompt: you assign editing permissions to Google accounts. The owner or other people with sufficient file permissions may still be able to change the protection.
  7. Test the protection with a permitted account. Return to the sheet and try to edit a cell inside the protected area. Check that Sheets blocks the change for an account that should not edit it and allows it for an approved editor. If you are the owner, your own access may make the test misleading; ask a collaborator to try, or check the permissions list. Do not test by changing important data unless you can restore it.
  8. Review the file’s Drive sharing settings separately. Click Share. Under General access, choose Restricted if only invited people should open the file, and check each invited person’s role. Viewer and Commenter roles do not have the same editing access as Editor. If someone should not see the workbook at all, remove their access or change the general access setting; protecting a tab does not hide its contents. Share the converted Google Sheets file if that is now the working copy, and make clear which file collaborators should use.
  9. If you need Excel worksheet protection, apply it in Excel instead. Open the original .xlsx in Excel for Microsoft 365 on Windows, select Review > Protect Sheet, choose the actions users may perform, and set and confirm a password if prompted. Store the password safely; losing it can make later changes difficult. Excel worksheet protection is primarily meant to prevent accidental edits, not to encrypt confidential information. Keep the file in .xlsx format and test a copy in the apps your collaborators use. Google Drive sharing controls still determine who can get the file.

Common Mistakes

Assuming Drive protection and sheet protection are the same. Drive sharing controls access to the entire file. Google Sheets protection controls editing of a sheet or range inside it. Someone with Viewer access may still see protected cells, and someone with Editor access may be able to copy or download information depending on the sharing setup. Use the file’s sharing settings for access control and sheet protection for editing boundaries.

Expecting a password box in Google Sheets. Google Sheets protection uses account permissions rather than a password that you give to collaborators. If you need a password-based Excel worksheet feature, use Excel’s Protect Sheet command in the .xlsx workbook. Do not assume that converting to Sheets will preserve every Excel protection setting.

Using a warning instead of a restriction. The protection panel can offer a warning when someone edits a range. A warning is only a caution; it does not prevent the edit. Choose the restriction option and set the permitted editors if you need changes to be blocked.

Converting without checking what changed. A workbook may include macros, specialized charts, formulas, or formatting that behaves differently in Sheets. Conversion creates a separate file, but it is still important to compare the converted copy with the original and keep a usable backup. Do not delete the original until you have verified the features you rely on.

Tips

  • Use clear tab names and protection descriptions, such as Protect formula cells or Entry fields for monthly update. A useful description helps other editors understand the boundary without guessing.
  • Protect formulas and setup cells, but leave only the intended input cells open. For example, if collaborators enter quantities in column D, protect the formula columns and make the needed D cells exceptions rather than leaving a broad section editable.
  • Give collaborators the lowest Drive role that still lets them do their work. If they only need to review information, Viewer or Commenter access is usually more appropriate than Editor access.
  • Keep a separate, unshared backup if the workbook contains sensitive material or important business logic. Protected cells are not a substitute for limiting access to the file.
  • If people need to edit the file in Excel after you have used Google Sheets protection, download a test copy and inspect it in Excel before relying on the protection. Exporting between formats can change features, so verify the result in the application where collaborators will work.
  • When permissions change, revisit the protected range settings as well as Drive sharing. Removing a person from Drive sharing stops their access to that file, while changing a protected-range rule affects who can edit that area among people who still have file access.

Troubleshooting

You cannot find Protect sheets and ranges. Check that the file is a native Google Sheets file, not just an .xlsx opened in Office editing mode. In Sheets, use File > Save as Google Sheets, then open the new file and check Data again. If the command remains unavailable, make sure your account can edit the file; an administrator’s Workspace policy or the file owner’s settings may also limit what you can change.

Someone can still change a cell. Open Data > Protect sheets and ranges and inspect the listed rule. Confirm that the right tab and range are selected, that the cell is not in an exception range, and that the person is not included as an allowed editor. Also check whether the rule is only set to show a warning. Remember that the owner or an editor able to change protections may be able to update the rule itself.

A collaborator cannot edit a cell they need. Check both layers of permission: their Drive role must allow them to edit the file, and the protected-range rule must allow them to edit that particular area. Add them to the permitted editors for that range, or adjust the exception cells if the area is meant to be open to all file editors. Avoid changing their Drive role to Editor if they only need access to one protected section and should not edit the rest of the file.

The converted workbook looks different or a feature is missing. Compare it with the original .xlsx and identify which formulas, charts, macros, or formatting are affected. Restore from your backup if the converted file is not suitable. If Excel-specific behavior is essential, continue with the .xlsx in Excel and use Excel’s protection features rather than depending on a converted Sheets copy.

You need to stop someone from seeing or downloading data. A protected sheet does not do that. In Drive, change General access to Restricted, remove people who should no longer have access, and review the roles of remaining collaborators. Workspace administrators may provide additional sharing controls. For confidential information, do not share a file with people who should not see its contents.

Frequently Asked Questions

Can I protect an Excel sheet directly in Google Drive?
Drive itself does not provide a command to apply Excel worksheet protection. Convert the workbook to Google Sheets and use Data > Protect sheets and ranges for Sheets-based editing restrictions, or use Excel’s Review > Protect Sheet in the .xlsx file.

Can I password-protect a sheet in Google Sheets?
No. Google Sheets protection is based on Google account permissions, not a sheet password. Excel’s Protect Sheet command can use a password, but worksheet protection is not the same as encryption for sensitive data.

Can people view a protected sheet?
Yes, if they have permission to view the file. Sheet and range protection restricts editing; it does not make the contents invisible. Change Drive sharing access if someone should not be able to open the workbook.

Can I protect only some cells and leave others editable?
Yes. In Data > Protect sheets and ranges, protect a selected range or protect a whole sheet and specify exception cells. Then set which accounts can edit the protected area.

Will protection remain if I download the file as Excel?
Do not assume that every protection rule will transfer exactly between Google Sheets and Excel. Download a test copy and inspect it in Excel if the workbook will be edited there. For essential Excel-specific protection, set and verify it in Excel.

What should I do if I only want to stop editing, not hide the file?
Share the file with the appropriate people and use Viewer or Commenter roles when they do not need to edit. If collaborators need to edit other parts of the workbook, protect specific Sheets tabs or ranges and grant access only where needed.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.