how to fix exel spreadsheet.

R Davenport 0 Reputation points
2026-11-18T20:58:12.88+00:00
  1. Some times when i open Xcel the numbers are upsidedown.
  2. Sometimes the cells get larger.
  3. on pressent spread sheet, there are numbers with a smaller font behind normal numbers and they are upsidedown.
Microsoft 365 and Office | Excel | For home | MacOS
0 comments No comments

2 answers

Sort by: Oldest
  1. AI answer

    2026-11-18T20:59:25.33+00:00

    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.

    1. Select the cells containing upside-down or overlapping numbers.
    2. Right-click the selection and choose Format Cells.
    3. 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.
    4. Select OK.
    5. 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:

    1. Select the affected rows.
    2. 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 .xlsx file. 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

    1. Fix data that is cut off in cells in Excel for Mac
    2. Format numbers
    3. Display dates, times, currency, fractions, or percentages
    4. Fixes or workarounds for recent issues in Excel for Mac | Microsoft Support
    5. Update Office for Mac automatically | Microsoft Support
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. Chloe-V 15,830 Reputation points Microsoft External Staff Moderator
    2026-11-19T04:01:48.23+00:00

    Hi @R Davenport

    The upside-down or smaller duplicate numbers may be a display-rendering issue, rather than the values or formatting in the spreadsheet being changed.

    When the issue appears, please take a screenshot using Shift + Command + 3 or Shift + Command + 4, then check the screenshot:

    • If the duplicated or upside-down numbers also appear in the screenshot, the issue is likely related to how Excel is rendering the workbook.
    • If the screenshot looks normal even though the Excel window does not, the issue may be related to the Mac display, an external monitor, or its connection.

    Please also let us know:

    • Does the issue disappear if you change the Excel zoom level, for example from 100% to 90% and back?
    • Are you using an external monitor or display adapter?
    • Does resizing the Excel window or switching to another worksheet temporarily correct the display?
    • Does this happen in every workbook, including a newly created blank workbook?

    If possible, please share a screenshot of the affected cells, with any private information hidden. This will help determine whether the cells are actually rotated or whether Excel is showing temporary visual artifacts.


    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.