Keyboard Shortcut to Do Something Again

Undo an action

To undo an action press Ctrl+Z.

If you prefer your mouse, click Undo on the Quick Access Toolbar. You lot tin can printing Undo (or CTRL+Z) repeatedly if you want to undo multiple steps.

You tin can't undo some actions, such equally clicking commands on the File tab or saving a file. If yous tin't undo an activity, the Undo control changes to Tin't Undo.

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

Redo an action

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

If you prefer to employ the mouse, click Redo on the Quick Admission toolbar. (The Redo button merely appears after yous've undone an action.)

Echo an action

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

If you adopt to utilize the mouse, click Repeat on the Quick Access Toolbar.

Notes:

• By default, the Echo command is not available on the Quick Access Toolbar in Excel. If you want to echo the final action, you demand to add together the Repeat command to the Quick Admission Toolbar showtime. Encounter 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 prison cell in Excel, can't be repeated. If you lot tin't repeat the final activeness, the Repeat command changes to Can't Repeat.

Excel and all other Function programs have a default undo/redo maximum of 100 deportment. Even so, you tin can alter this by adding an entry in the Microsoft Windows registry.

Important:Remember that some actions, such as 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 action unavailable.

Warning:Increasing the number of undo levels should exist done with circumspection and moderation: the more y'all 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 tin do the same in Discussion or PowerPoint.

1. Shut any Part programs that are running.

2. In Windows 10 or Windows 8, right-click the Start button and click Run.

   In Windows vii or Windows Vista, click Offset.

   In Windows XP, click the Start push, and then click Run.

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

   Depending on your version of Windows, y'all may be asked to confirm that you want to open Registry Editor.

4. In Registry Editor, aggrandize ane of the following registry subkeys, as appropriate for the version of Excel that yous are running:

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

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

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

   • Excel 2016: HKEY_CURRENT_USER\Software\Microsoft\Function\16.0\Excel\Options

5. On the Edit card, point to New, and then click DWORD Value. Select New Value #i, blazon UndoHistory, and and so printing ENTER.

6. On the Edit menu, click Alter.

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

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

Related links

Customize the Quick Access Toolbar (Windows)

Configure or plow off automatic text formatting (AutoFormat)

Undo an action

Printing + Z until yous've fixed the event.

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

You can't undo some deportment, such as clicking commands on the File menu or saving a file. If you tin't undo an action, the Undo command changes to Can't Undo.

To undo several actions at the same fourth dimension, click the arrow side by side to Undo, select the deportment in the listing that you lot want to undo, and then click the listing.

Redo an activeness

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

Or, click Redo in the upper-left corner of the ribbon. (The Redo button simply appears after you've undone an activity.)

Repeat an action

To repeat something simple, such as a paste operation, press + Y.

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

In Word for the web, PowerPoint for the web, and Excel for the web, you lot can disengage or redo basic actions. More advanced options are bachelor in desktop versions of Office.

Disengage an activeness

Press Ctrl+Z or click (Undo) in the ribbon until you've fixed the result.

You can't undo some actions, such as clicking commands on the File tab or saving a file. If you can't undo an action, the Undo command is dimmed. .

Redo an action

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

hellernursucher.blogspot.com

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

Share this post