How to Mark Workbook as Final in Excel (with Easy Steps)

Do you want to know how to mark a workbook as final in Excel to signal that this is the concluding version of your worksheet? We often use this type of feature when we are the main editor or author and want to discourage modification of our file. However, users may still modify the worksheet. Now, let’s see how to do this.

Step 1: Opening Excel Workbook and Go to File Tab

  • First and foremost, we must open a workbook, and then we’ll go to the File tab.

go to the File tab: How to Mark Workbook as Final in Excel


Step 2: Navigate to the Info Section and Click on ‘Mark as Final’ Option

  •  Now as shown in the image below, choose Info, and after clicking the drop-down menu of Protect Workbook select Mark as Final.

drop down menu of Protect Workbook select Mark as Final

  • After that, click on the OK button.

click on the OK

  • As a result, a Microsoft Excel message will appear. Just click OK.

a Microsoft Excel message

  • So, the resulting workbook has been marked as final.

the resulting workbook

Note:

Users can continue to modify the worksheet by selecting Edit Anyway. Take note of the MARKED AS FINAL icon in the status bar as well.

Read More: [Fixed!] Protect Workbook in Excel Not Working


How to Remove Mark Workbook as Final in Excel

If you wish to remove marked as final, you can do that very easily. Just go to File > Info in a Final file, where you will see a notification indicating that the workbook has been Marked as Final. To modify this, go back to Protect Workbook and choose Mark as Final.

go back to Protect Workbook and choose Mark as Final

  • The final workbook without Mark as Final.

The final workbook without Mark as Final

Read More: How to Protect Excel Workbook from Editing


Conclusion

Follow these steps and stages of the article to mark a workbook as final in Excel. You are welcome to download the workbook and use it for your own practice. If you have any questions, concerns, or suggestions, please leave them in the comments section.


Related Articles


<< Go Back to Protect Workbook in Excel | Excel Protect | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo