Formatting Issues

Fix Custom Number Formats That Cannot Be Deleted in Excel for Mac

Olivia MillerOlivia Miller Nov 14, 2026 868 views

Question details

Delete a custom number format when Excel for Mac incorrectly reports that the worksheet is protected.

Fix Custom Number Formats That Cannot Be Deleted in Excel for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a new workbook

In Excel for Mac, select File > New and create a blank workbook. Keep the original workbook open.

2
Copy each worksheet

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.

3
Check the copied workbook

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.

4
Delete the custom format

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.

Copy Each Worksheet Into a New Excel Workbook
If the warning persists: Record the exact warning and your Excel version from Excel > About Microsoft Excel, then provide those details when requesting further support.
Free Microsoft Office alternative

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.

Format spreadsheet numbers through a familiar interfaceOpen and save Microsoft Excel XLSX filesMove everyday spreadsheet work to a free, lightweight office suiteUse familiar tools across documents, spreadsheets, and presentations
microsoft office alternative - wps office

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.