Here’s a handy trick to know. 

We often find ourselves making an editing decision that we then need to reapply throughout an entire document or spreadsheet.  For instance, you may want to change the indent of your paragraphs. 

As long as you don’t make any other actions, you can repeat that action throughout your document.  It’s as simple as selecting the F4 key.

This is one of those understated CompuFiciency tricks.

Repeat the Last Action

Actions are generally defined as things you do with menus and title bars, like merging, formatting, running macros, etc, not typing in a cell. Sometimes you may like to repeat the last action easily, without going back through the menus again, there’s a shortcut!

Shortcut: Repeat the Last Action

Keys to press:
F4