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

Part 3. Using Excel > Task 22 How to Copy Cell Formatting

Task 22 How to Copy Cell Formatting

If you have applied several formatting attributes (such as font, size, color, and borders) to a cell or range of cells and then later decide you want to apply the same formatting to another range, you don't have to apply those formats one by one to the new location. Instead, you can use Excel's Format Painter button to take all the formats from the original range and "paint" them across the new range.

  1. Click Format Painter

    Select the cell or range that has the formatting you want to copy. Then click the Format Painter button in the Standard toolbar.



  2. Mouse Pointer Changes

    The mouse pointer changes to a paintbrush pointer.



  3. Drag to Copy Formatting

    Drag the paintbrush pointer across the range where you want to paint the formatting. Release the mouse. The formatting is painted to the range of cells.



  4. Double-Click Format Painter

    To copy formatting from one cell or range to multiple cells or ranges, select the cell or range whose formatting you want to copy, and then double-click the Format Painter button.



  5. Drag Over the Ranges

    Drag the paintbrush pointer over the first range to which you want to copy the formatting. Drag over additional ranges or click cells to copy the formatting there as well.



  6. Turn Off Format Painter

    After you're done copying the formatting, click the Format Painter button again to turn it off.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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