{"id":7637,"date":"2024-12-21T18:10:34","date_gmt":"2024-12-21T18:10:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016\/"},"modified":"2024-12-21T18:10:34","modified_gmt":"2024-12-21T18:10:34","slug":"huong-dan-su-dung-autofill-trong-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Autofill trong Excel 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng t\u00ednh n\u0103ng <strong>Autofill <\/strong>trong Excel. B\u1ea1n s\u1ebd bi\u1ebft c\u00e1ch t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n chu\u1ed7i s\u1ed1, ng\u00e0y th\u00e1ng ho\u1eb7c c\u00e1c d\u1eef li\u1ec7u kh\u00e1c, t\u1ea1o v\u00e0 s\u1eed d\u1ee5ng danh s\u00e1ch t\u00f9y ch\u1ecdn trong Excel 2010, 2013, 2016.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-67670499ac4db\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Su_dung_tuy_chon_Autofill_de_dien_vao_mot_day_trong_Excel_2010-2016\" title=\"S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Autofill \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o m\u1ed9t d\u00e3y trong Excel 2010-2016:\">S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Autofill \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o m\u1ed9t d\u00e3y trong Excel 2010-2016:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Tat_ca_tuy_chon_Autofill_%E2%80%93_cach_toi_uu_hoa_fill_handle\" title=\"T\u1ea5t c\u1ea3 tu\u1ef3 ch\u1ecdn Autofill \u2013 c\u00e1ch t\u1ed1i \u01b0u h\u00f3a fill handle:\">T\u1ea5t c\u1ea3 tu\u1ef3 ch\u1ecdn Autofill \u2013 c\u00e1ch t\u1ed1i \u01b0u h\u00f3a fill handle:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Nhan_dup_chuot_de_tu_dong_dien_vung_du_lieu_lon\" title=\"Nh\u1ea5n \u0111\u00fap chu\u1ed9t \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00f9ng d\u1eef li\u1ec7u l\u1edbn\">Nh\u1ea5n \u0111\u00fap chu\u1ed9t \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00f9ng d\u1eef li\u1ec7u l\u1edbn<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Excel_%E2%80%93_Dien_vao_mot_chuoi_gia_tri_dang_text\" title=\"Excel \u2013 \u0110i\u1ec1n v\u00e0o m\u1ed9t chu\u1ed7i gi\u00e1 tr\u1ecb d\u1ea1ng text:\">Excel \u2013 \u0110i\u1ec1n v\u00e0o m\u1ed9t chu\u1ed7i gi\u00e1 tr\u1ecb d\u1ea1ng text:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Tao_danh_sach_tuy_chon_bang_Autofill\" title=\"T\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn b\u1eb1ng Autofill:\">T\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn b\u1eb1ng Autofill:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Su_dung_Autofill_de_lap_lai_chuoi\" title=\"S\u1eed d\u1ee5ng Autofill \u0111\u1ec3 l\u1eb7p l\u1ea1i chu\u1ed7i:\">S\u1eed d\u1ee5ng Autofill \u0111\u1ec3 l\u1eb7p l\u1ea1i chu\u1ed7i:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Autofill_theo_chieu_doc_va_theo_chieu_ngang\" title=\"Autofill theo chi\u1ec1u d\u1ecdc v\u00e0 theo chi\u1ec1u ngang \">Autofill theo chi\u1ec1u d\u1ecdc v\u00e0 theo chi\u1ec1u ngang <\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Autofill_nhieu_hang_va_cot\" title=\"Autofill nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t\">Autofill nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Chen_o_trong_khi_dien_chuoi\" title=\"Ch\u00e8n \u00f4 tr\u1ed1ng khi \u0111i\u1ec1n chu\u1ed7i:\">Ch\u00e8n \u00f4 tr\u1ed1ng khi \u0111i\u1ec1n chu\u1ed7i:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Su_dung_danh_sach_Autofill_Options_de_dong_bo_du_lieu_duoc_nhap_vao\" title=\"S\u1eed d\u1ee5ng danh s\u00e1ch Autofill Options \u0111\u1ec3 \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o\">S\u1eed d\u1ee5ng danh s\u00e1ch Autofill Options \u0111\u1ec3 \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-su-dung-autofill-trong-excel-2010-2013-2016.html#Excel_%E2%80%93_Autofill_cong_thuc\" title=\"Excel \u2013 Autofill c\u00f4ng th\u1ee9c:\">Excel \u2013 Autofill c\u00f4ng th\u1ee9c:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_tuy_chon_Autofill_de_dien_vao_mot_day_trong_Excel_2010-2016\"><\/span><strong>S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Autofill \u0111\u1ec3 \u0111i\u1ec1n v\u00e0o m\u1ed9t d\u00e3y trong Excel 2010-2016:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ch\u1ee9c n\u0103ng t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n trong Excel s\u1ebd gi\u00fap b\u1ea1n sao ch\u00e9p c\u00f9ng m\u1ed9t gi\u00e1 tr\u1ecb xu\u1ed1ng ho\u1eb7c \u0111i\u1ec1n m\u1ed9t chu\u1ed7i s\u1ed1 ho\u1eb7c gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. \u0110\u00e2y l\u00e0 m\u1ed9t ph\u1ea7n kh\u00f4ng th\u1ec3 thay th\u1ebf c\u1ee7a tu\u1ef3 ch\u1ecdn <strong><em>Autofill<\/em><\/strong>. Ch\u1ee9c n\u0103ng n\u00e0y hi\u1ec3n th\u1ecb l\u00e0 m\u1ed9t h\u00ecnh vu\u00f4ng nh\u1ecf n\u1eb1m g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn <strong>(<em>fill handle<\/em>)<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-fill-handle.png\" alt=\"See the fill handle in the bottom-right corner of your selection\" title=\"excel-fill-handle\"><\/strong><\/p>\n<p style=\"text-align: justify\">Thao t\u00e1c r\u1ea5t \u0111\u01a1n gi\u1ea3n. B\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n c\u1ea7n \u0111i\u1ec1n chu\u1ed7i gi\u00e1 tr\u1ecb v\u00e0o c\u00e1c \u00f4 li\u1ec1n k\u1ec1, b\u1ea5m v\u00e0o h\u00ecnh vu\u00f4ng n\u00f3i tr\u00ean v\u00e0 con tr\u1ecf chu\u1ed9t s\u1ebd hi\u1ec3n th\u1ecb th\u00e0nh d\u1ea5u th\u1eadp m\u00e0u \u0111en (+), k\u00e9o chu\u1ed9t theo chi\u1ec1u d\u1ecdc ho\u1eb7c chi\u1ec1u ngang. Khi b\u1ea1n th\u1ea3 chu\u1ed9t, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn \u0111\u01b0\u1ee3c \u0111i\u1ec1n gi\u00e1 tr\u1ecb d\u1ef1a tr\u00ean m\u1eabu b\u1ea1n ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-autofill-range-results.png\" alt=\"See your range being autofilled\" title=\"excel-autofill-range-results\"><\/p>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p l\u00e0: L\u00e0m th\u1ebf n\u00e0o t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n s\u1ed1 trong Excel? S\u1ed1 c\u00f3 th\u1ec3 l\u00e0 ng\u00e0y th\u00e1ng, th\u1eddi gian, th\u1ee9, th\u00e1ng, n\u0103m\u2026<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, b\u1ea1n c\u1ea7n ti\u1ebfp t\u1ee5c m\u1ed9t d\u00e3y s\u1ed1, h\u00e3y nh\u1eadp hai gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean v\u00e0o \u00f4 b\u1eaft \u0111\u1ea7u v\u00e0 k\u00e9o <strong><em>fill handle <\/em><\/strong>\u0111\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u sang v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-309.gif\" title=\"vba101_92019-nho-309\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-685.gif\" title=\"ex101_92019-nho-685\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-autofill-series-numbers.png\" alt=\"Use Excel AutoFill to continue a number sequence\" title=\"excel-autofill-series-numbers\"><\/p>\n<p style=\"text-align: justify\">T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00f2n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho b\u1ea5t k\u1ef3 d\u00e3y s\u1ed1 s\u1ed1 h\u1ecdc n\u00e0o m\u00e0 c\u00e1c s\u1ed1 trong d\u00e3y c\u00e1ch nhau c\u00f9ng l\u01b0\u1ee3ng \u0111\u01a1n v\u1ecb. V\u00ed d\u1ee5 3, 9, 15\u2026 (c\u00e1ch nhau 6 \u0111\u01a1n v\u1ecb)<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-autofill-numbers-progression.png\" alt=\"Use Excel AutoFill to get any arithmetic progression sequence\" title=\"excel-autofill-numbers-progression\"><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, n\u00f3 c\u00f2n \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho c\u00e1c \u00f4 t\u00ednh kh\u00f4ng li\u00ean quan v\u1edbi nhau v\u1ec1 m\u1eb7t s\u1ed1 h\u1ecdc, nh\u01b0 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-autofill-alternate-sequences.png\" alt=\"Get a series of values not numerically related\" title=\"excel-autofill-alternate-sequences\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tat_ca_tuy_chon_Autofill_%E2%80%93_cach_toi_uu_hoa_fill_handle\"><\/span><strong>T\u1ea5t c\u1ea3 tu\u1ef3 ch\u1ecdn Autofill \u2013 <\/strong><strong>c\u00e1ch t\u1ed1i \u01b0u h\u00f3a fill handle:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nhan_dup_chuot_de_tu_dong_dien_vung_du_lieu_lon\"><\/span><strong>Nh\u1ea5n \u0111\u00fap chu\u1ed9t \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00f9ng d\u1eef li\u1ec7u l\u1edbn<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3, c\u1ee5 th\u1ec3 l\u00e0 m\u1ed9t danh s\u00e1ch h\u1ecd v\u00e0 t\u00ean, b\u1ea1n c\u1ea7n ch\u1ec9 \u0111\u1ecbnh m\u1ed9t con s\u1ed1 cho m\u1ed7i t\u00ean. B\u1ea1n c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh thao t\u00e1c trong nh\u00e1y m\u1eaft b\u1eb1ng c\u00e1ch nh\u1eadp v\u00e0o hai s\u1ed1 \u0111\u1ea7u ti\u00ean v\u00e0 nh\u1ea5n \u0111\u00fap chu\u1ed9t v\u00e0o <strong><em>fill handle.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5601 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-9.png\" width=\"600\" height=\"449\" title=\"excel-dialog-box-launcher-1-9\"><\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> C\u00e1ch n\u00e0y ch\u1ec9 c\u00f3 hi\u1ec7u qu\u1ea3 trong tr\u01b0\u1eddng h\u1ee3p sau. N\u1ebfu v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n n\u1eb1m k\u1ebf c\u00e1c c\u1ed9t c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u, Excel s\u1ebd xem x\u00e9t c\u1ed9t li\u1ec1n k\u1ec1 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u00f4 cu\u1ed1i c\u00f9ng trong v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c \u0111i\u1ec1n. L\u01b0u \u00fd r\u1eb1ng n\u00f3 s\u1ebd \u0111i\u1ec1n d\u1ef1a tr\u00ean c\u1ed9t d\u00e0i nh\u1ea5t trong tr\u01b0\u1eddng h\u1ee3p c\u1ed9t b\u00ean c\u1ea1nh v\u00f9ng d\u1eef li\u1ec7u tr\u1ed1ng c\u1ea7n \u0111i\u1ec1n c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">Xem th\u00eam:\u00a0H\u1ecdc excel n\u00e2ng cao \u1edf \u0111\u00e2u?<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Excel_%E2%80%93_Dien_vao_mot_chuoi_gia_tri_dang_text\"><\/span><strong>Excel \u2013 \u0110i\u1ec1n v\u00e0o m\u1ed9t chu\u1ed7i gi\u00e1 tr\u1ecb d\u1ea1ng text:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><strong><em>Autofill <\/em><\/strong>c\u00f3 th\u1ec3 sao ch\u00e9p d\u1eef li\u1ec7u mang gi\u00e1 tr\u1ecb <strong>number <\/strong>ho\u1eb7c <strong>text. <\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_danh_sach_tuy_chon_bang_Autofill\"><\/span><strong>T\u1ea1o danh s\u00e1ch t\u00f9y ch\u1ecdn b\u1eb1ng Autofill:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu n\u1ed9i dung \u0111i\u1ec1n v\u00e0o c\u00e1c \u00f4 t\u00ednh t\u01b0\u01a1ng t\u1ef1 nhau, b\u1ea1n c\u00f3 th\u1ec3 l\u01b0u n\u00f3 th\u00e0nh danh s\u00e1ch t\u00f9y ch\u1ecdn v\u00e0 \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c gi\u00e1 tr\u1ecb trong danh s\u00e1ch n\u00e0y v\u00e0o c\u00e1c \u00f4 t\u00ednh.<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1eadp ti\u00eau \u0111\u1ec1 v\u00e0 ho\u00e0n thanh danh s\u00e1ch.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-custom-list-values.png\" alt=\"Enter the values for your custom list in excel together with the header\" title=\"excel-custom-list-values\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>. M\u1ed9t danh s\u00e1ch t\u00f9y ch\u1ecdn c\u00f3 th\u1ec3 ch\u1ee9a gi\u00e1 tr\u1ecb <strong>text <\/strong>ho\u1eb7c gi\u00e1 tr\u1ecb <strong>text c\u00f9ng v\u1edbi gi\u00e1 tr\u1ecb s\u1ed1<\/strong>. N\u1ebfu b\u1ea1n c\u1ea7n danh s\u00e1ch ch\u1ec9 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1, h\u00e3y t\u1ea1o danh s\u00e1ch s\u1ed1 nh\u01b0ng \u0111\u1ecbnh d\u1ea1ng ki\u1ec3u <strong>text<\/strong>.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a danh s\u00e1ch v\u1eeba t\u1ea1o.<\/li>\n<li>Trong Excel 2003, \u0111i \u0111\u1ebfn <strong><em>Tools &gt; Options &gt; Custom lists<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong Excel 2007, nh\u1ea5n ch\u1ecdn n\u00fat <strong><em>Office &gt; Excel options &gt; Advanced &gt; <\/em><\/strong>l\u0103n con tr\u1ecf chu\u1ed9t xu\u1ed1ng \u0111\u1ebfn khi b\u1ea1n th\u1ea5y <strong><em>Edit Custom Lists\u2026 <\/em><\/strong>trong ph\u1ea7n <strong><em>General<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Trong Excel 2010-2013, nh\u1ea5n ch\u1ecdn <strong><em>File &gt; Options &gt; Advanced &gt;<\/em><\/strong> l\u0103n con tr\u1ecf chu\u1ed9t xu\u1ed1ng ph\u1ea7n <strong><em>General<\/em><\/strong> \u0111\u1ec3 t\u00ecm n\u00fat <strong><em>Edit Custom Lists\u2026<\/em><\/strong><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/edit-custom-lists-button.png\" alt=\"Click on this button to import your custom list\" title=\"edit-custom-lists-button\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Khi b\u1ea1n \u0111\u00e3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u ch\u1ee9a danh s\u00e1ch v\u1eeba t\u1ea1o, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y \u0111\u1ecba ch\u1ec9 c\u1ee7a n\u00f3 trong ph\u1ea7n <strong><em>Import list from cells\u2026<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/import-custom-list-field.png\" alt=\"See your range address in the Import list from cells field\" title=\"import-custom-list-field\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Nh\u1ea5n n\u00fat <strong><em>Import <\/em><\/strong>\u0111\u1ec3 th\u1ea5y n\u1ed9i dung danh s\u00e1ch t\u00f9y ch\u1ecdn c\u1ee7a b\u1ea1n trong c\u1eeda s\u1ed5 <strong><em>Custom lists<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/import-button-excel.png\" alt=\"Press the Import button to see your series in the Custom Lists window\" title=\"import-button-excel\"><\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li>Cu\u1ed1i c\u00f9ng, nh\u1ea5n <strong><em>OK &gt; OK <\/em><\/strong>\u0111\u1ec3 l\u01b0u danh s\u00e1ch.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Khi b\u1ea1n c\u1ea7n t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n danh s\u00e1ch n\u00e0y, g\u00f5 ti\u00eau \u0111\u1ec1 c\u1ee7a danh s\u00e1ch v\u00e0o \u00f4 c\u1ea7n \u0111i\u1ec1n, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb danh s\u00e1ch khi b\u1ea1n <strong><em>fill handle <\/em><\/strong>v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-custom-list.png\" alt=\"Populate cells with custom list values\" title=\"insert-custom-list\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">N\u00ean xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n Online<\/a> 1 th\u00e2\u0300y 1 tro\u0300<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_Autofill_de_lap_lai_chuoi\"><\/span><strong>S\u1eed d\u1ee5ng Autofill \u0111\u1ec3 l\u1eb7p l\u1ea1i chu\u1ed7i:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong><em>fill handle <\/em><\/strong>\u0111\u1ec3 nh\u1eadp l\u1ea1i chu\u1ed7i gi\u00e1 tr\u1ecb, V\u00ed d\u1ee5, b\u1ea1n c\u1ea7n l\u1eb7p l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb YES, NO, TRUE, FALSE. \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n g\u00f5 th\u1ee7 c\u00f4ng t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb n\u00e0y \u0111\u1ec3 \u0111\u01b0a m\u1eabu cho Excel. Sau \u0111\u00f3 <strong><em>fill handle <\/em><\/strong>sang c\u00e1c \u00f4 c\u1ea7n thi\u1ebft.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-reapeat-series.png\" alt=\"Get a series of recurring values\" title=\"autofill-reapeat-series\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Autofill_theo_chieu_doc_va_theo_chieu_ngang\"><\/span><strong>Autofill theo chi\u1ec1u d\u1ecdc v\u00e0 theo chi\u1ec1u ngang <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>Autofill <\/strong>th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t. Tuy nhi\u00ean, t\u00ednh n\u0103ng n\u00e0y c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho vi\u1ec7c \u0111i\u1ec1n c\u00e1c \u00f4 theo chi\u1ec1u ngang, qua tr\u00e1i ho\u1eb7c l\u00ean tr\u00ean. B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn \u00f4 t\u00ednh ch\u1ee9a gi\u00e1 tr\u1ecb v\u00e0 <strong><em>fill handle <\/em><\/strong>n\u00f3 theo h\u01b0\u1edbng mong mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-horizontally-vertically.png\" alt=\"Fill cells horizontally, leftward or upward\" title=\"autofill-horizontally-vertically\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Autofill_nhieu_hang_va_cot\"><\/span><strong>Autofill nhi\u1ec1u h\u00e0ng v\u00e0 c\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\"><strong>Autofill <\/strong>c\u00f3 th\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o nhi\u1ec1u c\u1ed9t v\u00e0 h\u00e0ng. N\u1ebfu b\u1ea1n ch\u1ecdn hai, ba \u00f4 t\u00ednh ho\u1eb7c nhi\u1ec1u h\u01a1n, <strong><em>fill handle <\/em><\/strong>s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n t\u1ea5t c\u1ea3 ch\u00fang.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-several-rows.png\" alt=\"Autofill more than one row\" title=\"autofill-several-rows\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_o_trong_khi_dien_chuoi\"><\/span><strong>Ch\u00e8n \u00f4 tr\u1ed1ng khi \u0111i\u1ec1n chu\u1ed7i:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o chu\u1ed7i gi\u00e1 tr\u1ecb c\u00f3 ch\u1ee9a \u00f4 tr\u1ed1ng nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-insert-empty-cells.png\" alt=\"Create a series with empty cells\" title=\"autofill-insert-empty-cells\"><\/p>\n<blockquote>\n<p style=\"text-align: justify\">T\u00e0i li\u1ec7u\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel 2010<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_danh_sach_Autofill_Options_de_dong_bo_du_lieu_duoc_nhap_vao\"><\/span><strong>S\u1eed d\u1ee5ng danh s\u00e1ch Autofill Options \u0111\u1ec3 \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp c\u00e0i \u0111\u1eb7t v\u1edbi danh s\u00e1ch <strong><em>Autofill Options<\/em><\/strong> \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c. C\u00f3 hai c\u00e1ch \u0111\u1ec3 t\u1ea1o danh s\u00e1ch n\u00e0y.<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o g\u00f3c v\u00f9ng s\u1ebd k\u00e9o, k\u00e9o th\u1ea3 chu\u1ed9t, danh s\u00e1ch c\u00e1c t\u00f9y ch\u1ecdn t\u1ef1 \u0111\u1ed9ng xu\u1ea5t hi\u1ec7n nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-options1.png\" alt=\"Get a list of AutoFill options\" title=\"autofill-options1\"><\/p>\n<ul>\n<li style=\"text-align: justify\"><strong><em>Copy Cells<\/em><\/strong> \u2013 t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n v\u00e0o v\u00f9ng d\u1eef li\u1ec7u c\u00e1c gi\u00e1 tr\u1ecb gi\u1ed1ng nhau.<\/li>\n<li style=\"text-align: justify\"><strong><em>Fill Series<\/em><\/strong> \u2013 \u0111i\u1ec1n c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau v\u00e0o m\u1ed9t hay nhi\u1ec1u \u00f4 t\u00ednh. <strong><em>Autofill <\/em><\/strong>s\u1ebd \u0111i\u1ec1n v\u00e0o v\u00f9ng d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1eabu c\u00f3 s\u1eb5n.<\/li>\n<li style=\"text-align: justify\"><strong><em>Fill Formatting Only<\/em><\/strong> \u2013 t\u00f9y ch\u1ecdn n\u00e0y s\u1ebd sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng t\u1eeb \u00f4 t\u00ednh \u0111\u01b0\u1ee3c ch\u1ecdn, sau \u0111\u00f3 b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp c\u00e1c gi\u00e1 tr\u1ecb v\u00e0o \u00f4 t\u00ednh.<\/li>\n<li style=\"text-align: justify\"><strong><em>Fill Without Formatting<\/em><\/strong> \u2013 ch\u1ec9 sao ch\u00e9p gi\u00e1 tr\u1ecb. V\u00ed d\u1ee5, n\u1ebfu \u00f4 t\u00ednh b\u1eaft \u0111\u1ea7u c\u00f3 n\u1ec1n \u0111\u1ecf, t\u00f9y ch\u1ecdn s\u1ebd kh\u00f4ng sao ch\u00e9p m\u00e0u n\u1ec1n \u0111\u00f3 sang \u00f4 m\u1edbi.<\/li>\n<li style=\"text-align: justify\"><strong><em>Fill Days\/Weekdays\/Months\/Years<\/em><\/strong> \u2013 N\u1ebfu \u00f4 b\u1eaft \u0111\u1ea7u ch\u1ee9a gi\u00e1 tr\u1ecb ng\u00e0y, th\u1ee9, th\u00e1ng, n\u0103m, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng \u0111i\u1ec1n v\u00e0o v\u00f9ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn.<\/li>\n<li style=\"text-align: justify\"><strong><em>Linear Trend<\/em><\/strong> \u2013 t\u1ea1o ra c\u00e1c d\u00e3y s\u1ed1 li\u1ec1n k\u1ec1 ho\u1eb7c\u00a0 d\u00e3y s\u1ed1 ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3.<\/li>\n<li style=\"text-align: justify\"><strong><em>Growth Trend<\/em><\/strong> \u2013 t\u1ea1o ra m\u1ed9t d\u00e3y s\u1ed1 t\u0103ng theo quy t\u1eafc s\u1ed1 h\u1ecdc.<\/li>\n<li style=\"text-align: justify\"><strong><em>Flash Fill<\/em><\/strong> \u2013 gi\u00fap b\u1ea1n nh\u1eadp nhi\u1ec1u th\u00f4ng tin l\u1eb7p l\u1ea1i c\u00f3 c\u00f9ng \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<li style=\"text-align: justify\"><strong><em>Series \u2026<\/em><\/strong> \u2013 l\u1ef1a ch\u1ecdn n\u00e0y s\u1ebd m\u1edf h\u1ed9p tho\u1ea1i <strong>Series<\/strong> v\u1edbi nhi\u1ec1u l\u1ef1a ch\u1ecdn m\u1edf r\u1ed9ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-series-dialog.png\" alt=\"See the Series dialog box with a number of advanced options to choose from\" title=\"autofill-series-dialog\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 t\u1ea1o danh s\u00e1ch \u0111\u00f3 l\u00e0 nh\u1ea5p v\u00e0o <strong><em>fill handle<\/em><\/strong>, k\u00e9o th\u1ea3 chu\u1ed9t, sau \u0111\u00f3 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Autofill Options<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-options-icon.png\" alt=\"Click on this icon\" title=\"autofill-options-icon\"><\/p>\n<p style=\"text-align: justify\">Khi \u0111\u00f3, danh s\u00e1ch t\u00f9y ch\u1ecdn <strong><em>Autofill <\/em><\/strong>s\u1ebd hi\u1ec7n ra.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/autofill-options2.png\" alt=\"Click on the Auto Fill Options icon to get this list\" title=\"autofill-options2\"><\/p>\n<p style=\"text-align: center\">Danh s\u00e1ch n\u00e0y ch\u1ec9 ch\u1ee9a m\u1ed9t s\u1ed1 t\u00f9y ch\u1ecdn \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Excel_%E2%80%93_Autofill_cong_thuc\"><\/span><strong>Excel \u2013 Autofill c\u00f4ng th\u1ee9c:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">T\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c c\u00f4ng th\u1ee9c l\u00e0 qu\u00e1 tr\u00ecnh kh\u00e1 gi\u1ed1ng v\u1edbi vi\u1ec7c sao ch\u00e9p c\u00e1c gi\u00e1 tr\u1ecb xu\u1ed1ng, t\u01b0\u01a1ng t\u1ef1 vi\u1ec7c k\u00e9o th\u1ea3 <strong><em>fill handle. <\/em><\/strong>B\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t s\u1ed1 m\u1eb9o v\u00e0 th\u1ee7 thu\u1eadt h\u1eefu \u00edch trong \u00a0m\u1ed9t trong nh\u1eefng b\u00e0i vi\u1ebft tr\u01b0\u1edbc \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i <strong><em>C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 ch\u00e8n c\u00f4ng th\u1ee9c v\u00e0o to\u00e0n b\u1ed9 c\u1ed9t.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Flash fill trong Excel 2013, 2016<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng Office 2013, 2016 b\u1ea1n c\u00f3 th\u1ec3 th\u1eed <strong><em>Flash Fill<\/em><\/strong>, m\u1ed9t t\u00ednh n\u0103ng m\u1edbi \u0111\u01b0\u1ee3c gi\u1edbi thi\u1ec7u trong phi\u00ean b\u1ea3n Excel g\u1ea7n \u0111\u00e2y nh\u1ea5t<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-5602 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-10.png\" width=\"600\" height=\"321\" title=\"excel-dialog-box-launcher-1-10\"><\/p>\n<p style=\"text-align: justify\"><strong>T\u00ecm hi\u1ec3u th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2013\">h\u1ecdc Excel 2013<\/a>,\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2016\">h\u1ecdc Excel 2016<\/a><\/p>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch ng\u1eafn g\u1ecdn, <strong><em>Flash Fill <\/em><\/strong>nghi\u00ean c\u1ee9u d\u1eef li\u1ec7u b\u1ea1n nh\u1eadp v\u00e0p v\u00e0 \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng, ki\u1ec3m tra d\u1eef li\u1ec7u \u0111\u00f3 \u0111\u00e3 xu\u1ea5t hi\u1ec7n trong trang t\u00ednh ch\u01b0a. N\u1ebfu <strong><em>Flash Fill <\/em><\/strong>nh\u1eadn bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng gi\u00e1 tr\u1ecb n\u00e0y, n\u00f3 s\u1ebd ch\u1ecdn v\u00e0 \u0111\u1ec1 xu\u1ea5t v\u1edbi b\u1ea1n m\u1ed9t danh s\u00e1ch d\u1ef1a tr\u00ean ch\u00fang. B\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n Enter \u0111\u1ec3 d\u00e1n ch\u00fang hay b\u1ecf qua. H\u00e3y xem c\u00e1c thao t\u00e1c trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-flash-fill-sample.png\" alt=\"Use Flash Fill in Excel 2013 to quickly unify the format of numerous cells\" title=\"excel-flash-fill-sample\"><\/p>\n<p style=\"text-align: justify\"><strong><em>Flash Fill <\/em><\/strong>cho ph\u00e9p b\u1ea1n \u0111\u1ecbnh d\u1ea1ng t\u00ean, ng\u00e0y sinh, s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ch\u1ec9 b\u1eb1ng m\u1ed9t c\u00fa click chu\u1ed9t. B\u1ea1n g\u00f5 v\u00e0o d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean \u0111\u1ec3 Excel c\u00f3 th\u1ec3 nh\u1eadn d\u1ea1ng v\u00e0 s\u1eed d\u1ee5ng. Ph\u1ea7n ti\u1ebfp theo c\u1ee7a b\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft h\u01a1n c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng h\u1eefu \u00edch n\u00e0y.<\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 bi\u1ebft th\u00eam nhi\u1ec1u h\u00e0m n\u00e2ng cao trong Excel c\u0169ng nh\u01b0 s\u1eed d\u1ee5ng t\u1ed1t h\u01a1n c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1c b\u1ea1n h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2MR2q4q\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, gi\u00fap b\u1ea1n ph\u00e1t tri\u1ec3n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng. \u0110\u1eb7c bi\u1ec7t kh\u00f3a h\u1ecdc n\u00e0y kh\u00f4ng gi\u1edbi h\u1ea1n th\u1eddi gian h\u1ecdc t\u1eadp, n\u00ean b\u1ea1n c\u00f3 th\u1ec3 h\u1ecdc tho\u1ea3i m\u00e1i v\u00e0 xem l\u1ea1i b\u1ea5t c\u1ee9 khi n\u00e0o.<\/p>\n<p>Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-309.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7637","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=7637"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7637\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7638"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}