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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…