The format painter is a very useful feature that can be accessed from the standard toolbar. With the format painter you can format a cell or selection of cells with an existing format from another cell.

 

 

To use the Format Painter, select a cell by clicking on it, and then click the paint brush button on the standard tool bar.

 

 

The cell that you selected will be enhanced with a flashing dark and light border and your mouse pointer will turn into a thick cross with a paint brush beside it. When this happens, any cell or range you select with the cross and paint brush pointer will assume the format of the cell that you selected your format from (you paint your selection with the format from the original cell).