{"id":8945,"date":"2024-12-30T17:44:45","date_gmt":"2024-12-30T17:44:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/30\/huong-dan-tong-hop-cac-tinh-nang-fill-trong-excel-phan-1\/"},"modified":"2024-12-30T17:44:45","modified_gmt":"2024-12-30T17:44:45","slug":"huong-dan-tong-hop-cac-tinh-nang-fill-trong-excel-phan-1","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/30\/huong-dan-tong-hop-cac-tinh-nang-fill-trong-excel-phan-1\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ed5ng h\u1ee3p c\u00e1c t\u00ednh n\u0103ng Fill trong Excel (ph\u1ea7n 1)"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Fill trong Excel l\u00e0 m\u1ed9t t\u00ednh n\u0103ng h\u1eefu d\u1ee5ng cho ph\u00e9p b\u1ea1n t\u1ef1 \u0111\u1ed9ng fill (l\u00e0m \u0111\u1ea7y) danh s\u00e1ch d\u1eef li\u1ec7u trong h\u00e0ng ho\u1eb7c c\u1ed9t th\u00f4ng qua nh\u1eefng thao t\u00e1c \u0111\u01a1n gi\u1ea3n. \u0110i\u1ec1u n\u00e0y s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m kh\u00e1 nhi\u1ec1u th\u1eddi gian khi l\u00e0m vi\u1ec7c c\u00f9ng c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn v\u00e0 gi\u00fap n\u0103ng su\u1ea5t t\u0103ng l\u00ean r\u00f5 r\u1ec7t. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn t\u1ed5ng h\u1ee3p c\u00e1c t\u00ednh n\u0103ng Fill trong Excel.<\/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-6772dc0c6aa99\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cac-tinh-nang-fill-trong-excel-phan-1.html#Fill_trong_Excel_%E2%80%93_danh_sach_cac_so_theo_cap_so_cong\" title=\"Fill trong Excel \u2013 danh s\u00e1ch c\u00e1c s\u1ed1 theo c\u1ea5p s\u1ed1 c\u1ed9ng\">Fill trong Excel \u2013 danh s\u00e1ch c\u00e1c s\u1ed1 theo c\u1ea5p s\u1ed1 c\u1ed9ng<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-tinh-nang-fill-trong-excel-phan-1.html#Su_dung_AutoFill\" title=\"S\u1eed d\u1ee5ng AutoFill\">S\u1eed d\u1ee5ng AutoFill<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cac-tinh-nang-fill-trong-excel-phan-1.html#Su_dung_chuc_nang_Fill\" title=\"S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Fill\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Fill<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Fill_trong_Excel_%E2%80%93_danh_sach_cac_so_theo_cap_so_cong\"><\/span>Fill trong Excel \u2013 danh s\u00e1ch c\u00e1c s\u1ed1 theo c\u1ea5p s\u1ed1 c\u1ed9ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_AutoFill\"><\/span>S\u1eed d\u1ee5ng AutoFill<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed9t trong nh\u1eefng ki\u1ec3u Fill th\u01b0\u1eddng g\u1eb7p \u0111\u00f3 l\u00e0 \u0111i\u1ec1n danh s\u00e1ch d\u1eef li\u1ec7u v\u00e0o h\u00e0ng\/c\u1ed9t d\u1eef li\u1ec7u li\u1ec1n k\u1ec1 nhau. Nh\u1eefng d\u1eef li\u1ec7u \u1edf \u0111\u00e2y c\u00f3 th\u1ec3 t\u0103ng ti\u1ebfn 1, 2, 3, 4 ho\u1eb7c 1.5, 3.5, 5.5, hay l\u00e0 -1, -4, -7.<\/p>\n<p>Ta s\u1ebd b\u1eaft \u0111\u1ea7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26285\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-1.png\" width=\"331\" height=\"124\" title=\"tinh-nang-fill-1\"><\/p>\n<p>\u00a0<\/p>\n<p>B\u1ea1n c\u00f3 \u0111\u1ec3 \u00fd t\u1edbi \u00f4 vu\u00f4ng \u1edf g\u00f3c d\u01b0\u1edbi, b\u00ean ph\u1ea3i \u00f4 A1 kh\u00f4ng? \u0110\u00f3 l\u00e0 n\u01a1i ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26286\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-2.png\" width=\"287\" height=\"107\" title=\"tinh-nang-fill-2\"><\/p>\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-841.gif\" title=\"ex101_92019-nho-841\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Khi b\u1ea1n \u0111\u01b0a con tr\u1ecf chu\u1ed9t v\u00e0o, n\u00f3 chuy\u1ec3n th\u00e0nh d\u1ea5u c\u1ed9ng c\u00f3 m\u00e0u \u0111en. V\u1edbi d\u1ea5u hi\u1ec7u n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfn h\u00e0nh thao t\u00e1c fill b\u1eb1ng c\u00e1ch gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o th\u1ea3 cho t\u1edbi khi \u0111\u1ea1t \u0111\u01b0\u1ee3c s\u1ed1 l\u01b0\u1ee3ng \u00f4 nh\u01b0 mong mu\u1ed1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26287\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-3.png\" width=\"402\" height=\"501\" title=\"tinh-nang-fill-3\"><\/p>\n<p>Khi ti\u1ebfn h\u00e0nh k\u00e9o th\u1ea3 b\u1eb1ng chu\u1ed9t tr\u00e1i, m\u1ed9t pop-up menu s\u1ebd hi\u1ec7n l\u00ean. T\u1ea1i \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nh\u1eefng ph\u01b0\u01a1ng th\u1ee9c fill bao g\u1ed3m:<\/p>\n<ol>\n<li><strong>Copy Cells:\u00a0<\/strong>Copy \u00f4 \u0111\u1ea7u ti\u00ean n\u01a1i \u0111\u1eb7t fill cho nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.<\/li>\n<li><strong>Fill Series:\u00a0<\/strong>\u0110i\u1ec1n m\u1ed9t danh s\u00e1ch theo d\u00e3y s\u1ed1 t\u0103ng ti\u1ebfn th\u1ee9 b\u1eadc (VD: 1, 2, 3, 4, 5)<\/li>\n<li><strong>Fill Formatting Only:\u00a0<\/strong>Ch\u1ec9 \u0111i\u1ec1n \u0111\u1ecbnh d\u1ea1ng v\u00e0o nh\u1eefng \u00f4 c\u00f2n l\u1ea1i<\/li>\n<li><strong>Fill Without Formatting:\u00a0<\/strong>\u0110i\u1ec1n d\u1eef li\u1ec7u, kh\u00f4ng \u0111i\u1ec1n \u0111\u1ecbnh d\u1ea1ng<\/li>\n<li><strong>Flash Fill:\u00a0<\/strong>T\u00ednh n\u0103ng xu\u1ea5t hi\u1ec7n t\u1eeb Excel 2013. T\u1ef1 \u0111\u1ed9ng \u0111o\u00e1n v\u00e0 \u0111i\u1ec1n theo \u00fd mu\u1ed1n ng\u01b0\u1eddi d\u00f9ng.<\/li>\n<\/ol>\n<p>Ngo\u00e0i ra, khi k\u00e9o th\u1ea3 b\u1eb1ng\u00a0<strong>chu\u1ed9t ph\u1ea3i<\/strong>, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Fill t\u01b0\u01a1ng t\u1ef1:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26288\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-4.png\" width=\"479\" height=\"346\" title=\"tinh-nang-fill-4\"><\/p>\n<p>Ngo\u00e0i ra, v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng chu\u1ed9t ph\u1ea3i b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn s\u1ed1 \u0111\u01a1n v\u1ecb th\u1ee9 b\u1eadc trong Fill series b\u1eb1ng c\u00e1ch click v\u00e0o\u00a0<strong>Series\u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26289\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-5.png\" width=\"290\" height=\"229\" title=\"tinh-nang-fill-5\"><\/p>\n<p>Vi\u1ec7c thay \u0111\u1ed5i Step value s\u1ebd quy\u1ebft \u0111\u1ecbnh d\u00e3y s\u1ed1 c\u1ee7a b\u1ea1n l\u00e0\u00a0<strong>1 2 3 4 5<\/strong> hay\u00a0<strong>1 3 5 7 9<\/strong><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_Fill\"><\/span>S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Fill<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>N\u1ebfu b\u1ea1n g\u1eb7p v\u1ea5n \u0111\u1ec1 v\u1edbi AutoFill, c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c thay th\u1ebf l\u00e0 n\u00fat l\u1ec7nh tr\u00ean thanh Ribbon. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t n\u00fat l\u1ec7nh r\u1ea5t hi\u1ec7u qu\u1ea3 khi b\u1ea1n \u0111ang fill m\u1ed9t l\u01b0\u1ee3ng l\u1edbn c\u00e1c \u00f4 t\u00ednh.<\/p>\n<p>V\u1ecb tr\u00ed c\u1ee7a n\u00fat l\u1ec7nh Fill:\u00a0th\u1ebb\u00a0<strong>Home<\/strong>, nh\u00f3m\u00a0<strong>Editing.<\/strong><\/p>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y, \u0111\u1ea7u ti\u00ean ta nh\u1eadp gi\u00e1 tr\u1ecb kh\u1edfi \u0111\u1ea7u v\u00e0 ch\u1ecdn t\u1ea5t c\u1ea3 nh\u1eefng \u00f4 mu\u1ed1n s\u1eed d\u1ee5ng Fill. Sau \u0111\u00f3, click v\u00e0o \u201cFill\u201d v\u00e0 ch\u1ecdn \u201cSeries\u2026\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26290\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-6.png\" width=\"336\" height=\"404\" title=\"tinh-nang-fill-6\"><\/p>\n<p>T\u1ea1i h\u1ed9p tho\u1ea1i m\u1edbi xu\u1ea5t hi\u1ec7n, l\u1ef1a ch\u1ecdn b\u1ea1n mu\u1ed1n Fill cho h\u00e0ng hay c\u1ed9t (\u00e1p d\u1ee5ng khi b\u1ea1n ch\u1ecdn \u0111\u1ed3ng th\u1eddi c\u1ea3 h\u00e0ng v\u00e0 c\u1ed9t).<\/p>\n<p>Trong ph\u1ea7n 1 n\u00e0y, h\u00e3y ch\u1ecdn <strong>Linear. Growth\u00a0<\/strong>v\u00e0\u00a0<strong>Date<\/strong> ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u sau c\u00f2n\u00a0<strong>AutoFill<\/strong> s\u1ebd copy gi\u00e1 tr\u1ecb \u0111i\u1ec1n v\u00e0o nh\u1eefng \u00f4 sau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26291\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-7.png\" width=\"285\" height=\"228\" title=\"tinh-nang-fill-7\"><\/p>\n<p>Ch\u1ecdn\u00a0<strong>Step value<\/strong> v\u00e0 nh\u1eadp v\u00e0o gi\u00e1 tr\u1ecb nh\u1ea3y b\u1eadc. V\u00ed d\u1ee5, ta mu\u1ed1n nh\u1ea3y 4 b\u1eadc, \u0111i\u1ec1n v\u00e0o 4 sao \u0111\u00f3 \u1ea5n OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26292\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-8.png\" width=\"217\" height=\"286\" title=\"tinh-nang-fill-8\"><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n \u0111\u00e3 ch\u1ecdn m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng r\u1ea5t nhi\u1ec1u h\u00e0ng ho\u1eb7c c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0<strong>Stop value<\/strong> \u0111\u1ec3 gi\u1edbi h\u1ea1n. T\u00ednh n\u0103ng n\u00e0y s\u1ebd ng\u0103n \u0111i\u1ec3m cu\u1ed1i c\u1ee7a d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c Fill. Trong v\u00ed d\u1ee5 tr\u00ean, n\u1ebfu \u0111\u1eb7t\u00a0<strong>Stop value\u00a0<\/strong>l\u00e0 10, gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c fill s\u1ebd ch\u1ec9 d\u1eebng l\u1ea1i \u1edf\u00a0<strong>9<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26293\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-9.png\" width=\"290\" height=\"229\" title=\"tinh-nang-fill-9\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-26294\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tinh-nang-fill-10.png\" width=\"282\" height=\"293\" title=\"tinh-nang-fill-10\"><\/p>\n<p>V\u1eady l\u00e0 ta \u0111\u00e3 \u0111i qua c\u00e1ch \u0111\u1ec3 fill danh s\u00e1ch th\u1ee9 b\u1eadc v\u1edbi Fill. Trong ph\u1ea7n ti\u1ebfp theo, h\u00e3y c\u00f9ng \u0111\u00f3n \u0111\u1ecdc m\u1ed9t s\u1ed1 ph\u01b0\u01a1ng ph\u00e1p Fill kh\u00e1c nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t v\u00e0 xem th\u00eam nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan t\u1ea1i \u0111\u00e2y:<\/p>\n<p>\u00a0<\/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\/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-841.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8946,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8945","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\/8945","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=8945"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8945\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8946"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}