Aug 20 2022 06:18 AM
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!
Aug 20 2022 06:24 AM
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.
Aug 20 2022 06:30 AM
Aug 20 2022 07:13 AM
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.
Aug 20 2022 07:20 AM
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?
Aug 20 2022 07:28 AM
Aug 20 2022 07:28 AM
Open the file, expand the menu near file name on the title bar
click on version history and restore any of available versions.