Keyboard Shortcut (F4) – Format Repeater

March 14, 2019

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 on the Home Ribbon.

 

 

 

Share on Facebook
Share on Twitter
Please reload

Featured Posts

Excel Tip – Quickest way to move a column!

November 6, 2019

1/1
Please reload

Recent Posts