Copy formatting between objects or text

Which Office program are you using?

Word

PowerPoint

Excel

Word

Do any of the following:

Copy formatting to another picture or object

You can copy the formatting that you applied to an object and add it to another object. You can't, however, copy size or image effects such as distortions or blurring.

  1. On the View menu, click Print Layout.

  2. Click the object that has the formatting that you want to copy.

  3. On the Standard toolbar, click Format button , and then click the object that you want to copy the formatting to.

    Tip: To copy the formatting of an object to several other objects, double-click Format button , and then click the other objects in succession. When you are done, click Format button   again to turn off.

Copy text formatting

You can quickly copy the text formatting — for example, font style, size, and color — from one block of text to another block of text.

  1. On the View menu, click Print Layout.

  2. Select the text that has the formatting that you want to copy.

    Note: You can't copy the font and font size of WordArt text.

  3. On the Standard toolbar, click Format button , and then select the text that you want to apply the formatting to.

    Tip: To copy the text formatting to several blocks of text, double-click Format button , and then click the blocks of text in succession. When you are done, click Format button again to turn off.

See also

Apply or change a style or effect for a picture

Apply or remove styles and effects from objects

PowerPoint

Do any of the following:

Copy formatting to another picture or object

You can copy the formatting that you applied to an object and add it to another object. You can't, however, copy size or image effects such as distortions or blurring.

  1. Click the object that has the formatting that you want to copy.

  2. On the Standard toolbar, click Format button , and then click the object that you want to copy the formatting to.

    Tip: To copy the formatting of an object to several other objects, double-click Format button , and then click the other objects in succession. When you are done, click Format button   again to turn off.

Copy text formatting

You can quickly copy the text formatting — for example, font style, size, and color — from one block of text to another block of text.

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

    Note: You can't copy the font and font size of WordArt text.

  2. On the Standard toolbar, click Format button , and then select the text that you want to apply the formatting to.

    Tip: To copy the text formatting to several blocks of text, double-click Format button , and then click the blocks of text in succession. When you are done, click Format button again to turn off.

See also

Apply or change a style or effect for a picture

Apply or remove styles and effects from objects

Excel

Do any of the following:

Copy formatting to another picture or object

You can copy the formatting that you applied to an object and add it to another object. You can't, however, copy size or image effects such as distortions or blurring.

  1. Click the object that has the formatting that you want to copy.

  2. On the Standard toolbar, click Format button , and then click the object that you want to copy the formatting to.

    Tip: To copy the formatting of an object to several other objects, double-click Format button , and then click the other objects in succession. When you are done, click Format button   again to turn off.

Copy text and cell formatting

You can quickly copy the text formatting — for example, font style, size, and color — from one block of text to another block of text. When you copy text formatting, cell formatting, such as patterns, borders, and alignment, are copied to another cell.

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

    Note: You can't copy the font and font size of WordArt text.

  2. On the Standard toolbar, click Format button , and then select the text that you want to apply the formatting to.

    Tip: To copy the text formatting to several blocks of text, double-click Format button , and then click the blocks of text in succession. When you are done, click Format button again to turn off.

See also

Apply or change a style or effect for a picture

Apply or remove styles and effects from objects

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×