{"id":2583,"date":"2019-08-23T15:37:47","date_gmt":"2019-08-23T07:37:47","guid":{"rendered":"https:\/\/owa.sodexo-cn.com\/blog\/?p=2583"},"modified":"2019-08-23T15:37:47","modified_gmt":"2019-08-23T07:37:47","slug":"%e3%80%90excel%e3%80%91niche-skills-trouble-savers","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=2583","title":{"rendered":"\u3010Excel\u3011Niche skills, trouble savers"},"content":{"rendered":"\n

As a newcomer to Excel, I may not be as good as everyone, but I have been learning. I have accumulated experience and hope to help you solve practical problems in your work.<\/p>\n\n\n\n

1. Data change amount without reason<\/h4>\n\n\n\n

This problem has been encountered by many colleagues. After the excellent Excel document is opened, the numbers in it become the accounting amount or the euro format. In fact, this is a sequel to using a custom format in the worksheet.<\/p>\n\n\n\n

Solution\uff1a\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Press to open \u3010Set Cell Format\u3011–\u3010Digital\u3011–\u3010Custom\u3011– Delete all the format codes that can be deleted on the right side, save the file and open it again, there is no problem. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

2. Quickly copy the format to other charts<\/h4>\n\n\n\n

How to quickly apply a chart effect to another chart?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Click on the selected chart – copy – click on the chart to apply the style – paste-and-format \u2013 confirm <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"

<\/figcaption><\/figure>\n\n\n\n

3. Annotation quick reset<\/h4>\n\n\n\n

Many colleagues are used to inserting annotations into cells to mark and describe the data. But sometimes the position of the annotation will be confused, and some even go out of sight.<\/p>\n\n\n\n

How do I get the wrong annotations back to the default location?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Select all the worksheet \u2013 copy in new worksheet — paste in the new worksheet, then, there is no more.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uf04a <\/p>\n","protected":false},"excerpt":{"rendered":"

As a newcomer to Excel, I may not be as good as everyon … \u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2583","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"views":1855,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2583"}],"version-history":[{"count":1,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2583\/revisions"}],"predecessor-version":[{"id":2588,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2583\/revisions\/2588"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}