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.
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.
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?
Open the file, expand the menu near file name on the title bar
click on version history and restore any of available versions.
