Protect a Workbook in Excel
This example teaches you how to protect the workbook structure in Excel.
If you protect the workbook structure, users cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore.
1. Open a workbook.
2. On the Review tab, in the Protect group, click Protect Workbook.
3. Check Structure, enter a password and click OK.
Note: The Windows option is not available in Excel 2013 and later versions.
4. Re-enter the password and click OK.
Users cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore.
Note: to unprotect the workbook, click Protect Workbook and enter the password. The password for the downloadable Excel file is "easy".
If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.
