Fix Custom Number Formats That Cannot Be Deleted in Excel for Mac
Question details
Delete a custom number format when Excel for Mac incorrectly reports that the worksheet is protected.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- The user wants to remove a custom number format from an unprotected workbook.
- Observed behavior
- Excel reports that a worksheet is protected and prevents the custom number format from being deleted, even though the workbook and worksheets are unprotected.
Check the Review tab for sheet protection and confirm that the format you want to remove is a custom format, not a built-in format. Note the format code so you can identify it in the new workbook.
Copy Each Worksheet Into a New Excel Workbook
Use a newly created workbook when an affected file incorrectly reports that a sheet is protected.
Copying worksheets individually into a new workbook resolved the issue in an affected file. Simply saving another copy of the original file did not resolve it in that case.
In Excel for Mac, select File > New and create a blank workbook. Keep the original workbook open.
In the original workbook, right-click a sheet tab and choose Move or Copy. Select the new workbook as the destination, check Create a copy, and confirm. Repeat for each worksheet.
Switch to the new workbook and inspect the copied sheets, formulas, and links. Remove any unused blank sheet using its sheet-tab menu, then select File > Save As to save the new workbook.
Select a cell in the new workbook and press Command+1 to open Format Cells. On the Number tab, select Custom, choose the unwanted format, and click Delete.

Work With Spreadsheet Number Formats in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel files in WPS Spreadsheets to continue working with number formats and migrate your everyday spreadsheet work, though it does not repair Excel's protection warning.

Frequently Asked Questions
Where can I delete a custom number format in Excel for Mac?
Select a cell and press Command+1. In Format Cells, open the Number tab, select Custom, choose the custom format, and click Delete.
Why should I create a new workbook instead of saving a copy?
Saving a copy may retain the issue in the original workbook. In the reported case, creating a blank workbook and copying each worksheet into it individually resolved the problem.
Can I delete a built-in Excel number format?
No. Excel allows you to delete custom formats, but built-in number formats cannot be deleted. Check the Custom category in Format Cells before trying to remove a format.
What should I check after copying sheets into a new workbook?
Review the copied sheets, formulas, and links in the new workbook, then try deleting the format through Format Cells > Number > Custom. Save the new workbook with File > Save As.




