This is a tip from Michael. It’s a four minute video that shows how to increase or decrease the undo history in Excel (from the default 16 undo items) by editing the registry.
Increase Undo Actions Flash Video
Thanks for the tip Michael.
11 thoughts on “Increasing Undo”
Posting code? Use <pre> tags for VBA and <code> tags for inline.
I have a link that does this via VBA.
Done a while ago so you may need to change version number.
I was using 2000 (9) @ the time.
http://www.xcelfiles.com/VBA_Quick20.html
Ivan:
No code displays on the link you gave and even when selecting the option below from the page no code displays…
If you cannot see the code Window below with code in it then click here.
Could you show the code here?
Thanks…
doco
You just gotta love my whiskey and sex ladened voice.
Doco: I had no problems with Firefox 1.0.7.
And, that reminds me. A upgrade to 1.5 is long overdue.
Problems with FireFox?
Upgrade to Firefox 1.5 or turn off “obj-tabs” in ADBLOCK
Dave Ritchie gave me the heads up on this a while back.
David McRitchie!! Sorry David!
Firefox is not an option… But thanks anyway.
Doco: I had no problems with IE 6. So, I assume IE6 is not an option either.
hehehe… Nice try Tushar.
I am not sure what the issue is/was. I can ‘see’ it just fine at the office (IE6), but still not at home (IE6). So, I just wrote my own.
|o)
I have 2 monitors, so I did the regedit while the video was playing. It works perfectly. I typed 63 x’s in a column (one at a time), and all but three would undo. I tried highlighting a range greater than 60 (actually 229) rows, then typed “x”, then Ctrl+Enter, but that counts as only one action, so it undid all 229 entries at once.
I’m expert certified, but that’s only a piece of paper (or, pizza paper, if said “correctly”), and I am so happy to find a site where I can continue to add tools to my toolbox, as it were. When I learn something new that is quick and easy, I share it with my teammates at work. When they learn a new speed-up, they are pickled tink (er, tickled pink), because it saves them time and effort.
Thanks for what I’ve learned, and for what I will continue to learn!
Where are the “undo’s” stored – is this in memory or is it cached to disc?
If MS do not recommend increasing this to greater than 100 (according to Ivan’s code comments) what is the optimal number and what impact does this have on performance (if any)?