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.


Steps to Mark Workbook as Final in Excel

Step 1: Open 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

Read More: [Fixed!] Excel Links Not Working Unless Source Workbook Is Open


Step 2: Navigate to 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.


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. Please visit our blog ExcelDemy for a quest for further excel expertise and if you have any questions, concerns, or suggestions, please leave them in the comments section.


Related Articles

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, I am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo