• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Digital Answers

How to tech tutorials in simple words

  • Home
  • About Us
  • Disclaimer
  • Privacy Policy

Read-only

How to make a workbook read only in Excel

September 8, 2014 by Admin 40 Comments

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

Protect Workbook in Excel 2013 and Excel 2010

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

Mark workbook as final in Excel 2013 and Excel 2010

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

image

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

Warning message when workbook marked as final in edited

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

Filed Under: Excel, Excel 2010, Excel 2013, MS Office Tagged With: Excel 2010, Mark As Final, Office 2010, Read-only, Workbook

Primary Sidebar

Recent Posts

  • Streamline your Excel spreadsheets with these easy steps to hide rows and columns
  • Effortlessly Convert Text Cases in Excel with These Methods
  • A Guide to Using the MAX and MIN Functions in Excel
  • How to display fractions in Excel
  • How to Separate a Person’s First and Last Name in Excel

blogmines.com Copyright © 2023