Excel: How to change Excel’s number of Undo levels?

Q.  Is there a way to change Excel's number of undo levels/numbers.
In Excel 2003 the maximum No. of undo actions is 16 and I would like it to be at least 50

A.  The answer is yes you can change Excel’s number of Undo levels.
To change the number of Undo levels, follow these steps:

1. Close Excel
2. Click Start, Run and type REGEDIT
3. Go to HKEY_CURRENT_USER\Software\Microsoft\Office.0\Excel\Options.
4. Right-click in the right pane and choose New, DWORD Value.
5. Name the new entry UndoHistory and press ENTER to apply the name.
6. Edit DWORD Value dialog box
7. In the Base group box, make sure the Decimal option button is selected.
8. In the Value Data text box, enter the number of Undo levels you want (0 to 100)
9. Click OK.

Now you shoul be able to undo your actions in Excel as many times as you like.
Excel tips and tricks copyright adminspy.com