Excel Guides

How to Undo an Edit in Excel

If you accidentally make a change to your Excel spreadsheet that you want to undo, there are a few different ways you can go about it. The first thing you should do is try the Undo command. You can access this by pressing Ctrl+Z on your keyboard, or by clicking the Undo button on the Quick Access Toolbar. If this doesn't work, or if you've already undone your last action, you can try the Redo command by pressing Ctrl+Y.

If neither of these commands will work to fix your mistake, your next best bet is to use the Office Clipboard. This is a feature in Excel that keeps track of up to 24 items that you've copied or cut from your spreadsheet. To access the Office Clipboard, click the Home tab, then look in the Clipboard group and click the Show Clipboard button. Once the Office Clipboard pane appears, find the item you want to paste back into your spreadsheet and click it.

If you can't find what you're looking for on the Office Clipboard, your last resort is to use Excel's built-in AutoRecover feature. This will save a backup copy of your spreadsheet every 10 minutes (by default), which you can then use to restore an older version of your file. To access AutoRecover files, open the File menu and click Info, then click the Manage Workbook button and select Version History. From here, you can open and save different versions of your spreadsheet.

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.