• Dp

How To Copy and Apply Formatting For Any Chart With Paste Special Option

In this video tutorial, let us learn how to copy formatting from any chart and apply the same to other unformatted charts in Excel.

This can be done using the paste special option to copy and apply formats. This is superb easy trick with which we can save lot of time and efforts.

Let us take an example where we have got 4 charts and we have applied some good formatting styles for first chart and then wish to apply the same format style to other 3 charts suing some shortcut or easier way.

So, let us perform the trick now step by step.

Step 1: Select the 1st chart which has been rightly formatted and right click to copy the chart

Step 2: Select the 2nd chart to format , at the top left corner, under paste, click on Paste special...

Step 3: Now, in this paste special dialog box, under paste, select the "Formats" option.