A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Reset the affected cells’ orientation and font settings first; if the upside-down or duplicate numbers return intermittently, update Excel and test whether the problem is limited to that workbook.
1. Correct the affected cells
Save a copy of the workbook before changing its formatting.
- Select the cells containing upside-down or overlapping numbers.
- Right-click the selection and choose Format Cells.
- Open Alignment:
- Set Orientation/Degrees to
0. - Set Horizontal to General.
- Clear Shrink to fit if selected. That option automatically makes text progressively smaller to fit the cell.
- Set Orientation/Degrees to
- Select OK.
- On Home, set Font size to the same size as nearby normal cells.
These are the documented Excel for Mac controls for rotated text, default alignment, and automatic font shrinking.^1^
If the rows became unusually tall:
- Select the affected rows.
- Go to Home > Format > AutoFit Row Height.
Wrapped text can cause row height to adjust, while a manually fixed row height can produce unexpected sizing.^1^
2. Check whether the numbers themselves are correct
Select one affected cell and inspect the formula bar:
- If the formula bar contains one correct number but the sheet displays overlapping or upside-down copies, this points to a display problem rather than duplicate cell data.
- If the value is wrong, press Command+1, open Number, and choose the appropriate category, such as General or Number.^2^
Changing a number format changes how a value appears; it does not change the value Excel uses in calculations.^3^
3. Update Excel for Mac
Microsoft’s current known-issues page does not list upside-down, duplicated, or overlapping cell numbers as a specific known issue.^4^ Install available updates before doing broader repair work:
- Excel installed from Microsoft: choose Help > Check for Updates, enable Automatically keep Microsoft apps up to date, and select Update.
- Excel installed from the Mac App Store: open App Store > Updates, then update Excel or select Update All.^5^
Quit Excel completely and reopen the workbook after updating.
4. Determine whether one workbook is damaged
Create a blank workbook, enter several numbers, save it, close it, and reopen it.
- Only the original workbook is affected: copy each worksheet’s required cells into a new blank workbook and save it as a new
.xlsxfile. Avoid copying entire sheets initially, because that can carry problematic formatting with them. - New and existing workbooks are affected: this is application-level rendering rather than formatting in one file. Contact Microsoft 365 support and provide:
- Excel version from Excel > About Microsoft Excel
- macOS version
- Whether an external monitor is involved
- A screenshot
- Whether scrolling or changing zoom temporarily redraws the cells correctly
Microsoft’s Excel for Mac known-issues page provides a Contact Us option for Microsoft 365 Home subscribers.^4^
References