How can I change the number of undo levels in Microsoft Excel 2000 and later?

A. You can change the number of undo levels in Excel to any value from 0 to 100. The higher the number, the more resources the software will use to remember the previous states. To configure the number of undo levels, perform the following steps:

Start a registry editor (e.g., regedit.exe).

Navigate to the HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options registry subkey for Excel 2002, or navigate to the HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options registry subkey for Excel 2000.

From the Edit menu, select New, DWORD Value.

Enter the name UndoHistory, then press Enter.

Double-click the new value, set it to a value from 0 to 100, then click OK.