{"id":1037,"date":"2017-06-29T22:20:37","date_gmt":"2017-06-29T22:20:37","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/wm-compapp\/?post_type=chapter&#038;p=1037"},"modified":"2017-08-04T20:51:39","modified_gmt":"2017-08-04T20:51:39","slug":"flash-fill","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/chapter\/flash-fill\/","title":{"raw":"Flash Fill","rendered":"Flash Fill"},"content":{"raw":"<div class=\"textbox learning-objectives\">\r\n<h3>Learning Objectives<\/h3>\r\n<ul>\r\n \t<li>Use Flash Fill.<\/li>\r\n<\/ul>\r\n<\/div>\r\nLike many modern software programs, Excel is designed to recognize certain patterns. For example, perhaps you are creating a table that lists the last and first names of attendees at a company training session. After all the names have been entered into two separate columns, you realize you would like a single column to correctly display the full name. An easy way to achieve this without having to manually retype the entire list is to use Flash Fill.\r\n<ol>\r\n \t<li>Create a new column for the combined information you wish to display.<\/li>\r\n \t<li>In the first cell, type the name as you wish it to display. In our screenshots, this would be \u201cJohn Smith.\u201d<\/li>\r\n \t<li>Begin typing the next piece of data in the next cell. Excel should automatically suggest a Flash Fill option.<\/li>\r\n \t<li>If the Flash Fill suggestion matches how you would like the information displayed, simply hit the Enter key and the rest of your column should fill in automatically.<\/li>\r\n<\/ol>\r\n<a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29221819\/flashfill1.png\"><img class=\"aligncenter wp-image-1038\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29221819\/flashfill1.png\" alt=\"An excel sheet is open with names in cells A1 through C8, only excluding C5.\" width=\"800\" height=\"596\" \/><\/a>\r\n\r\nFlash Fill is especially helpful if your data is initially in different forms but you want the final information to display in the same fashion. For example, in our attendee list, some of the names were capitalized, in all caps, or had no capitalization. Sometimes you may need to manually update more than one option but Excel will detect your pattern.\r\n<div class=\"textbox key-takeaways\">\r\n<h3>Practice Question<\/h3>\r\nhttps:\/\/assessments.lumenlearning.com\/assessments\/5368\r\n\r\n<\/div>\r\nFlash Fill should automatically be turned on in Excel but if it is not, you can turn it on using the File&gt;Options&gt;Advanced menus. You can also turn Flash Fill on or off using the shortcut Ctrl+E. Be aware that the Mac version of Excel does not have Flash Fill.\r\n<div class=\"textbox key-takeaways\">\r\n<h3>Practice Questions<\/h3>\r\nhttps:\/\/assessments.lumenlearning.com\/assessments\/5369\r\n\r\n<\/div>\r\n&nbsp;","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Objectives<\/h3>\n<ul>\n<li>Use Flash Fill.<\/li>\n<\/ul>\n<\/div>\n<p>Like many modern software programs, Excel is designed to recognize certain patterns. For example, perhaps you are creating a table that lists the last and first names of attendees at a company training session. After all the names have been entered into two separate columns, you realize you would like a single column to correctly display the full name. An easy way to achieve this without having to manually retype the entire list is to use Flash Fill.<\/p>\n<ol>\n<li>Create a new column for the combined information you wish to display.<\/li>\n<li>In the first cell, type the name as you wish it to display. In our screenshots, this would be \u201cJohn Smith.\u201d<\/li>\n<li>Begin typing the next piece of data in the next cell. Excel should automatically suggest a Flash Fill option.<\/li>\n<li>If the Flash Fill suggestion matches how you would like the information displayed, simply hit the Enter key and the rest of your column should fill in automatically.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29221819\/flashfill1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1038\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/1844\/2017\/06\/29221819\/flashfill1.png\" alt=\"An excel sheet is open with names in cells A1 through C8, only excluding C5.\" width=\"800\" height=\"596\" \/><\/a><\/p>\n<p>Flash Fill is especially helpful if your data is initially in different forms but you want the final information to display in the same fashion. For example, in our attendee list, some of the names were capitalized, in all caps, or had no capitalization. Sometimes you may need to manually update more than one option but Excel will detect your pattern.<\/p>\n<div class=\"textbox key-takeaways\">\n<h3>Practice Question<\/h3>\n<p>\t<iframe id=\"lumen_assessment_5368\" class=\"resizable\" src=\"https:\/\/assessments.lumenlearning.com\/assessments\/load?assessment_id=5368&#38;embed=1&#38;external_user_id=&#38;external_context_id=&#38;iframe_resize_id=lumen_assessment_5368\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:400px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>Flash Fill should automatically be turned on in Excel but if it is not, you can turn it on using the File&gt;Options&gt;Advanced menus. You can also turn Flash Fill on or off using the shortcut Ctrl+E. Be aware that the Mac version of Excel does not have Flash Fill.<\/p>\n<div class=\"textbox key-takeaways\">\n<h3>Practice Questions<\/h3>\n<p>\t<iframe id=\"lumen_assessment_5369\" class=\"resizable\" src=\"https:\/\/assessments.lumenlearning.com\/assessments\/load?assessment_id=5369&#38;embed=1&#38;external_user_id=&#38;external_context_id=&#38;iframe_resize_id=lumen_assessment_5369\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:400px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-1037\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Flash Fill. <strong>Authored by<\/strong>: Shelli Carter. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":20,"menu_order":13,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Flash Fill\",\"author\":\"Shelli Carter\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"}]","CANDELA_OUTCOMES_GUID":"077a2b4b-eaae-49b4-b037-3cd8024b0678","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-1037","chapter","type-chapter","status-publish","hentry"],"part":975,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/wp\/v2\/users\/20"}],"version-history":[{"count":10,"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1037\/revisions"}],"predecessor-version":[{"id":2586,"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1037\/revisions\/2586"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/pressbooks\/v2\/parts\/975"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/pressbooks\/v2\/chapters\/1037\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/wp\/v2\/media?parent=1037"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/pressbooks\/v2\/chapter-type?post=1037"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/wp\/v2\/contributor?post=1037"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-wm-compapp\/wp-json\/wp\/v2\/license?post=1037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}