Forum Discussion
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
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.
- wking1265Copper ContributorThanks for the suggestion Hans, but that just produced no formatting at all. I need to restore the formatting to it's original form.
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.