Excel: how to undo in current file only?
Problem
Microsoft Excel's undo / redo feature behaves unlike any other program I know. The undo stack seems to be global across all open files, so that undoing sometimes switches to another file and undoes something you didn't want to undo. And if an edit you want to undo was before an edit in another file, you have no choice but to undo the other file. I am not the first to complain about this - see "Excel's undo madness", about halfway down. Besides "edit only one file at a time", is there a way to make Excel's Undo apply to the current file only? I'm using Excel 2003 if it makes a difference.
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Fix for: Excel: how to undo in current file only?
The way 'around' it is to open multiple copies of Excel, one per worksheet. This is really annoying, but there is no other way. I have special shortcuts for my main spreadsheets, just to open them explicitly. To do this: Make a NEW shortcut - right-click on your desktop, New, Short cut. Browse to the excel program ( ) Create the shortcut and name it Edit the shortcut, and put the filename, in quotes, after the program, in the shortcut. So you end up with a 'Target' such as: Sadly Microsoft real…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix