Site icon Ravi Shankar

How to make a workbook read only in Excel

We have already seen how to How to make a presentation read only in Power Point. Similarly an excel workbook can be made read only using Excel Options. Listed below are the steps to make a workbook read only in Excel 2013 and Excel 2010

Click on the File menu –> Info menu

Click on the Protect Workbook drop down arrow. This would display the following menu list

Click on the Mark as Final menu, the following dialog box would appear.

On selecting OK button the following confirmation box will be displayed.

By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file.

Also See: Different ways to protect workbook in Excel 2013

Exit mobile version