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

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”.
发新话题
最新文章


主页【电子禅国际】 论坛【电子禅论坛】 最新【电子禅最新】 打赏【打赏】
Copyright © 2001~2017 法律顾问:陕西普和律师事务所 薛永谦律师
中华人文学会有限公司【电子禅工作室】地址:华藏世界海-娑婆世界-中国香港
关于我们 | 本站地图 | 免责条款 | 联系我们
电子禅国际 DIANZICHAN.COM