Set or clear read-only status Applies To Excel for Microsoft 365 for Mac Excel 2024 for Mac Excel 2021 for Mac You can lock a file to make it read-only and prevent it from being accidentally …

If you want to remind everyone that a workbook should only be changed if necessary, you can recommend that the workbook be opened as read-only.

Set to ‘Always open as Read-Only' 1. Select File > Info > Protect Document. 2. Select Always open Read-Only. Open a document shared as read only. When you open a document that is shared as Read Only, you have two options.

Excel gives you the ability to protect your work, whether it’s to prevent someone from opening a workbook without a password, granting Read-Only access to a workbook, or even just protecting a worksheet so you don’t inadvertently delete any formulas.

Read-only means you can only view or print. In some cases, this is for added security, such as when you are opening files from the internet, and other times, it can be due to a setting that can be changed.

If you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions. Note: To further restrict reviewers from making changes to your document or spreadsheet, you can make the file read-only or you can password protect it.

You can add a password to an Excel file to prevent unauthorized users from opening or modifying it.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

Excel for the web can open and edit workbooks protected by a password. Passwords can’t be added, changed, removed, or recovered from Excel for the web.

Clear Read-Only option. Go to File > Info. Select Protect document. Clear Always Open Read-Only. Update the document access mode. If you still can't edit, you can try the upper-right corner drop-down. Select Viewing or Reviewing and switch to Editing.