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

Get FREE Advanced Excel Exercises with Solutions!

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


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

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Al Ikram Amit
Al Ikram Amit

Hello, I'm Amit, a BUET graduate with a passion for Excel. Currently, I work as an Excel & VBA Content Developer at ExcelDemy, contributing insightful articles to the blog. I enjoy sharing my knowledge with others and always look for opportunities to grow as an Excel expert. Feel free to reach out if you need assistance or want to discuss the latest trends in Excel. Let's excel together in the world of data manipulation and analysis!

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo