Excel Guides

Unwanted Data Changes in Excel

Data changes in Excel can be unwanted for a variety of reasons. Maybe you accidentally hit the wrong key and changed a value. Maybe someone else was working on the same file and saved over your changes. Or maybe you just don't like the new data and want to go back to the way things were.

Whatever the reason, there are a few ways to revert unwanted data changes in Excel. Here's how:

Method 1: Use Undo

If you just made the unwanted change, you can usually undo it by pressing Ctrl+Z. This will undo the last action you took. You can also click the Undo button on the Quick Access Toolbar.

Method 2: Use Restore Version

If you've already saved the file after making the unwanted change, you can restore an earlier version of the file using Excel's built-in version history feature. To do this, open the file and click File > Info > Versions. This will open a list of all previous versions of the file, sorted by date. Select the version you want to restore and click Restore. Your file will be reverted to that earlier version.

Method 3: Use AutoRecover

If you didn't mean to make the change and saved over your previous changes, there's still hope! Excel automatically saves backup copies of files as you work on them, so long as the AutoRecover feature is enabled. These backup files are saved every 10 minutes by default, but you can change how often they're saved in Excel's Save options. To access these options, open Excel and go to File > Options > Save. Under "Save AutoRecover information every:", select a new time interval from the drop-down menu.



Method 4: Use Previous Version

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.