Using the Format Painter Toolbutton

The Format Painter toolbutton copies and pastes formats from one cell or range to another cell or range. To use it, do the following  

Excel Tip. To use the the Format Painter button to paint a format on a series of non-adjacent cells or ranges, select the cell with the desired format, then double-click on the Format Painter button. This will keep the button in the pressed position, allowing you to click on several cells or ranges to paste the format When you re done, click once on the button to return it to the unpressed state. 

---