Keyboard Shortcuts (F4) - Format Repeater

Published: 14 March 2019
on channel: Summit Solutions Excel Training

747

We often need to repeat a particular format on cells that are not necessarily connected. Even using the Format Painter which enables us to apply more than one Format at a time can be time-consuming as we need to keep on re-selecting it.

The Function Key F4 enables us to Repeat the last Formatting action. It’s important to note that this is not a shortcut to repeat the Format Painter. The Format Painter re-applies all formats from the copied cell(s). The F4 key simply applies the last Formatting action.

Hint: To get this feature to apply more than one format at a time, use the Format Dialogue box (ctrl + 1) to apply multiple formats initially instead of using the Commands o the Home Ribbon.

Watch video Keyboard Shortcuts (F4) - Format Repeater online, duration hours minute second in high quality that is uploaded to the channel Summit Solutions Excel Training 14 March 2019. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 747 times and liked it 6 visitors.

11,720

318