There are many reasons to use drawing objects and formatting in your MS Excel worksheets to create graphics.
So you create a drawing object and then you take lots of time to format it and tweak it until it fits your specifications. In the latest versions of MS Excel there are tons of colors, shadows and other cool effects that you can apply to your drawing objects.
So now you have your object exactly the way you want it and you want to create other drawing objects that will look just like it right down to the last detail. But whoa…that took a long time to do! Luckily you do not have to recreate the wheel!
You can simply copy your exact formatting from one object to another and it is fairly easy. Use the Format Painter!
Follow the steps below to learn how:
- Select your formatted object.
- Click the Format Painter tool in the Clipboard group on the Home tab.
- As you may recall, in earlier versions of Excel, the Format Painter resided on the Standard toolbar.
- Now click the object you want to copy your formatting to.
- To copy your formatting to multiple objects, select the formatted object and double-click the Format Painter toll in the Clipboard group on the Home tab.
- Now click each object to which you would like to copy your formatting.
- When you have finished, just click the Format Painter once more to turn it off.
It doesn’t get much simpler than that!