Excel® 2013 On Demand

Copying Cell Formats

After formatting a cell on a worksheet, you might want to apply those same formatting changes to other cells on the worksheet. For example, you might want each subtotal on your worksheet to be formatted in italic, bold, 12-point Times New Roman, with a dollar sign, commas, and two decimal places. Rather than selecting each subtotal and applying the individual formatting to each cell, you can paint (that is, copy) the formatting from one cell to others. The Format Painter lets you “pick up” the style of one section and apply, or “paint,” it to another. To apply a format style to more than one item, double-click the Format Painter button on the Home tab instead of a single-click. The double-click keeps the Format Painter active ...