Poradnik Excela

How to Protect a Workbook in Excel

Protecting your workbook ensures that unauthorized users cannot open your file or modify its structure, such as adding or deleting sheets.

Krok po kroku

1
Open the Info menu
Click the 'File' tab in the top-left corner, then select 'Info' from the sidebar.
2
Encrypt with password
Click 'Protect Workbook' and choose 'Encrypt with Password', then enter your desired password.
3
Restrict workbook structure
Click 'Protect Workbook' again and select 'Protect Workbook Structure', enter a password, and click OK.

If you lose your password, it cannot be recovered, so keep it in a secure location.

What is the difference between protecting a sheet and a workbook?

Protecting a sheet restricts editing cell contents, while protecting a workbook structure prevents adding, deleting, or renaming sheets.