Excel Guides

How to Increase Undo Levels in Excel

If you work with large or complex spreadsheets in Microsoft Excel, you may sometimes need to increase the number of undo levels. By default, Excel allows you to undo your last 20 actions. But you can increase this number up to 100 if you need to.

Here's how:

  1. Open Excel and click the File tab.
  2. Click Options.
  3. In the Advanced section, scroll down to the "Display options for this workbook" heading.
  4. Under this heading, look for the "Number of undo levels" option and use the drop-down menu to select the desired number of undo levels (up to 100).
  5. Click OK. Your changes will be saved automatically.

Now when you make changes in your spreadsheet, you'll be able to undo up to the number of actions that you specified. This can be a useful setting if you often find yourself needing to undo multiple steps in your work.

Keep in mind that increasing the number of undo levels will use more memory, so if you find that your computer is running slowly after making this change, you may want to decrease the number of undo levels again.

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.