{"id":12634,"date":"2025-01-15T10:32:23","date_gmt":"2025-01-15T10:32:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cong-cu-flash-fill-trong-excel-thay-the-nhieu-cong-thuc\/"},"modified":"2025-01-15T10:32:23","modified_gmt":"2025-01-15T10:32:23","slug":"cong-cu-flash-fill-trong-excel-thay-the-nhieu-cong-thuc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cong-cu-flash-fill-trong-excel-thay-the-nhieu-cong-thuc\/","title":{"rendered":"C\u00f4ng c\u1ee5 Flash Fill trong Excel thay th\u1ebf nhi\u1ec1u c\u00f4ng th\u1ee9c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<hr>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/fxm5OgjnSsg?wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>C\u00f4ng c\u1ee5 <strong>Flash Fill<\/strong> xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u t\u1eeb phi\u00ean b\u1ea3n Excel 2013 s\u1ebd gi\u00fap c\u00f4ng vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u nh\u01b0 t\u00e1ch h\u1ecd t\u00ean, t\u00e1ch ng\u00e0y th\u00e1ng, th\u1eddi gian, t\u1ed5 ch\u1ee9c l\u1ea1i d\u1eef li\u1ec7u trong Excel tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 nhanh ch\u00f3ng h\u01a1n bao gi\u1edd h\u1ebft, ch\u1ec9 c\u1ea7n nh\u1eadp v\u00e0i d\u00f2ng d\u1eef li\u1ec7u ban \u0111\u1ea7u, Flash Fill s\u1ebd <strong>t\u1ef1 d\u1ef1 \u0111o\u00e1n<\/strong> ch\u00fang ta mu\u1ed1n x\u1eed l\u00fd d\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o v\u00e0 sau \u0111\u00f3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft <strong><code class=\"highlighter-rouge\">CTRL<\/code><\/strong> + <strong><code class=\"highlighter-rouge\">E<\/code><\/strong> v\u00e0 \u0111\u1ec3 <em>*Flash Fill<\/em> x\u1eed l\u00fd n\u1ed1t ph\u1ea7n vi\u1ec7c c\u00f2n l\u1ea1i.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2015\/11\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32292\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%202048%20880'%3E%3C\/svg%3E\" alt=\"S\u1eed d\u1ee5ng Flashfill trong Excel\" width=\"2048\" height=\"880\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1.png 2048w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1-600x258.png 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1-300x129.png 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1-1024x440.png 1024w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1-768x330.png 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2015\/11\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1-1536x660.png 1536w\" data-lazy-sizes=\"(max-width: 2048px) 100vw, 2048px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32292\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2015-11-22-excel-su-dung-flash-fill-trong-excel-1.png\" alt=\"S\u1eed d\u1ee5ng Flashfill trong Excel\" width=\"2048\" height=\"880\" title=\"2015-11-22-excel-su-dung-flash-fill-trong-excel-1\"><\/a><\/p>\n<p>Th\u1eed d\u00f9ng <strong>Flash Fill<\/strong> b\u1eb1ng c\u00e1ch <strong>download file\u00a0k\u00e8m theo<\/strong>\u00a0v\u1ec1, ti\u1ebfn t\u1edbi <strong><code class=\"highlighter-rouge\">Sheet 2<\/code><\/strong> v\u00e0 d\u00f9ng ph\u00edm t\u1eaft <strong><code class=\"highlighter-rouge\">CTRL<\/code><\/strong> + <strong><code class=\"highlighter-rouge\">E<\/code><\/strong> cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u m\u00e0u v\u00e0ng, b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1ee3c s\u1ef1 k\u00ec di\u1ec7u c\u1ee7a <strong>Flash Fill<\/strong>.<\/p>\n<h2 id=\"download-file-excel-km-theo-bi\">Download file excel k\u00e8m theo b\u00e0i<\/h2>\n<p><strong><a href=\"http:\/\/gofile.me\/5yKFU\/3TImJpvnb\" target=\"_blank\" rel=\"noopener noreferrer\">Download \u1edf link n\u00e0y<\/a><\/strong><\/p>\n<p>Excel th\u1eadt nhi\u1ec1u \u1ee9ng d\u1ee5ng b\u1ea5t ng\u1edd ph\u1ea3i kh\u00f4ng? Ch\u01b0a h\u1ebft \u0111\u00e2u, Excel c\u00f2n h\u1ed7 tr\u1ee3 r\u1ea5t nhi\u1ec1u trong vi\u1ec7c x\u1eed l\u00fd nh\u1eefng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p kh\u00e1c. Tuy nhi\u00ean, \u0111\u1ec3 s\u1eed d\u1ee5ng t\u1ed1t Excel th\u00ec kh\u00f4ng ph\u1ea3i ai c\u0169ng c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c. H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u v\u00e0 kh\u00e1m ph\u00e1 Excel nh\u00e9. B\u1ea1n tham kh\u1ea3o\u00a0kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>C\u00f4ng c\u1ee5 Flash Fill xu\u1ea5t hi\u1ec7n l\u1ea7n \u0111\u1ea7u t\u1eeb phi\u00ean b\u1ea3n Excel 2013 s\u1ebd gi\u00fap..<\/p>\n","protected":false},"author":1,"featured_media":12635,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12634","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=12634"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12634\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12635"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}