{"id":987,"date":"2023-08-29T01:08:10","date_gmt":"2023-08-28T18:08:10","guid":{"rendered":"https:\/\/trannghiait.com\/?p=987"},"modified":"2023-08-29T01:08:10","modified_gmt":"2023-08-28T18:08:10","slug":"tong-hop-3-cach-danh-so-thu-tu-tren-excel-don-gian-de-hieu-cho-dan-van-phong","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/08\/29\/tong-hop-3-cach-danh-so-thu-tu-tren-excel-don-gian-de-hieu-cho-dan-van-phong\/","title":{"rendered":"T\u1ed5ng h\u1ee3p 3 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 tr\u00ean Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u cho d\u00e2n v\u0103n ph\u00f2ng"},"content":{"rendered":"\n<p>\u0110\u00e1nh s\u1ed1 tr\u00ean Excel l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c c\u1ea7n thi\u1ebft khi b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp c\u00e1c d\u00f2ng ho\u1eb7c c\u1ed9t trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Excel cung c\u1ea5p nhi\u1ec1u c\u00e1ch \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 tr\u00ean b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n, t\u1eeb c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ebfn c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng h\u1ed7 tr\u1ee3 \u0111\u00e1nh s\u1ed1 t\u1ef1 \u0111\u1ed9ng. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1c c\u00e1ch \u0111\u00e1nh s\u1ed1 tr\u00ean Excel.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_64 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/29\/tong-hop-3-cach-danh-so-thu-tu-tren-excel-don-gian-de-hieu-cho-dan-van-phong\/#Cach_1_Su_dung_cong_thuc\" title=\"C\u00e1ch 1: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c\">C\u00e1ch 1: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/29\/tong-hop-3-cach-danh-so-thu-tu-tren-excel-don-gian-de-hieu-cho-dan-van-phong\/#Cach_2_Su_dung_tinh_nang_Fill\" title=\"C\u00e1ch 2: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Fill\">C\u00e1ch 2: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Fill<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/29\/tong-hop-3-cach-danh-so-thu-tu-tren-excel-don-gian-de-hieu-cho-dan-van-phong\/#Cach_3_Su_dung_tinh_nang_Numbering\" title=\"C\u00e1ch 3: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Numbering\">C\u00e1ch 3: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Numbering<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/29\/tong-hop-3-cach-danh-so-thu-tu-tren-excel-don-gian-de-hieu-cho-dan-van-phong\/#Loi_ich_va_tac_hai_cua_viec_danh_so_tren_Excel\" title=\"L\u1ee3i \u00edch v\u00e0 t\u00e1c h\u1ea1i c\u1ee7a vi\u1ec7c \u0111\u00e1nh s\u1ed1 tr\u00ean Excel\">L\u1ee3i \u00edch v\u00e0 t\u00e1c h\u1ea1i c\u1ee7a vi\u1ec7c \u0111\u00e1nh s\u1ed1 tr\u00ean Excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_1_Su_dung_cong_thuc\"><\/span><strong>C\u00e1ch 1: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 tr\u00ean Excel l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ROW () ho\u1eb7c COLUMN (). C\u00f4ng th\u1ee9c n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng ho\u1eb7c c\u1ed9t hi\u1ec7n t\u1ea1i trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0110\u1ec3 \u0111\u00e1nh s\u1ed1 h\u00e0ng, h\u00e3y ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1, sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c =ROW() v\u00e0 nh\u1ea5n Enter.<\/li>\n\n\n\n<li>Khi b\u1ea1n nh\u1ea5n Enter, Excel s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng hi\u1ec7n t\u1ea1i trong \u00f4 \u0111\u00f3. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng c\u00e1c \u00f4 kh\u00e1c \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 cho c\u00e1c h\u00e0ng kh\u00e1c.<\/li>\n\n\n\n<li>T\u01b0\u01a1ng t\u1ef1, n\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1 cho c\u00e1c c\u1ed9t, h\u00e3y ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1, sau \u0111\u00f3 nh\u1eadp c\u00f4ng th\u1ee9c =COLUMN() v\u00e0 nh\u1ea5n Enter.<\/li>\n\n\n\n<li>Khi b\u1ea1n nh\u1ea5n Enter, Excel s\u1ebd hi\u1ec3n th\u1ecb s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t hi\u1ec7n t\u1ea1i trong \u00f4 \u0111\u00f3. B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o c\u00f4ng th\u1ee9c n\u00e0y sang ph\u1ea3i \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 cho c\u00e1c c\u1ed9t kh\u00e1c.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-126.png\" alt=\"\" class=\"wp-image-988\" style=\"width:316px;height:388px\" width=\"316\" height=\"388\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-126.png 353w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-126-244x300.png 244w\" sizes=\"(max-width: 316px) 100vw, 316px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_2_Su_dung_tinh_nang_Fill\"><\/span><strong>C\u00e1ch 2: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Fill<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel cung c\u1ea5p t\u00ednh n\u0103ng Fill \u0111\u1ec3 gi\u00fap b\u1ea1n nhanh ch\u00f3ng \u0111\u00e1nh s\u1ed1 cho nhi\u1ec1u h\u00e0ng ho\u1eb7c c\u1ed9t trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0110\u1ec3 s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Fill, h\u00e3y ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1.<\/li>\n\n\n\n<li>Nh\u1eadp s\u1ed1 \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ea5t hi\u1ec7n trong chu\u1ed7i s\u1ed1 c\u1ee7a m\u00ecnh.<\/li>\n\n\n\n<li>Nh\u1ea5n Enter \u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn \u00f4 ti\u1ebfp theo v\u00e0 nh\u1eadp s\u1ed1 ti\u1ebfp theo c\u1ee7a chu\u1ed7i s\u1ed1.<\/li>\n\n\n\n<li>Ch\u1ecdn c\u00e1c \u00f4 \u0111\u00e3 nh\u1eadp v\u00e0 k\u00e9o xu\u1ed1ng b\u1eb1ng c\u00e1ch gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o chu\u1ed9t xu\u1ed1ng ph\u00eda d\u01b0\u1edbi.<\/li>\n\n\n\n<li>Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n c\u00e1c s\u1ed1 ti\u1ebfp theo trong chu\u1ed7i s\u1ed1 c\u1ee7a b\u1ea1n.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-127.png\" alt=\"\" class=\"wp-image-989\" style=\"width:270px;height:330px\" width=\"270\" height=\"330\" srcset=\"https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-127.png 361w, https:\/\/trannghiait.com\/wp-content\/uploads\/2023\/08\/image-127-245x300.png 245w\" sizes=\"(max-width: 270px) 100vw, 270px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cach_3_Su_dung_tinh_nang_Numbering\"><\/span><strong>C\u00e1ch 3: S\u1eed d\u1ee5ng t\u00ednh n\u0103ng Numbering<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Excel c\u0169ng cung c\u1ea5p t\u00ednh n\u0103ng Numbering \u0111\u1ec3 gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh s\u1ed1 cho c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ch\u1ecdn c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u00e1nh s\u1ed1.<\/li>\n\n\n\n<li>Nh\u1ea5p v\u00e0o tab Home v\u00e0 ch\u1ecdn Numbering trong nh\u00f3m Editing.<\/li>\n\n\n\n<li>Ch\u1ecdn ki\u1ec3u \u0111\u00e1nh s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng t\u1eeb danh s\u00e1ch c\u00e1c ki\u1ec3u c\u00f3 s\u1eb5n.<\/li>\n\n\n\n<li>Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u00e1nh s\u1ed1 cho c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn c\u1ee7a b\u1ea1n.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Loi_ich_va_tac_hai_cua_viec_danh_so_tren_Excel\"><\/span><strong>L\u1ee3i \u00edch v\u00e0 t\u00e1c h\u1ea1i c\u1ee7a vi\u1ec7c \u0111\u00e1nh s\u1ed1 tr\u00ean Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Vi\u1ec7c \u0111\u00e1nh s\u1ed1 tr\u00ean Excel gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng s\u1eafp x\u1ebfp v\u00e0 qu\u1ea3n l\u00fd c\u00e1c d\u00f2ng ho\u1eb7c c\u1ed9t trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Tuy nhi\u00ean, vi\u1ec7c qu\u00e1 s\u1eed d\u1ee5ng \u0111\u00e1nh s\u1ed1 c\u00f3 th\u1ec3 l\u00e0m cho b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n tr\u1edf n\u00ean r\u1ed1i v\u00e0 kh\u00f3 nh\u00ecn. Do \u0111\u00f3, b\u1ea1n n\u00ean ch\u1ec9 \u0111\u00e1nh s\u1ed1 cho c\u00e1c d\u00f2ng ho\u1eb7c c\u1ed9t quan tr\u1ecdng ho\u1eb7c khi c\u1ea7n thi\u1ebft \u0111\u1ec3 gi\u00fap cho vi\u1ec7c qu\u1ea3n l\u00fd b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c thu\u1eadn ti\u1ec7n h\u01a1n.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>\u0110\u00e1nh s\u1ed1 tr\u00ean Excel l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c c\u1ea7n thi\u1ebft khi b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp c\u00e1c d\u00f2ng ho\u1eb7c c\u1ed9t trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Excel <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/08\/29\/tong-hop-3-cach-danh-so-thu-tu-tren-excel-don-gian-de-hieu-cho-dan-van-phong\/\" title=\"T\u1ed5ng h\u1ee3p 3 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 tr\u00ean Excel \u0111\u01a1n gi\u1ea3n d\u1ec5 hi\u1ec3u cho d\u00e2n v\u0103n ph\u00f2ng\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":776,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-987","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=987"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/987\/revisions"}],"predecessor-version":[{"id":990,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/987\/revisions\/990"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media\/776"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}