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…
- 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
Skill Level Intermediate
1. Excel Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.