Javascript required
Skip to content Skip to sidebar Skip to footer
Home / How to Get Undo to Work Again in Excel

How to Get Undo to Work Again in Excel

Undo an action

To disengage an action press Ctrl+Z.

If y'all prefer your mouse, click Disengage on the Quick Access Toolbar. Yous can press Disengage (or CTRL+Z) repeatedly if yous want to undo multiple steps.

The Undo command on the Quick Access Toolbar

You can't undo some actions, such as clicking commands on the File tab or saving a file. If y'all can't undo an action, the Undo command changes to Can't Undo.

To undo several actions at the same time, click the pointer side by side to Undo Undo button, select the deportment in the list that you want to undo, and then click the list.

Redo an action

To redo something you lot've undone, printing Ctrl+Y or F4. (If F4 doesn't seem to work, yous may need to press the F-Lock key or Fn Key, so F4).

If y'all prefer to use the mouse, click Redo on the Quick Access toolbar. (The Redo push button only appears after you've undone an action.)

The Redo command on the Quick Access Toolbar

Echo an action

To repeat something unproblematic, such as a paste operation, press Ctrl+Y or F4 (If F4 doesn't seem to piece of work, you may need to press the F-Lock key or Fn Key, then F4).

If yous adopt to employ the mouse, click Repeat on the Quick Access Toolbar.

The Repeat command on the Quick Access Toolbar

Notes:

  • By default, the Repeat command Button image is not available on the Quick Access Toolbar in Excel. If you want to repeat the last activeness, you need to add the Repeat control to the Quick Access Toolbar first. See Add a command to the Quick Access Toolbar that isn't on the ribbon for steps.

  • Some actions, such as using a function in a cell in Excel, can't be repeated. If y'all can't repeat the last activity, the Repeat control changes to Can't Echo.

Excel and all other Office programs have a default undo/redo maximum of 100 actions. Notwithstanding, you can change this by adding an entry in the Microsoft Windows registry.

Important:Retrieve that some deportment, such every bit clicking commands on the File tab or saving a file, can't be undone, and running a macro in Excel will clear the undo stack, making the activity unavailable.

Alarm:Increasing the number of undo levels should exist done with caution and moderation: the more you lot increase the number of undo levels, the more random access retentivity (RAM) Excel requires to store the undo history, which affects the performance of Excel.

The following process uses the Registry Editor to change the number of undo levels for Excel, although you lot can practise the same in Discussion or PowerPoint.

  1. Close any Role programs that are running.

  2. In Windows 10 or Windows 8, correct-click the First button and click Run.

    In Windows seven or Windows Vista, click Commencement.

    In Windows XP, click the First push button, and then click Run.

  3. In the search box or the Run window, type regedit and press Enter.

    Depending on your version of Windows, you lot may be asked to ostend that you want to open up Registry Editor.

  4. In Registry Editor, aggrandize one of the post-obit registry subkeys, as appropriate for the version of Excel that you are running:

    • Excel 2007: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options

    • Excel 2010: HKEY_CURRENT_USER\Software\Microsoft\Function\14.0\Excel\Options

    • Excel 2013: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options

    • Excel 2016: HKEY_CURRENT_USER\Software\Microsoft\Function\sixteen.0\Excel\Options

  5. On the Edit menu, indicate to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.

  6. On the Edit menu, click Modify.

  7. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value in the Value box, click OK, and and so exit Registry Editor.

  8. Beginning Excel. Excel stores an undo history for the number of deportment that you specified in step 7.

Related links

Customize the Quick Access Toolbar (Windows)

Configure or turn off automated text formatting (AutoFormat)

Undo an activeness

Press COMMAND+ Z until you've fixed the issue.

Or, click Undo in the upper-left corner of the ribbon.

The Undo command is highlighted on the ribbon.

You tin't undo some actions, such as clicking commands on the File menu or saving a file. If y'all tin can't disengage an action, the Disengage control changes to Can't Undo.

To undo several deportment at the same time, click the arrow next to Undo, select the actions in the list that you want to undo, and then click the list.

Redo an activity

To redo something you've undone, press COMMAND + Y.

Or, click Redo in the upper-left corner of the ribbon. (The Redo button but appears later on you've undone an action.)

The Redo command is highlighted on the ribbon.

Repeat an action

To echo something simple, such every bit a paste operation, press COMMAND + Y.

Or, click Echo in the upper-left corner of the ribbon.

The Repeat icon is highlighted on the ribbon.

In Word for the web, PowerPoint for the web, and Excel for the spider web, you can disengage or redo basic actions. More avant-garde options are available in desktop versions of Part.

Disengage an action

Press Ctrl+Z or click Undo button in Word Online (Undo) in the ribbon until you've fixed the upshot.

undo a change in Word Online

You can't undo some actions, such as clicking commands on the File tab or saving a file. If you tin can't undo an activity, the Undo control is dimmed. undo button when undo isn't available in Word Online.

Redo an action

To redo something you lot've undone, press Ctrl+Y or click redo a change in word online (Redo) in the ribbon.

redo a change in word online

stacyagnsur.blogspot.com

Source: https://support.microsoft.com/en-us/office/undo-redo-or-repeat-an-action-84bdb9bc-4e23-4f06-ba78-f7b893eb2d28