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.

Copy link
Powered by Social Snap