.png?width=100&auto=webp&quality=80&disable=upscale "Picture of John Savill")
.png?width=400&auto=webp&quality=80&disable=upscale "John Savill")
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
How can I change the number of undo levels in Microsoft Excel 2000 and later?
John Savill
March 27, 2003
1 Min Read
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_USERSoftwareMicrosoftOffice10.0ExcelOptions registry subkey for Excel 2002, or navigate to the HKEY_CURRENT_USERSoftwareMicrosoftOffice9.0ExcelOptions 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.
Close the registry editor.
Read more about:
MicrosoftAbout the Author
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
