Mark Workbook as Read-only in Microsoft Excel

This post explains about the Read-only feature in Microsoft Excel and how you can mark a workbook as read-only in excel.

How to Mark Workbook as Read-only in Microsoft Excel?

By making the workbook read-only, the users cannot edit the data in the worksheet, they can only view the workbook.

Here is an example of how to mark a workbook as read-only.

  • Open a workbook.
Mark Workbook as Read-only in Microsoft Excel
  • Select File tab and select Save As.
  • Click Browse.
Mark Workbook as Read-only in Microsoft Excel
  • Click on the Tools button on the bottom
  • Click General Options.
Mark Workbook as Read-only in Microsoft Excel
  • Enter a password in the Password to modify box and click OK.
Mark Workbook as Read-only in Microsoft Excel

Note: If you want the users to open the Excel file as read-only without protecting it, then don’t enter a password instead check Read-only recommended alone and click OK.

  • Reenter the password and click OK.
  • Enter the file name and  Save.

Now the file can be accessed only through the password and the others users can only read the file.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.