{"id":5697,"date":"2023-08-08T13:27:50","date_gmt":"2023-08-08T05:27:50","guid":{"rendered":"https:\/\/owa.sodexo-cn.com\/blog\/?p=5697"},"modified":"2023-08-18T17:03:16","modified_gmt":"2023-08-18T09:03:16","slug":"use-flash-fill-in-excel","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=5697","title":{"rendered":"Use Excel&#8217;s &#8220;Auto Fill&#8221; to generate new data columns"},"content":{"rendered":"\n<p class=\"has-medium-font-size\"><strong>Excel Tip: The shortcut \u3010Ctrl+E\u3011 is useful<\/strong><\/p>\n\n\n\n<p>According to the existing data column information, to generate a new column of data, we will generally use the formula to achieve, in fact, with EXCEL&#8217;s auto fill function (Ctrl + E)  can replace most of the complex formula to achieve!<\/p>\n\n\n\n<p>Just <strong>create a new column, and then manually create a target result , then select it, press Ctrl + E<\/strong>, the software will automatically analyze\/imitate and generate the remaining data, the specific results can refer to the following examples<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"265\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2023\/08\/autofill-1.gif\" alt=\"\" class=\"wp-image-5720\"\/><figcaption class=\"wp-element-caption\">Merge<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"479\" height=\"255\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2023\/08\/autofill-2.gif\" alt=\"\" class=\"wp-image-5721\"\/><figcaption class=\"wp-element-caption\">Replace info<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"255\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2023\/08\/autofill-3.gif\" alt=\"\" class=\"wp-image-5722\"\/><figcaption class=\"wp-element-caption\">Extract<\/figcaption><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"421\" height=\"255\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2023\/08\/autofill-4.gif\" alt=\"\" class=\"wp-image-5723\"\/><figcaption class=\"wp-element-caption\">Reorganization<\/figcaption><\/figure>\n<\/div>\n\n\n<p>There are more tips for you to discover, enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Tip: The shortcut \u3010Ctrl+E\u3011 is useful According to &#8230; <a title=\"Use Excel&#8217;s &#8220;Auto Fill&#8221; to generate new data columns\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=5697\" aria-label=\"\u9605\u8bfb Use Excel&#8217;s &#8220;Auto Fill&#8221; to generate new data columns\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":14,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5697","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"views":1098,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5697","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5697"}],"version-history":[{"count":8,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5697\/revisions"}],"predecessor-version":[{"id":5724,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5697\/revisions\/5724"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}