Excel: how to undo in current file only?
Excel: how to undo in current file only?
Excel: how to undo in current file only?
Re: 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 ( `C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE` )
- 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:
`"C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" "C:\Noiselezz\financial\shared financial\Sales Sheet.xlsb"`
Sadly Microsoft really have little clue about how customers actually use their products. The Undo madness is one sign of this - they blindly continue with the most ridiculous method of undo known to humankind. Its not even consistent with other Office products.
Another madness is the DDE system - the best way to slow down a computer - sometimes it takes 12 seconds before the launch even starts, because of DDE. I keep on fixing the registry settings to remove the DDE rubbish, but every time MS update Office, they helpfully 'fix' them.
I have worked in MS, and seen how they think - don't waste your time expecting them to change - that was 10 years ago and they are the same today.
- Make a NEW shortcut - right-click on your desktop, New, Short cut.
- Browse to the excel program ( `C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE` )
- 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:
`"C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" "C:\Noiselezz\financial\shared financial\Sales Sheet.xlsb"`
Sadly Microsoft really have little clue about how customers actually use their products. The Undo madness is one sign of this - they blindly continue with the most ridiculous method of undo known to humankind. Its not even consistent with other Office products.
Another madness is the DDE system - the best way to slow down a computer - sometimes it takes 12 seconds before the launch even starts, because of DDE. I keep on fixing the registry settings to remove the DDE rubbish, but every time MS update Office, they helpfully 'fix' them.
I have worked in MS, and seen how they think - don't waste your time expecting them to change - that was 10 years ago and they are the same today.