Excel: Protect the table with a password

If you want to prevent other users from accessing or editing an Excel spreadsheet, you can protect the file with a password. We will show you which settings this works for.

Protect Excel spreadsheet with a password - this is how you proceed

Latest videos

Protect your Excel spreadsheet with a password

How to set a password for your Excel spreadsheet on Windows

In the following we explain the procedure for protecting your Excel spreadsheets. We explain the steps under Windows as well as for macOS.

1. For macOS: Open the desired Excel file and click on "File" in the top left.
2. Select "Save As" and the desired folder in which you want to save the file.
3. Click on "Options ..." under the file format and enter the password for opening and / or editing the file. Then click on "OK" and enter the passwords again.
4. Windows: If you want to protect your Excel spreadsheet under Windows, the last step changes. Under the file format, click "More Options".
5. Then go to "Tools" and then to "General Options". Now you can set your password for the table here.