Undo Levels in Excel – Not a Question

  VoG II 18:58 16 Jul 05
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 05

Great tip.

MegaThanks!

CtA

  stalion 19:49 16 Jul 05

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

  Graham ® 20:00 16 Jul 05

Thanks, that's handy to know.

  VoG II 22:58 16 Jul 05

Bump and close.

  daba 23:54 18 Jul 05

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 05

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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch