Use the Format Painter to quickly copy formatting

You can use the Format Painter to quickly apply formatting from text, shapes, and pictures to another text selection, shape, or picture. For example, you can quickly copy a picture border from one picture to another, or copy shape formatting from one shape to multiple shapes.

This article covers using the Format Painter for the programs listed below. To use the Format Painter in Word, see Use the Format Painter.

For these Office 2010 programs:


Excel

  1. Select the shape, text, or worksheet cell that has the formatting that you want to copy.
  2. On the Home tab, in the Clipboard group, click Format Painter.

Format Painter command on the ribbon

The pointer changes to a paintbrush.

 Note    Double-click the Format Painter button if you want to copy the formatting to multiple selections.

  1. Select the shape, text, or worksheet cell that has the formatting 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.

  1. To stop formatting, press ESC.

 Tip    You can quickly copy column widths. To 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 column that you want to apply the column width to. You cannot copy the column width if a merged cell includes the column from which you want to copy the width.

Top of Page Top of Page

Outlook

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

 Note    If you want to copy text formatting, select a portion of a paragraph. If you want to copy text and paragraph formatting, select an entire paragraph, including the paragraph mark.

  1. On the Message tab, in the Clipboard group, click Format Painter.

 Tip    The Format Painter is also available in appointments, meetings, and tasks. It is located on the Format Text tab in the Clipboard group.

Format Painter command on the ribbon

The pointer changes to a paintbrush icon.

 Note    Double-click the Format Painter button if you want to copy the format to multiple selections.

  1. Select the text, shape, or picture that you want to format.

For text selections with multiple words, clicking within a word applies the formatting to that word only, and dragging across the text selection applies the formatting to all of the words.

  1. To stop formatting, press ESC.

Top of Page Top of Page

PowerPoint

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

Format Painter command on the ribbon

The pointer changes to a paintbrush icon.

 Note    Double-click the Format Painter button if you want to copy the formatting to multiple selections.

  1. Select the text, shape, or picture that you want to format.

For text selections with multiple words, clicking within a word applies the formatting to that word only, and dragging across the text selection applies the formatting to all of the words.

  1. To stop formatting, press ESC.

 Tip    If you are using PowerPoint, you can use the Animation Painter to quickly copy animations. You can also watch a video of the Animation Painter.

Top of Page Top of Page

Publisher

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

Format Painter command on the ribbon

The pointer changes to a paintbrush icon.

 Note    Double-click the Format Painter button if you want to copy the formatting to multiple selections.

  1. Select the text, shape, or picture that you want to format.

For text selections with multiple words, clicking within a word applies the formatting to that word only, and dragging across the text selection applies the formatting to all of the words.

  1. To stop formatting, press ESC.

Top of Page Top of Page

 
 
Applies to:
Excel 2010, Outlook 2010, PowerPoint 2010, Publisher 2010