How To Make An Excel Spreadsheet Read Only

Whether you desire other people to edit your excel workbook without permission? If not, and so setting your excel workbook read only is a common but good method for yous to choose.

If you have no idea about how to set excel workbook read just, following article would tell you several ways that you lot can utilize to restrict other people from changing your workbook. (Eg. Excel 2010)

• Way 1: Set Excel Workbook read only by "Mark equally Concluding" choice
• Way 2: Mark Excel Workbook "Read-only recommended"
• Manner three: Set modify password to protect Workbook in read but mode
• Way iv: Protect Workbook structure to prevent unwanted changes
• Fashion 5: Protect sheets in Workbook to continue read only

Way 1: Set Excel Workbook Read Just past "Marker as Final"

1. Navigate to File > Info, click Protect Workbook and select Marking as Final in several options that you tin can use to protect your workbook.

two. Click "OK" on pop-up dialog to make sure this workbook will be marked equally last and saved.

Then a bulletin would prompt you that the settings would turn off typing, editing commands and proofing marks. Just actually the pick "Marking as Final" would just make readers know the workbook is read-but. If y'all desire to remove information technology, yous just need to select "Mark every bit Final" option in File > Info > Protect Workbook over again.

So even though it could assistance to set excel workbook read only, information technology still cannot prevent people from editing.

Way 2: Marker Excel Workbook "Read-only recommended"

1. Click File > Save As in Excel, then in Save As dialog, select Tools > General Options.

2. Check "Read-merely recommended" in following General Options dialog. And click OK.

3. Tap on "Save" button and relieve excel workbook to supplant that already exists.

From and so on, when other people open up the excel workbook, they volition be prompted that the excel workbook should be opened as read-only unless they demand to salve changes to it. Simply they still take choices to open workbook as read just or not.

Choice ane:

Select "Yes" and workbook would be opened in read-merely style. Then changes cannot be made to the original workbook. To salve changes, you only could create a new copy of the workbook and give information technology a new name, or relieve workbook in another location.

Choice 2:

Select "No" and excel workbook would not exist opened in read only way. Y'all can change workbook and save changes this time. But when y'all salvage and open this workbook adjacent fourth dimension, y'all would discover this workbook nevertheless recommend you to open it as read only.

Tips:

If you have checked "Read-only recommended" in MS Excel, and so every excel workbook yous create later would be checked by default. It means all of workbook would be recommended to open in read only mode when yous attempt to open them.

Way 3: Prepare Modify Countersign to Protect Workbook in Read Only Way

To directly protect workbook from editing, I remember the common way is to gear up a modify password on it.

1. In Excel Save Equally dialog, click Tools and select General Options.

2. And so in General Options dialog, you can enter a password in box "Countersign to modify" and click OK, to protect workbook with alter countersign from editing.

3. Click Save button in Salvage As dialog to save workbook and replace the original ane.

Then while you open the Excel workbook next time, a dialog would always pops up and asks for a countersign for write admission. Otherwise, y'all merely could open the workbook read only.

Way iv: Protect Workbook Structure to Foreclose Unwanted Changes

If you just want to prevent unwanted changes to the structure of workbook, such as adding/moving/deleting sheets, y'all can choose to protect Workbook Structure.

1. Click File > Info and select Protect Workbook Structure under Protect Workbook.

Or click Review tab and select Protect Workbook option in Changes grouping.

2. On following Protect Construction and Windows dialog, check "Structure" and "Windows" in order to protect workbook construction and windows.

3. Now you could besides set a password to protect information technology, and then only people who know the password could change your Excel Workbook structure. Click OK at last.

Manner 5: Protect sheets in Workbook to keep read only

1. Navigate to each sheet in Workbook you desire to continue it read only.

2. Click Review tab and Protect Canvass in Changes group.

3. Enter password to protect sheet and click OK in dialog "Protect Sheet".

Then when you want to edit sheet, yous would be prompted that "The cell or nautical chart is protected and read-merely". Only after removing protection, tin can you modify a protected cell or chart.

Tips: At that place is another manner you could likewise protect workbook from editing. That is encrypting Workbook with password to prevent workbook from opening.

When you cannot open excel workbook, then you cannot make any changes to this workbook, unless you lot tin can recover excel countersign or remove excel password. Once you have workbook open countersign or successfully remove open up password, you would be able to practise annihilation yous want on excel workbook.

Related Articles:

• How to Add or Remove Password Protection in Excel 2016 Spreadsheet
• How to Remove Workbook Protection Excel 2010 without Password
• How to Protect Multiple Sheets in Excel 2010 Workbook
• Forgot Excel Workbook 2010/2013/2016 Password
• How to Unlock Encrypted Excel Spreadsheet without Password

Source: https://www.isunshare.com/blog/set-excel-workbook-read-only-to-restrict-changes/

Posted by: cooperevines1973.blogspot.com

Share this post