How does the Repeat feature work?
If you need to repeat a command or dialog box command, Excel’s Repeat feature enables you to redo an action quickly. To use Repeat, from the menu bar choose Edit – Repeat. The command will reflect the operation you’re trying to repeat. Shortcut: Press F4 to activate Repeat without accessing a menu or Click on the Repeat tool in the Standard toolbar.