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
Feedback sent
We appreciate your effort and will try to fix the article