How can I get Excel's undo/redo functionality to work in a more traditional *per window* manner (and not for the entire instance of Excel)?
This has been driving me crazy lately. I'm not used to having having a program have a global undo/redo functionality (as in when I undo something, it will undo the last action in any currently open Excel window). I'm used to having each open window having its own undo/redo list. How can I get Excel 2007 to function more traditionally like that?
Answer
If you want separate undo/redo lists, open separate instances of Excel.
If you simply open multiple files by double-clicking, they're opened in the same Excel process and share the same undo/redo list. If you manually open multiple instances of Excel and then open your files in those instances, they don't share the undo/redo list.
For further details, you might want to check out:
Comments
Post a Comment