How Do You Use Excel Password Protect?
Microsoft Excel is one of the most common spreadsheet tools in the workplace today. With a little effort, you can increase your Excel skills and optimize your job productivity. This tip shows how to use Excel password protect, forcing all users to enter a password before opening a spreadsheet. Open an Excel workbook where you’d like to use Excel password protect to prevent prying eyes from seeing the data. In this example, there is a spreadsheet with fake social security numbers. Go to the menu path File -> Save As. On the dialog box, select Tools -> General Options. This is on the right-hand side. The password screen is now open. You have three options: 1-Enter password for “Open” only. This requires a password to open the spreadsheet. If the user doesn’t have the password, they won’t be granted any access. The user has edit rights in this scenario if they know the “Open” password. 2-Enter password for “Modify” only. Any user can open the spreadsheet, but they need the password to mod
