Copy and Reuse Formatting

You can quickly copy the formatting of items in your report, such as fonts, colors, borders, and number formats and apply that formatting to other items.

Steps

1. Click an item that has the formatting that you want to copy.

2. Do one of the following:

   • To copy all the formatting applied to the item, click the pick up style button , click the item that you want to format, and then click the apply style button.

   • To copy only one of the formatting styles, click the down arrow to the right of the pick up style button and click the style that you want to copy. Then, click the item that you want to format and click the apply style button.

3. If you want to make changes to a style that you copied, click the down arrow to the right of the pick up style button and click Edit Dropper Style. In the Style dialog box, specify basic and advanced style characteristics, and then click OK.