Keyboard Shortcut (F4) – Format Repeater

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.

Featured Posts
Posts Are Coming Soon
Stay tuned...
Recent Posts
Search By Tags

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923


Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions