Excel: Password Protect a Workbook

If you're keeping track of sensitive items in a spreadsheet, such as financial data or personal information, it would be wise to protect it against unauthorized access. You can do this by encrypting your Microsoft Excel workbook with a password.

Go to the 'File' tab, and choose the 'Info' option. Click the first button, 'Protect Workbook', then choose 'Encrypt with Password'. You will be prompted to enter a password of your choosing. Keep in mind that it is case-sensitive, so make sure you know whether or not your Caps Lock is on. Press the 'OK' button, then reenter the password. Press the 'OK' button, and you're done.

The next time you open the workbook, you will be prompted to enter the password. Wrong password means no access! Perfect.


Post a Comment