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

Lesson 21. Changing How Numbers Look > Copying Formats with Format Painter

Copying Formats with Format Painter

After applying a format to cell, you can easily copy that format to other cells. This works whether you're copying numeric or text formatting, or shading or borders, as you'll learn in upcoming lessons. Here's how to copy a format from one cell to another:

  1. Select the cell that contains the formatting you want to copy.

  2. Click the Format Painter button on the Standard toolbar. Excel copies the formatting. The mouse pointer changes into a paintbrush with a plus sign next to it.

  3. Click on one cell, or drag over several cells to which you want to apply the copied formatting.

  4. Release the mouse button, and Excel copies the formatting and applies it to the selected cells.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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