If you want to repeat any action in any Microsoft Office Program, press F4. This works in all MS Office programs – Excel, Word, Powerpoint, etc.
Here are some of the things that you can do with this simple keyboard shortcut
- You can apply complex formatting to a cell. After that, you can go to another cell and press F4 and your formatting will be applied to the new cell – this can be as simple as changing the background color of a cell in Excel or changing the font family or font size in Word.
- You can delete a row from Excel and then press F4 after moving the cursor to other rows that you want to delete.
Try pressing F4 after various actions you do in Microsoft Word or MS Excel and see what happens. Soon, you will learn to love this shortcut, which I use all the time.
In case you press F4 to repeat an action and it resulted in some unintended consequence like deleting a line or removing the formatting, etc., don’t worry – another very useful keyboard shortcut will come to your rescue. That is CTRL + Z for undoing any action. This also works in all MS Office Programs.