How to password protect workbook in Excel 2013

There are primarily two levels of password security you can apply to workbook in Excel 2013:

1. Protection for structure
2. Protection for Windows

Protection for Structure

This feature disables workbook structure features like insert, delete, rename, move, copy, hide or unhide

To protect workbook for structure

Open workbook >>> Go to "Review" tab >>> Click "Protect Workbook"
[Keyboard shortcut: Alt +RPW]

Click on "structure" and enter desired password. Press OK.

Then re-enter the password to confirm the same. Press OK.

Protection for Windows

This feature protects the workbook windows i.e. one cannot move or change size or close windows

The process to enable this is very similar to protecting the structure.

Open workbook >>> Go to "Review" tab >>> Click "Protect Workbook"

Click on "Windows" and enter desired password. Press OK.

Then re-enter the password to confirm the same. Press OK.

Unprotecting workbook

To unprotect the workbook, click on Protect Workbook again (on "Review" tab) and enter correct password.