Formatting Issues

How to Fix Excel Text Changing to Wingdings Instead of Calibri

Aamir Naveed Akram Oct 20, 2026 868 views

Question details

The user is experiencing an issue where text entered or pasted into Excel automatically changes to the Wingdings font, even though Calibri is the currently selected font.

How to Fix Excel Text Changing to Wingdings Instead of Calibri

Product: Microsoft Excel
Device & OS: not provided
Scenario: Entering new text or pasting copied data into workbooks stored locally or on OneDrive.
Observed behavior: Excel forces the text to display in Wingdings instead of Calibri. This behavior persists across newly created workbooks when the affected worksheets are copied over.

Before you start

Before proceeding with the solutions, ensure that your Office application is fully updated to the latest version and try completely restarting Excel to rule out temporary rendering glitches.

Solution 1Recommended

Manually Transfer Data to a New Blank Workbook

Create a fresh workbook and manually copy only your data to leave behind any corrupted worksheet formatting.

If a specific worksheet has corrupted styles, duplicating the entire sheet will often copy the corruption to the new file. Manually copying the data cells into a completely blank workbook helps isolate the raw data from the broken formatting.

Create a new workbook

Open Excel and go to File > New, then select 'Blank workbook'.

Copy the original data

Return to your affected workbook. Use your mouse to highlight only the cells containing your data (do not click the 'Select All' triangle in the top-left corner), and press Ctrl+C to copy.

Paste into the new workbook

Switch to the new blank workbook, right-click cell A1, and select 'Paste Values' (the clipboard icon with a 123). This pastes the data without bringing over the problematic Wingdings formatting.

Reapply basic formatting

Select the newly pasted cells and verify that the font dropdown shows Calibri. Type a few characters to ensure the text no longer changes to Wingdings.

Manually Transfer Data to a New Blank Workbook

Data Isolation: By pasting values, you completely strip away hidden style corruptions that were causing the Wingdings font override.

Solution 2

Use Move or Copy and Test in Excel for the Web

Move the worksheet to a new file and test it in the online version of Excel to determine if the issue is tied to the local desktop application.

Solution 3

Clear All Corrupted Formatting

Strip away all formatting from the affected cells and reapply the default font settings.

Free Microsoft Office alternative

Edit Spreadsheets Without Formatting Glitches in WPS Office

If Microsoft Excel continues to force text into Wingdings due to complex workbook corruption, consider switching to WPS Office. It provides a lightweight, highly compatible environment to handle all your spreadsheet needs without unexpected font issues.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Workbook: Launch WPS Spreadsheets and open your affected Excel file directly.
3. Edit Without Errors: Continue typing and formatting your data securely without worrying about your text turning into Wingdings.

Seamlessly compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Completely free and lightweight, avoiding the heavy resource usage of standard Office suites.Stable font and formatting management that prevents unexpected style overrides.Familiar user interface requiring zero learning curve for Excel users.

microsoft office alternative - wps office

Frequently Asked Questions

Why is Excel automatically changing my font to Wingdings?

This usually happens due to corrupted cell styles or normal templates within the specific Excel file. When the workbook's default styles get corrupted, Excel may mistakenly apply a symbol font like Wingdings instead of standard text fonts.

How can I check my default font settings in Excel?

Go to File > Options > General. Under the 'When creating new workbooks' section, ensure 'Use this as the default font' is set to Calibri or your preferred body font, then restart the application.

Does duplicating the worksheet carry over the font corruption?

Yes. If you duplicate the sheet using the 'Select All' triangle or the right-click 'Move or Copy' method, you often bring the corrupted styles with you. It is safer to manually copy only the data cells and paste them as values into a fresh workbook.

Document & File Issues