Here’s a great time-saving tip to use when you’re formatting an email, Excel worksheet, Word document, or PowerPoint presentation. This tip is about taking the last format you used and applying it to other things.
Use the F4 function key to repeat formatting.
After you have applied a format to something….
- Select another cell, multiple cells, text, or object(s) that you wish to apply that same formatting to,
- Press the F4 function key
– The target(s) takes on the formatting that you last applied.
The F4 Repeat Formatting method does just that – it repeats the format that was last applied. The beauty of this is that any other formatting of the target will be unaffected.
Note to Excel users: what makes this feature so much faster than the Format Painter is that you can use one hand to tap the up/down/left/right arrow keys, while the other hand taps the F4 key, thus not needing to use the mouse at all.
To read more about using F4 like this and its difference to the Format Painter, click here.
Check out our Archive of Tech Tips. To check it out, click here, then hit the “End” key on your keyboard to jump to the end of the Archive list where the most recent Tips are.
Was this tip helpful to you? Anything else you want to know? Please leave a comment below.
You’ll find more learning at Learning and Development