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. KPH August 21, 2016 at 6:56 am - Reply

    Superb.. Thanks…

  2. H== August 30, 2017 at 7:39 am - Reply


Leave A Comment