Office Settings & Configuration

How to Separate Excel Undo History Between Workbooks

Tauseeq Magsi Oct 1, 2026 868 views

Question details

The user wants to prevent the Undo function in Microsoft Excel from simultaneously affecting multiple open workbooks.

How to Separate Excel Undo History Between Workbooks

Product: Microsoft Excel
Device & OS: Windows
Scenario: Editing multiple Excel workbooks at the same time and needing to undo changes in only one specific file without reverting changes in the others.
Observed behavior: By default, Excel shares a single undo stack across all workbooks opened in the same application instance, causing an undo action to apply to whichever workbook was last modified rather than just the active one.

Before you start

Make sure to save your current progress in all open Excel files. You will need to launch a completely new application instance of Excel, which operates separately from your currently active windows.

Solution 1Recommended

Open Workbooks in Separate Excel Instances

Forcing Excel to open a completely new application instance isolates the undo history, ensuring changes in one workbook do not affect the other.

Because Microsoft Excel defaults to sharing a single undo history across the entire application, the only native workaround is to force the software to run multiple instances of itself. Each instance maintains its own independent undo memory.

Open the first workbook

Launch Microsoft Excel and open your first workbook normally.

Trigger a new instance

Press and hold the 'Alt' key on your keyboard. While still holding 'Alt', right-click the Excel icon on your Windows taskbar.

Select Excel from the jump list

Click on 'Excel' in the menu that appears. Continue holding the 'Alt' key until a prompt asks, 'Do you want to start a new instance of Excel?'

Confirm and open the second workbook

Release the 'Alt' key and click 'Yes'. A new, independent Excel window will open. Use this new window to open your second workbook. Their undo histories are now completely separated.

Open Workbooks in Separate Excel Instances

Limitations of Separate Instances: Because these workbooks are now running in isolated instances, features like copy-pasting complex formulas, formatting, or linking data between the two workbooks may not behave the same as they do in a single instance.

Free Microsoft Office alternative

Try WPS Office for a Smoother Spreadsheet Experience

Frustrated by Excel's shared undo history and complex workarounds? WPS Office offers a free, lightweight, and highly compatible alternative. With an intuitive tabbed document interface, managing multiple spreadsheets without workflow interruptions has never been easier.

1. Download WPS Office: Visit the official WPS website to download the free installation package.
2. Install the Application: Run the installer and follow the on-screen prompts to set up WPS Office on your computer.
3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your files to enjoy isolated, tab-based workbook management.

Intuitive tabbed interface to effortlessly manage and navigate multiple workbooks.Seamlessly separate your workflow without relying on complex instance tricks.Fully compatible with Microsoft Excel formats including .xls, .xlsx, and .csv.Free and lightweight, consuming significantly fewer system resources.Familiar user interface that requires zero learning curve to migrate.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel share undo history across workbooks?

By default, Excel opens all files in the same application instance to optimize memory and allow seamless data sharing between files. The undo stack is tied to the application process rather than the individual file, causing undo actions to apply globally across all active workbooks in that window.

Can I separate Excel undo history on a Mac?

Mac operating systems handle application instances differently than Windows. macOS typically limits applications to a single instance by design, making it much more difficult to force separate instances of Excel natively for isolated undo histories without using complex terminal commands.

Will separating instances affect copying and pasting between workbooks?

Yes. When workbooks are opened in separate instances, they do not share the Office clipboard in the same way. Copying and pasting complex data, formulas, or specific formatting between them may result in losing dynamic links or advanced attributes.

Is there a setting to change the default undo behavior in Excel?

No, Microsoft Excel does not currently offer a built-in toggle or settings menu option to separate undo histories within a single instance. Running files in separate application instances is the only native workaround available.

Office App Problems