Copying Cell Formats

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.

Copy a Cell Format

Select a cell or range containing the formatting you want to copy.

Click the Format Painter button on the Standard toolbar. If necessary, click the Toolbar Options list arrow to display the button.

Drag to select the cell(s) you want to paint. When you release the mouse button, the cells appear with the new formatting.

Did You Know?

You can use the Esc key to cancel format painting . If you change your mind about painting a format, cancel the marquee by pressing Esc.