How to break the Excel undo limit

Excel does data statistics, sometimes need more undo times, but the default number of undo may not be enough, how to do? Today teaches you how to break through Excel's undo limit, hurries to see how to operate!

　　Steps/Methods

　　1. Click the Start menu, click Run, enter "regedit" in the Open dialog box, and point to "OK".

2. In the Open Registry Editor, expand Hkey_current_usersoftwaremicrosoftoffice12.0 exceloptions, as shown in the figure, Note 12.0 is the corresponding registry entry for Excel, if you are using version 2003, the corresponding 11.0.

3. Right-click a blank space in the right form and select DWORD value under New.

4. Right-click the newly created file and rename it to "Undohistory" as shown in the figure.

5. Double-click "Undohistory" to open the "Edit DWORD Value" dialog box, set the cardinality to "decimal", and enter the number of times you want to undo in the numeric data.

6. When you close the Registry Editor, restarting your computer will take effect. There's no need to worry about undo times!