Copy formatting using the Format Painter

Use the Format Painter to quickly copy formatting from one thing in a document to another. Select the thing you like the look of, click Format Painter, and then click the thing you want to change to look the same. If you want to copy the formatting to more than one thing, double-click instead of single-clicking Format Painter. To exit the Format Painter, press Esc.

Format Painter picks up all the formatting from your first thing, whether it’s a shape, cell, picture border, or piece of text, and applies it to the second. This way, you can spend your time getting the first thing right, and apply the same formatting wherever you want in your document with a couple of clicks. Pick your app to learn more:

My app is:


Excel

  1. Select the shape, text, picture, or worksheet cell with the formatting you want to copy.
  2. Click Home, and in the Clipboard group, click Format Painter.

Format Painter on the Home tab in Excel

  1. After the pointer changes to a paintbrush, select the shape, text, or worksheet cell that you want to format.

To copy the formatting to a single cell, several cells, or a range or ranges of cells, drag the mouse pointer across the cells or ranges of cells that you want to format.

 Tip    To quickly copy the width of one column to a second column, select the heading of the first column, click Format Painter, and then click the heading of the second column. You can’t copy the column width if the column contains a merged cell.

Top of Page Top of Page

Outlook

  1. In an email message, select the text, shape, or picture with the formatting you want to copy.

To copy text formatting, select a portion of a paragraph. To copy text and paragraph formatting, select an entire paragraph, including the paragraph mark.

  1. Click Message, and in the Clipboard group, click Format Painter.

Format Painter on the Message tab in Outlook

  1. After the pointer changes to a paintbrush icon, select the text, shape, or picture you want to format.

 Tip    The Format Painter is also available in appointments, meetings, and tasks. You can find it on the Format Text tab in the Clipboard group.

Top of Page Top of Page

PowerPoint

  1. Select the text, shape, or picture with the formatting you want to copy.
  2. Click Home, and in the Clipboard group, click Format Painter.

Format Painter on the Home tab in PowerPoint

  1. After the pointer changes to a paintbrush icon, select the text, shape, or picture you want to format.

 Tip    After you add an animation, you can use the Animation Painter to quickly copy the animation to another slide.

Top of Page Top of Page

Publisher

  1. Select the text, shape, or picture with the formatting you want to copy.
  2. Click Home, and in the Clipboard group, click Format Painter.

Format Painter on the Home tab in Publisher

  1. After the pointer changes to a paintbrush icon, select the text, shape, or picture, you want to format.

Top of Page Top of Page

Word

  1. Select the text or graphic that has the formatting you want to copy.

To copy text formatting, select a portion of a paragraph. To copy text and paragraph formatting, select all of a paragraph, including the paragraph mark.

  1. Click Home, and in the Clipboard group, click Format Painter.

Format Painter on the Home tab in Word

  1. After the pointer changes to a paintbrush icon, select the text or graphic that you want to format.

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Outlook 2013, PowerPoint 2013, Publisher 2013, Word 2013