copy paste Excel chart format

How to copy Excel chart format

Here is a time-saving tip on how to copy an Excel chart format. It is not so easy as Format Painter that can quickly copy necessary cell formatting, but faster than starting from scratch.

1. Copy chart with desired format (Ctrl + C).

2. Select the chart that you would like to format.

3. Go to the Home tab, click under the Paste icon and choose Paste Special.

paste Excel chart format

4. Choose “Formats”.

paste Excel chart formats

copy and paste Excel chart format

Here is another little known Excel feature that helps to copy chart without blurry effect.





Leave a Reply

Your email address will not be published. Required fields are marked *