How to Do the Same Action Over Again Hot Key Excel

Undo an action

To disengage an action printing Ctrl+Z.

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

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

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

Redo an action

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

If yous adopt to utilise the mouse, click Redo on the Quick Access toolbar. (The Redo button merely appears afterward yous've undone an activity.)

Repeat an activeness

To repeat something simple, such every bit a paste functioning, printing Ctrl+Y or F4 (If F4 doesn't seem to work, y'all may need to press the F-Lock key or Fn Fundamental, then F4).

If you prefer to apply the mouse, click Echo on the Quick Access Toolbar.

Notes:

• By default, the Repeat command is not available on the Quick Access Toolbar in Excel. If you want to repeat the concluding activeness, you lot need to add the Repeat command to the Quick Access Toolbar first. Come across Add a command to the Quick Admission 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 you can't repeat the last activity, the Repeat control changes to Can't Repeat.

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

Important:Recollect that some deportment, such as clicking commands on the File tab or saving a file, tin't be undone, and running a macro in Excel will clear the undo stack, making the action unavailable.

Alarm:Increasing the number of undo levels should be washed with circumspection and moderation: the more than you increase the number of undo levels, the more random access retentiveness (RAM) Excel requires to store the undo history, which affects the performance of Excel.

The following procedure uses the Registry Editor to alter the number of disengage levels for Excel, although yous tin can do the same in Word or PowerPoint.

1. Close any Office programs that are running.

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

   In Windows 7 or Windows Vista, click Offset.

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

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

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

4. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:

   • Excel 2007: HKEY_CURRENT_USER\Software\Microsoft\Function\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\Role\16.0\Excel\Options

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

6. On the Edit menu, click Alter.

7. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value in the Value box, click OK, and then go out 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 turn off automated text formatting (AutoFormat)

Undo an action

Printing + Z until you've fixed the issue.

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

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

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

Redo an action

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

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

Echo an action

To echo something simple, such as a paste performance, printing + Y.

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

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

Undo an activeness

Printing Ctrl+Z or click (Disengage) in the ribbon until yous've fixed the upshot.

Y'all can't disengage some deportment, such as clicking commands on the File tab or saving a file. If you can't undo an action, the Disengage command is dimmed. .

Redo an action

To redo something yous've undone, printing Ctrl+Y or click (Redo) in the ribbon.

witherssuldy1984.blogspot.com

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

Share this post