电子禅国际__您我的精神家园
发新话题

Use Paste Special to Speed up Chart Formatting

Use Paste Special to Speed up Chart Formatting

Use Paste Special to Speed up Chart Formatting [Quick Tip]

Posted on February 24th, 2010 in Charts and Graphs - 34 comments

Excel Paste Special is one of my favorite features. So I was naturally thrilled when I discovered that you can use paste special to paste formatting from one chart to another.

When we have multiple charts, ensuring consistent color schemes, fonts etc. is very important. Often we individually format the charts because they have different chart types or source data. But instead, you can just use paste special to copy and paste chart formatting (formatting of labels, grid line settings, axis settings, colors, legends, titles) from one chart to another. See this small tutorial.

Use Paste Special to speed up chart formatting

  • To do this, Select the source chart, press Copy (or CTRL+C), now select the destination chart, go to Paste Special (or press ALT+ES). From the dialog select “Formats”.
发新话题
最新文章


主页【电子禅国际】 论坛【电子禅论坛】 最新【电子禅最新】 赞赏【赞赏】