From the course: Excel Quick Tips (2023)

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Restrict editing

Restrict editing - Microsoft Excel Tutorial

From the course: Excel Quick Tips (2023)

Start my 1-month free trial Buy for my team

Restrict editing

“

- [Instructor] In Excel, you can set a password to limit editing or modifying a file to only authorized users. Start by opening the file and choosing File, Save As. Here in the save as window, click more options, and then click tool. Click the tools menu 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 to only authorized users, enter a password for 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 OK. Then confirm the passwords you just entered. Save your workbook, and we'll close it. And 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.…

Contents