Excel allows you to undo, redo, and repeat specific actions. The undo, redo, and repeat buttons are in similar locations on both Mac and Windows, and the keyboard shortcuts are just a little different, too.
undo an action it just deletes the old entry. You can undo up to 100 actions. To undo an action using a keyboard shortcut, press “Ctrl+Z” on Windows or “Command+Z” on Mac.
If you’re using Excel for Windows, you can find the Undo button in the Undo group on the Home tab in the upper-left corner of the window. The Undo icon is a curved arrow pointing to the left.
On Mac, the Undo button can also be found in the upper left corner of the screen, above the menu bar.
If you undo an action but decide you shouldn’t have done it, you can take it back with the redo function. For redo an action Using a keyboard shortcut, press “Ctrl+Y” on Windows or “Command+Y” on Mac. Alternatively, on Windows, you can press the “F4” key to redo an action. If pressing the F4 key alone doesn’t work, you may need to press it together with the «fn» key .
In Excel for Windows, the Redo button is located in the Undo group on the Home tab in the upper-left corner of the window, just below the Undo button. The Redo icon is a curved arrow pointing to the right.
On Mac, the Redo button is located above the menu bar, to the right of the Undo button. By default, this button is the “Repeat” button until after undo an action. Once you undo an action, the Redo button changes to a Redo button.
The redo and repeat buttons will never be available at the same time.
Repeat an action, as the name implies, repeats the previously entered action. The keyboard shortcut for repeating an action is the same as for redoing an action (“Ctrl+Y” on Windows and “Command+Y” on Mac), which causes a bit of confusion. To make things more confusing, you can only repeat simple actions, like a copy and paste action. In most cases, you will only want to use the copy and paste instead of the repeat action function.
To repeat an action using the button in Windows, you’ll first need to add it to your Quick Access Toolbar. To do this, type “Repeat” into the search bar at the top of the screen, right-click “Repeat” in the search results, and then select “Add to Quick Access Toolbar.” (The option will be grayed out if it’s already on the Quick Access Toolbar.)
Now you can find the Repeat option on the Quick Access Toolbar. Once you’ve entered a repeatable action, you can click the Repeat button to repeat it.
On Mac, the Repeat button is located above the menu bar, to the right of the Undo button. This button is Redo by default, but it will be the Redo button if you recently undid an action.
As mentioned above, the repeat and redo buttons will never appear together at the same time.
This is just one of the many basic features available to you in Microsoft Excel, all of which can be done using a keyboard shortcut. How many more keyboard shortcuts learn in Excel, the more efficient you will be!