Use Format Painter Multiple Times

To copy the format from one cell to multiple places, without repeatedly needing to click the Format Painter icon:

1.Select the cell

2.Double-Click the Format Painter Iconpainter icon

Note: This will keep the paint brush next to your cursor: painter pointer

3.Click every cell you want to copy the format to

4.When finished, click the Format Painter icon again or hit ESC to remove the paint brush from your cursor


  1. Alberto on October 21, 2018 at 7:53 am

    Great stuff – didn’t know this trick 🙂

  2. Mcquarazie on April 1, 2020 at 7:04 am

    Cool trick!

  3. Dave on August 26, 2020 at 11:03 am

    Thanks, knew it was possible but kept thinking of the wrong technique!

Leave a Comment