Both ‘Redo’ and ‘Repeat an Action’ have the same shortcut — ‘F4’ or ‘Ctrl + Y’ (‘⌘ + Y’ for Mac). However, they have entirely different functions.
Here’s a quick differentiation between the two:
- Redo is the opposite of ‘Undo’. It’s useful when you want to reverse an undo action.
- Repeat an action lets you… Well… Repeat an action! 😊
Like ‘Undo’, ‘Redo’ has certain limitations:
- By default, you can only redo up to 100 steps.
- You can’t redo an action that wasn’t caused by an undo action.
Here’s a good example of when to use the ‘Redo’ function:
You made a weekly expenses tracker and you just finished writing a ‘SUM’ formula of all your expenses during the week.
However, you mistakenly pressed ‘Ctrl + Z’ thinking you missed the first amount and deleted the formula.
Instead of rewriting it, all you have to do is use the ‘Redo’ function by pressing ‘F4’ (‘Ctrl/⌘ + Y’ if ‘F4’ doesn’t work).
By the way, there’s no way you can use the ‘Redo’ and ‘Repeat an Action’ functions at the same time.
To illustrate, let’s say you want to highlight all the amounts under the “Groceries” category:
All you have to do is highlight the first one manually.
Then, select the cells you want to highlight and press ‘F4’ (‘Ctrl/⌘ + Y’ if ‘F4’ doesn’t work).