Repeat Last Action in Excel
Excel allows you to instantly repeat your last action without performing the steps again manually. This shortcut is extremely useful for repetitive formatting and editing tasks.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| F4 | Cmd + Y |
What Does This Shortcut Do?
Pressing F4 (Windows) or Cmd + Y (Mac) repeats the last action you performed, such as formatting a cell, inserting a row, or applying a border.
How to Use the Shortcut
- Perform an action in Excel (for example, format a cell)
- Select another cell or range
- Press F4 (Windows) or Cmd + Y (Mac)
- The last action will be repeated
Tips & Best Practices
- Works best for formatting and layout actions
- Does not repeat actions like typing text
- Saves a lot of time when applying the same change repeatedly
FAQ
- Q: What is the difference between Repeat and Redo?
- Repeat performs the last action again, while Redo restores an undone action.
- Q: Does F4 always work?
- F4 works for most actions, but not all commands are repeatable.