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 Comment

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

    Great stuff – didn’t know this trick 🙂

Leave a Comment