How Excel UNDO works with multiple workbooks

Created by Harry Lewis, Modified on Mon, 5 May at 5:25 AM by Velixo Team

Overview


Having multiple Excel workbooks open at a time is a common scenario. This article provides examples of how Excel's UNDO feature behaves in such circumstances.



Example


Here is an example with four separate workbooks open in Excel:




In cell A1 of Book1, we input the number 1:




Then we input:

  • the number 2 in Book2
  • the number 3 in Book3
  • the number 4 in Book4




Now, let's switch back to Book1 and hover the mouse cursor over the UNDO button on the Excel title bar:



Note that Excel is going to UNDO the change in Book4!


Even though Book1 is currently displayed, the feature will UNDO changes (starting with the most recent one) made across all open workbooks, regardless of the currently active workbook tab.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article