Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Mark Workbook as Final in Excel

To help prevent changes to a final version of an excel file, you Mark a workbook as final.

Only use this feature to discourage editing. Users can still edit the workbook.

Worked Example:   How to get sheet name only in Excel

Here are steps to Mark a workbook as final below:

1. Open a workbook.

Worked Example:   How to check worksheet name exists in Excel

2. On the File tab, click Info.

3. Click Protect Workbook, Mark as Final.

4. Click OK.


Worked Example:   Steps To Password Protect a Workbook in Excel

Note: users can still edit the workbook by clicking on Edit Anyway. Also notice the Marked as Final icon in the status bar.

Leave a Reply

Your email address will not be published. Required fields are marked *