Copy formatting between objects or text in Office 2011 for Mac

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 , 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 , and then click the other objects in succession. When you are done, click   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 , 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 , and then click the blocks of text in succession. When you are done, click again to turn off.

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 , 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 , and then click the other objects in succession. When you are done, click   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 , 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 , and then click the blocks of text in succession. When you are done, click again to turn off.

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 , 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 , and then click the other objects in succession. When you are done, click   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 , 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 , and then click the blocks of text in succession. When you are done, click again to turn off.