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 Icon
Note: This will keep the paint brush next to your cursor: 
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
May 28th, 2005 at 8:21 am
Thanks for the tip. I use the format painter a lot and nowit will be even easier.
May 28th, 2005 at 11:37 am
I used it for years, going back and forth…yep, that one is handy.
October 16th, 2008 at 7:57 pm
amzing… always had a yearning for doing this with macro…great tip