Forum Discussion
Excel 2013 formatting a mess
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.
- wking1265Aug 20, 2022Copper ContributorThanks for the suggestion Hans, but that just produced no formatting at all. I need to restore the formatting to it's original form.
- HansVogelaarAug 20, 2022MVP
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.
- wking1265Aug 20, 2022Copper Contributor
I'm using windows and under file explorer I don't see an option for restoring previous versions.
I do, however, save everything to Microsoft OneDrive. I there a way to recover older versions, say 2-7 days old?