Thursday, October 24, 2013

Do you want to make your spreadsheet read-only for others? Let's know how to mark the file as Final!

Very often you share your spreadsheet with others and you want that they can only see the content in "Read Only" mode. That means you do not want them to edit or reuse your file for some other purpose.

For this, you often protect the file and make it password protected/ read only. But in Excel there is another option of making your file "Read only" for others and also you can activate the option - that your content is FINAL and you don't want anyone to update the same.

To do this, you have to visit the File option and click the "Protect Workbook" dropdown as shown below. Post that you will get an option called "Mark as Final". This will let the users know that this is a final version and thus read only.



For more details on Encrypting your file, protecting particular cells, columns and formatting etc. Please get in touch with me at Samrat.biswaas@gmail.com.

Samrat Biswas
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), MS Visio, MS Project, and MS SharePoint.
--------------------------------------------------------------------------------------------------------------------
Reach me @ +91 8095039316
 

No comments:

Post a Comment

Preface 2nd Edition

The Kindle edition of this book was liked by many individuals. There are multiple different messages and post on Facebook or in Excel in MS ...