Daily posts of Excel tips…and other stuff
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.
Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].
Ivan f Moala:
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
9 April 2006, 1:51 amdoco:
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…
9 April 2006, 7:37 amdoco
Mike Alexander:
You just gotta love my whiskey and sex ladened voice.
9 April 2006, 10:07 amTushar Mehta:
Doco: I had no problems with Firefox 1.0.7.
And, that reminds me. A upgrade to 1.5 is long overdue.
9 April 2006, 11:11 amMike Alexander:
Problems with FireFox?
9 April 2006, 1:13 pmUpgrade to Firefox 1.5 or turn off “obj-tabs” in ADBLOCK
Dave Ritchie gave me the heads up on this a while back.
Mike Alexander:
David McRitchie!! Sorry David!
9 April 2006, 1:14 pmdoco:
Firefox is not an option… But thanks anyway.
9 April 2006, 5:34 pmTushar Mehta:
Doco: I had no problems with IE 6. So, I assume IE6 is not an option either.
10 April 2006, 8:00 amdoco:
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)
11 April 2006, 8:35 amBob Tiller:
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!
6 April 2007, 5:36 amSimon Herbert:
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)?
10 April 2007, 5:15 am