How To Mark A Workbook As Final In Excel

Home » How To Mark Workbook As Final In Excel » How To Mark A Workbook As Final In Excel

Maybe your like

See all How-To Articles

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on September 12, 2023

This tutorial demonstrates how to mark a workbook as final in Excel.

mark workbook as final 6

Mark a Workbook as Final

In Excel, you can mark a workbook as final. This makes the file open in Read-Only mode, with a warning. The warning doesn’t prevent a user from changing a file, but it shows that a file is final and shouldn’t be changed. This can be useful to inform members of a team who share the file that it’s completed.

  1. In the Ribbon, go to File > Info.

mark workbook as final 1

  1. Go to Protect Workbook > Mark as Final.

mark workbook as final 2

  1. When the warning pop-up appears, click OK.

mark workbook as final 3

  1. Another pop-up window appears with the message that the document is completed and marked as final. Click OK.

mark workbook as final 4

Finally, the file is marked as final and opened in Read-Only mode. There is a yellow message at the top; if you want to edit the workbook, click Edit Anyway.

mark workbook as final 5

Remove the “Mark as Final” Flag

When you go to File > Info in a final file, there’s a message to discourage editing in the workbook. To change this status and remove the message, go to Protect Workbook > Mark as Final.

mark workbook as final 6

Then you can lock specific cells or unprotect the workbook.

AI Formula Generator

Try for Free

AI Tools

  • Excel Help Bot
  • Formula Generator
  • Formula Explainer
  • VBA Code Generator
  • VBA Code Commenter
  • Excel Template Generator

See all How-To Articles

← How to Insert an Arrow in Excel & Google SheetsHow to Remove Hyperlinks in Excel & Google Sheets →

Try our AI Formula Generator

Generate =SUMIF(A:A, "Q1", B:B)

Tag » How To Mark Workbook As Final In Excel