See also

Excel

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.

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

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.

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.

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.