Forum Discussion

wking1265's avatar
wking1265
Copper Contributor
Aug 20, 2022

Excel 2013 formatting a mess

I could use some help.  I turned on my Windows 10 computer this morning and the formatting of my excel spreading sheet is a garbled mess.  Tens of thousands of once-clean cells now looks like this:

 

 

I tried to export file to another format, (2003 & macro-enabled), but no luck. Please help!

 

6 Replies

  • wking1265 

    You could select all cells by clicking the button in the top left corner of the sheet at the intersection of the row numbers and column letters.

    Then select Clear > Clear Formats in the Editing group of the Home tab of the ribbon.

    • wking1265's avatar
      wking1265
      Copper Contributor
      Thanks for the suggestion Hans, but that just produced no formatting at all. I need to restore the formatting to it's original form.
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        wking1265 

        Do you have a backup copy of the workbook from before the problem started?

        Also:

        If you are on Windows: right-click the workbook in File Explorer/Windows Explorer and select Previous Versions. Wait a few seconds to see if the dialog gets populated.

        If you are on MacOS: see if you can find a valid version in Time Machine.

Resources