This video discusses how to apply both an open password and a password to restrict editing a spreadsheet to only authorized users.
(upbeat music) - [Instructor] Microsoft Excel lets you set a password to limit editing or modifying a file to only authorized users. Start by opening the file and choosing File, Save As. Click Browse and in the Save As window click Tools and choose General Options. Here you can apply a password to open the workbook and a password to modify the workbook. If you want to restrict viewing of the workbook you only authorized users enter a password for our password to open.
You can leave this field blank if you want anyone to be able to open the file but to prevent anyone from modifying the workbook, enter a password to modify. Click okay and then confirm the passwords you just entered. And then save your workbook. Now when this file is opened the user is first prompted to enter the open password if you applied one and then they'll be prompted to enter the password to modify the document. If a user without the password clicks Read Only they'll be able to view the document and to make changes, however if they click the save button they'll see a message that the document is read only and that they'll have to create a copy of the file with a different name in order to save their changes.
- Working with references
- Freezing and locking
- Automatic data population
- Recovering lost work
- Finding named ranges
- Formatting cells and applying styles
- Applying international currency formatting
- Inserting hyperlinks
- Creating dropdown lists
- Hiding columns and rows
- Password protecting a workbook
- Restricting editing
- Adding headers and footers
- Locking cells