{"id":4034,"date":"2016-08-11T01:00:22","date_gmt":"2016-08-10T23:00:22","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=4034"},"modified":"2024-02-06T16:03:11","modified_gmt":"2024-02-06T15:03:11","slug":"use-flash-fill-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-flash-fill-excel\/","title":{"rendered":"How to Use Flash Fill In Excel"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><strong>Flash Fill<\/strong>\u00a0in Excel is a new feature that was introduced in Excel 2013.<\/p>\n<p>It is very handy as Excel predicts the rest of your inputs based on the first entry that you have placed. Once its prediction is correct and you confirm it, it will fill the rest of the rows literally\u00a0<strong>in a flash!<\/strong><\/p>\n<p>The cool thing with Excel&#8217;s\u00a0<strong>Flash Fill<\/strong> is there is no need to use\u00a0<a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a> and removes manual repetitiveness, saving you heaps of time in the process!<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/eBxXm_1gxg8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Flash-Fill.xlsx<\/span><\/a><\/p>\n<\/div>\n<hr \/>\n<p><span style=\"color: #ff0000;\"><strong>ACTIVATE FLASH FILL:\u00a0<\/strong><\/span><\/p>\n<p>If the Flash Fill does not work automatically, you need to activate in from Excel&#8217;s back end by going to:<\/p>\n<p>File &gt; Options &gt; Advanced &gt; Automatically Flash Fill<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/flash-fill.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-5680\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/flash-fill.png\" alt=\"How to Use Flash Fill In Excel\" width=\"826\" height=\"678\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/flash-fill.png 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/flash-fill-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/flash-fill-768x630.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<p>To demonstrate the power of Excel&#8217;s Flash Fill, we will start off with this table of data we need to populate:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4039\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-01.png\" alt=\"How to Use Flash Fill In Excel\" width=\"358\" height=\"136\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-01.png 358w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-01-300x114.png 300w\" sizes=\"(max-width: 358px) 100vw, 358px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1<\/strong>:<\/span> Type <em><strong>Homer<\/strong>\u00a0<\/em>as the first entry in the\u00a0<strong>First Name<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4040\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-02.png\" alt=\"How to Use Flash Fill In Excel\" width=\"360\" height=\"136\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-02.png 360w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-02-300x113.png 300w\" sizes=\"(max-width: 360px) 100vw, 360px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2<\/strong>:<\/span>\u00a0In the second entry, once you type the first letter\u00a0<strong>I<\/strong> for\u00a0<em><strong>Ian<\/strong>,\u00a0<\/em>Excel will auto-suggest to <strong>Flash Fill<\/strong> the rest of the First Names.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4041\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-03.png\" alt=\"How to Use Flash Fill In Excel\" width=\"356\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-03.png 356w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-03-300x113.png 300w\" sizes=\"(max-width: 356px) 100vw, 356px\" \/><\/a><\/p>\n<p>Just in case Flash Fill does not start automatically when you are expecting for it to match your pattern, you can start it manually by clicking <strong>Data &gt; Flash Fill<\/strong>. Another alternative is to press <strong>Ctrl+E<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Flash-Fill-troubleshoot.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4219\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Flash-Fill-troubleshoot.png\" alt=\"How to Use Flash Fill In Excel\" width=\"659\" height=\"157\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Flash-Fill-troubleshoot.png 659w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/08\/Flash-Fill-troubleshoot-300x71.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>If the flash fill looks good, press\u00a0<strong>Enter.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4042\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-04.png\" alt=\"How to Use Flash Fill In Excel\" width=\"362\" height=\"139\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-04.png 362w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-04-300x115.png 300w\" sizes=\"(max-width: 362px) 100vw, 362px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Type <em><strong>Simpson<\/strong>\u00a0<\/em>as the first entry in the\u00a0<strong>Last\u00a0Name<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4043\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-05.png\" alt=\"How to Use Flash Fill In Excel\" width=\"363\" height=\"136\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-05.png 363w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-05-300x112.png 300w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5: <\/strong><\/span>In the second entry, once you type the first letter <strong>W<\/strong> of\u00a0<em><strong>Wright<\/strong>,\u00a0<\/em>Excel will auto-suggest to F<strong>lash Fill<\/strong> the rest of the Last\u00a0Names.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4044\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-06.png\" alt=\"How to Use Flash Fill In Excel\" width=\"357\" height=\"131\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-06.png 357w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-06-300x110.png 300w\" sizes=\"(max-width: 357px) 100vw, 357px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6: <\/strong><\/span>If the flash fill looks good, press\u00a0<strong>Enter.\u00a0<\/strong>Your data is now complete without the use of a single formula!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Flash Fill In Excel\"  class=\"alignnone size-full wp-image-4045\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-07.png\" alt=\"How to Use Flash Fill In Excel\" width=\"382\" height=\"138\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-07.png 382w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Flash-Fill-07-300x108.png 300w\" sizes=\"(max-width: 382px) 100vw, 382px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"3 Quick Ways on How To Create A List In Excel\"  class=\"alignnone wp-image-3233 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Oz_Podcast_Banner.jpg\" alt=\"3 Quick Ways on How To Create A List In Excel\" width=\"728\" height=\"90\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Oz_Podcast_Banner.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Oz_Podcast_Banner-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Flash Fill\u00a0in Excel is a new feature that was introduced in Excel 2013. It is very handy as Excel predicts the rest of your inputs based on the first entry that you have placed. Once its prediction is correct and you confirm it, it will fill the rest of the rows literally\u00a0in a flash! [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,41],"tags":[88,162],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4034"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=4034"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4034\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17406"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=4034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=4034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=4034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}