Warning: Increasing the number of undo levels should be done with caution and moderation: the more you increase the number of undo levels, the more random access memory (RAM) Excel requires to store the undo history, which affects the performance of Excel. The following procedure uses the Registry Editor to change the number of undo levels for Excel, although you can do the same in Word or PowerPoint. Close any Office programs that are running. In Windows 10 or Windows 8, right-click the Start button and click Run. In Windows 7 or Windows Vista, click Start. In Windows XP, click the Start button, and then click Run.
You may need to repeatedly do same operation while creating an Excel worksheet, for example, keep inserting blank rows in a worksheet. This article will show you how to quickly repeat the last or previous action in Excel. For instance, after inserting a blank new row in your worksheet, press the F4. You can perform a “Repeat Last Action” in Mac Excel by pressing the + key combination. For example, after defining formatting for one cell, you can repeat that formatting step by selecting new cells and then pressing Cmd+6.
In the search box or the Run window, type regedit and press Enter. Depending on your version of Windows, you may be asked to confirm that you want to open Registry Editor. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:. Excel 2007: HKEYCURRENTUSER Software Microsoft Office 12.0 Excel Options. Excel 2010: HKEYCURRENTUSER Software Microsoft Office 14.0 Excel Options.
![Excel for mac how to repeat previous action video Excel for mac how to repeat previous action video](/uploads/1/2/5/4/125467098/812538160.png)
Excel 2013: HKEYCURRENTUSER Software Microsoft Office 15.0 Excel Options. Excel 2016: HKEYCURRENTUSER Software Microsoft Office 16.0 Excel Options. On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.
On the Edit menu, click Modify. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value in the Value box, click OK, and then exit Registry Editor. Start Excel.
Excel stores an undo history for the number of actions that you specified in step 7. Related links.