• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Formatting a Worksheet > 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint