{"id":1639,"date":"2013-04-19T09:00:59","date_gmt":"2013-04-19T09:00:59","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1639"},"modified":"2023-12-30T23:26:52","modified_gmt":"2023-12-30T23:26:52","slug":"excel-2013-complete-data-entry-quickly-with-flash-fill","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-2013-complete-data-entry-quickly-with-flash-fill\/","title":{"rendered":"Excel 2013: Complete data entry quickly with Flash Fill"},"content":{"rendered":"<p><a href=\"\/b\/new-for-office-2013\/\"><img decoding=\"async\" class=\"alignleft wp-image-1707 size-full\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/new-for-office-2013-e1366281054450.png\" alt=\"new feature for microsoft office 2013\" width=\"125\" height=\"125\" \/><\/a>Save time and effort with Flash Fill for Excel 2013. Just one in a long line of nifty improvements to help you work more efficiently.<\/p>\n<p><span style=\"line-height: 1.714285714; font-size: 1rem;\">Flash Fill for Excel 2013 notices patterns in your data entry and then auto completes the remaining, so there\u2019s no need to use formulas or macros to do this. Data gets filled in automatically. Previously you would have to use variations on LEFT(), RIGHT(), MID() plus a few other supporting functions to do this.<\/span><\/p>\n<p>For example the Flash Fill feature will automatically complete a list of surnames after starting to type the second surname. It recognises patterns and predicts what data to fill in for you. Start typing the initials and Flash Fill fills the list for you.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/FF1.png\"><img decoding=\"async\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/FF1.png\" alt=\"Flash Fill for Excel 2013\" width=\"500\" height=\"158\" \/><\/a><\/p>\n<p><em>Top Tip: Flash Fill also recognises text case. After typing a name in upper case, clicking Flash Fill on the Data Ribbon fills all the rest of the names in upper case.<\/em><\/p>\n<p><a href=\"\/b\/wp-content\/uploads\/2013\/04\/FF2.png\"><img decoding=\"async\" class=\"aligncenter wp-image-1642 size-full\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2013\/04\/FF2.png\" alt=\"Flash Fill for Excel 2013\" width=\"318\" height=\"172\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Whether you&#8217;re splitting out email addresses or stripping out surnames, Flash Fill is a very useful feature.<\/p>\n<p>For more tips and features on Excel 2013 and other versions, browse\u00a0<a title=\"Best STL Excel Training Courses London\" href=\"\/excel-training-london.php\"><strong>One Day Excel courses London<\/strong>\u00a0from STL<\/a>, available UK wide.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Save time and effort with Flash Fill for Excel 2013. Just one in a long line of nifty improvements to help you work more efficiently. Flash Fill for Excel 2013 notices patterns in your data entry and then auto completes the remaining, so there\u2019s no need to use formulas or macros to do this. Data [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[75,94,171,179,255],"class_list":["post-1639","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-bitesize-posts","tag-cheat-sheet","tag-excel","tag-excel-2013","tag-flash-fill"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1639"}],"version-history":[{"count":2,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1639\/revisions"}],"predecessor-version":[{"id":3295,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1639\/revisions\/3295"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}