{"id":360434,"date":"2017-02-01T14:41:34","date_gmt":"2017-02-01T22:41:34","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?post_type=msr-project&p=360434"},"modified":"2017-06-12T09:32:43","modified_gmt":"2017-06-12T16:32:43","slug":"flash-fill-excel-feature-office-2013","status":"publish","type":"msr-project","link":"https:\/\/www.microsoft.com\/en-us\/research\/project\/flash-fill-excel-feature-office-2013\/","title":{"rendered":"Flash Fill (Excel feature in Office 2013)"},"content":{"rendered":"
Our programming by example work (POPL 2011 (opens in new tab)<\/span><\/a>), also recognized as CACM Research Highlights (CACM 2012 (opens in new tab)<\/span><\/a>), ships as part of the Flash Fill feature in Excel in Office 2013. Here’s a small video (opens in new tab)<\/span><\/a> illustrating this feature. Here’s another small video (opens in new tab)<\/span><\/a> illustrating potential extensions.<\/p>\n Here’s the inside story of how it came about: Flash Fill Gives Excel a Smart Charge (opens in new tab)<\/span><\/a><\/p>\n Our programming by example work (POPL 2011), also recognized as CACM Research Highlights (CACM 2012), ships as part of the Flash Fill feature in Excel in Office 2013. Here’s a small video illustrating this feature. Here’s another small video illustrating potential extensions. Here’s the inside story of how it came about: Flash Fill Gives Excel […]<\/p>\n","protected":false},"featured_media":0,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"research-area":[13560],"msr-locale":[268875],"msr-impact-theme":[],"msr-pillar":[],"class_list":["post-360434","msr-project","type-msr-project","status-publish","hentry","msr-research-area-programming-languages-software-engineering","msr-locale-en_us","msr-archive-status-active"],"msr_project_start":"2012-01-01","related-publications":[],"related-downloads":[],"related-videos":[],"related-groups":[],"related-events":[],"related-opportunities":[],"related-posts":[620838],"related-articles":[],"tab-content":[],"slides":[],"related-researchers":[{"type":"user_nicename","value":"sumitg","display_name":"Sumit Gulwani","author_link":"Sumit Gulwani<\/a>","is_active":false,"user_id":33755,"last_first":"Gulwani, Sumit","people_section":0,"alias":"sumitg"}],"msr_research_lab":[],"msr_impact_theme":[],"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/360434"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-project"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/360434\/revisions"}],"predecessor-version":[{"id":360443,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-project\/360434\/revisions\/360443"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=360434"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=360434"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=360434"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=360434"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=360434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Here are some other videos on FlashFill<\/h2>\n
\n
Here is what popular media says about this feature<\/h2>\n
\n
\nThis feature is on every tech journalist\u2019s favorite Excel 2013 features list, and it\u2019s no wonder.<\/li>\n
\nExcel\u2019s new Flash Fill feature is getting ample buzz. No wonder: It automates processes such as splitting first and last name that used to require multiple steps using Text to Columns and\/or lengthy nested formulas.<\/li>\n
\nIntroducing… Excel Flash Fill
\nWhen downloading data to a spreadsheet, often it arrives with multiple pieces of information per cell that needs to be sorted out. With a new feature called Flash Fill, Excel figures out what information users are trying to pull into a separate column and automatically fills up a new column with that data. So if the task is to create a column of first names from a column of email addresses with the format firstname.lastname@business.com, users would type in the first name of the top address in a new column, then the second name and then Excel would fill out the rest of the new column with the rest of the first names, saving the bulk of the manual transcription.<\/li>\n
\nDress up your Excel data: New Flash Fill reformatting in Excel makes rearranging data much easier<\/li>\nHere is what some blogs says about this feature<\/h2>\n
\n