Undo Levels in Excel – Not a Question

  VoG II 18:58 16 Jul 2005
Locked

The default undo level in Excel is four. This can be increased to any number up to 100.

Start, Run, type

regedit

and click OK. Navigate to

HKEY_CURRENT_USER\Software\Microsoft\Office\{Version}\Excel\Options

right click and create a new DWORD 'UndoHistory' with a value equal to the number of levels required.

Backup the registry first click here

  Chris the Ancient 19:41 16 Jul 2005

Great tip.

MegaThanks!

CtA

  stalion 19:49 16 Jul 2005

do not use it myself but mega bytes to you and good evening

  Graham ® 20:00 16 Jul 2005

Thanks, that's handy to know.

  VoG II 22:58 16 Jul 2005

Bump and close.

  daba 23:54 18 Jul 2005

On Win 98SE, Office '97 there is no "Options" 'folder' in that path VoG.

There is however, a further folder called "Microsoft Excel" under "Excel" that seems to contain a lot of configuration options, some even called Option, Option3, Option5, etc., do you think this is where I should place this new DWord.

Can the same thing be done for the other Office programs, eg. Word, Access, Powerpoint, etc. do you think ?

  daba 23:59 18 Jul 2005

Answer it myself, YES, thats where to put the DWord for Office '97 on Windows 98.

Works a treat, thanx VoG.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

Political cartoons in 2017: Chris Riddell, Rebecca Hendin and Dave Brown on what it’s like to…

The best iPhone for 2017

Tennis : comment regarder la finale de la Coupe Davis 2017 ?