Repeat Your Most Recent Action
For repetitive formatting tasks, remember the F4 key. Whenever you press that key, you repeat your most recent action, whether it was adding borders, applying bold formatting to a selected word, or inserting a file or picture.
Format Painter is better for applying complex formatting, but if you just need to repeat a single action, then F4 is the key to use
Editor's Note: This tip works in the following programs: Microsoft Excel, Microsoft PowerPoint®, Microsoft Visio®, and Microsoft Word.