How to Prevent Users from Editing in Word or Excel?

Microsoft Office is the widely known software which includes Word, Excel, PowerPoint and Outlook etc. This software is used for homes as well as for business purpose. You can install this MS Office software in your device through www.office.com/setup. Through this software you can manage, store and share documents with other people easily. It provides cloud computing technology to the user. With this cloud technology, you can save the document online and can access anywhere anytime.

read here also>>> Incredible Way to Resolve Office Error Code 30088-1015:

People usually share their documents and invite others people so that they can work together on a single project. But sometimes, people just want other people to look at their work but do not edit their work. Because others can add any misleading data in it which you do not want. Hence, Office version has given their users to restrict their other customer from editing their work. In this blog, you will read how you can restrict other user from editing in Word or Excel.

How to Prevent a user from editing in Word?

First you have to open a Word document which you do not want others to edit. Now, you have to click on the ‘File’ option. After this, you have to tap on the ‘Info’ option. Here you have to go to the right hand side of the page. Then you have to click on the menu “Protect” document. Now you have to select the option ‘Restrict Editing’. Here you have to tick-mark the box which allows you to limit formatting and then just choose ‘Settings’. When you clear the styles which you wish to prevent and then you have to click on ‘OK’ button. When you make the changes, just check the box which is next to “Allow only this type of editing”. From the drop-down menu, just make the changes for the following like No changes (Read-only), Tracked changes, Comments and Filling in forms. After this, you have to select the part of the word document which you do not want to restrict and others can easily edit it. Now, go to the ‘Exceptions’ section. In this, you can easily select a person or a group of people who can edit the document. Here in the “Start enforcement” section, you should select ‘Yes’ option. After this, you have to select the ‘Password’ option and then click on ‘OK’ button. This process will block users to edit or make changes in your document.

How to Prevent a user from editing in Excel?

First you should open an Excel document or worksheet. Then you have to tap on the ‘File’ menu, and after this, click on ‘Info’ option. Now you have to go to the right hand side of the page which opens up. After this, you should hit on the ‘Protect Workbook’ menu and then select the ‘Protect current sheet’ option. You can also set a password to unlock the sheet. Then you have to tick-mark the box which is next to ‘Protect worksheet and contents of locked cells’. Here from the edits list, you can select which users can edits and then you have to click on ‘OK’ button. Now you have to re-enter the password for confirmation and then just click on ‘OK’ button. Here you have to Save the settings which you have made and the users can make changes according to the applied changes.

This method will restrict users from edit in Word and Excel. If you want any kind of help, then you can visit to the site of MS Office via office.com/setup.

Leave a Reply

Your email address will not be published. Required fields are marked *