{"id":455419,"date":"2025-05-08T21:01:38","date_gmt":"2025-05-08T14:01:38","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=455419"},"modified":"2025-05-08T21:01:38","modified_gmt":"2025-05-08T14:01:38","slug":"cach-danh-so-thu-tu-trong-excel-2","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/","title":{"rendered":"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">B\u1ea1n \u0111ang loay hoay v\u1edbi c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel v\u1edbi h\u00e0ng tr\u0103m d\u00f2ng? \u0110\u1eebng lo! B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 chu\u1ea9n trong Excel c\u1ef1c k\u1ef3 nhanh g\u1ecdn t\u1eeb thao t\u00e1c th\u1ee7 c\u00f4ng, s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Fill Series, \u0111\u1ebfn \u1ee9ng d\u1ee5ng h\u00e0m th\u00f4ng minh. D\u00f9 b\u1ea1n l\u00e0 ng\u01b0\u1eddi m\u1edbi hay \u0111\u00e3 quen d\u00f9ng Excel, nh\u1eefng m\u1eb9o d\u01b0\u1edbi \u0111\u00e2y ch\u1eafc ch\u1eafn s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 thao t\u00e1c ch\u00ednh x\u00e1c h\u01a1n.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 trong b\u1ea3ng t\u00ednh kh\u00f4ng ch\u1ec9 gi\u00fap d\u1eef li\u1ec7u d\u1ec5 nh\u00ecn, m\u00e0 c\u00f2n h\u1ed7 tr\u1ee3 vi\u1ec7c l\u1ecdc, ph\u00e2n t\u00edch v\u00e0 tr\u00ecnh b\u00e0y chuy\u00ean nghi\u1ec7p h\u01a1n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 chu\u1ea9n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n, ph\u00f9 h\u1ee3p cho c\u1ea3 ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u l\u1eabn ng\u01b0\u1eddi d\u00f9ng th\u00e0nh th\u1ea1o:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00e1ch n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi danh s\u00e1ch ng\u1eafn, thao t\u00e1c \u0111\u01a1n gi\u1ea3n, kh\u00f4ng c\u1ea7n d\u00f9ng \u0111\u1ebfn c\u00f4ng th\u1ee9c hay c\u00f4ng c\u1ee5 n\u00e2ng cao.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf b\u1ea3ng t\u00ednh Excel, ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean n\u01a1i b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u \u0111\u00e1nh s\u1ed1. Nh\u1eadp s\u1ed1 1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ngay b\u00ean d\u01b0\u1edbi, trong \u00f4 ti\u1ebfp theo, nh\u1eadp s\u1ed1 2.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: D\u00f9ng chu\u1ed9t qu\u00e9t ch\u1ecdn c\u1ea3 hai \u00f4 ch\u1ee9a s\u1ed1 1 v\u00e0 2.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-455421 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-1.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn. Khi xu\u1ea5t hi\u1ec7n d\u1ea5u c\u1ed9ng m\u00e0u \u0111en (+), nh\u1ea5n gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng theo s\u1ed1 d\u00f2ng b\u1ea1n mu\u1ed1n t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-455422 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-2.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">S\u1ed1 th\u1ee9 t\u1ef1 s\u1ebd t\u0103ng d\u1ea7n theo quy lu\u1eadt c\u1ee7a hai \u00f4 \u0111\u1ea7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n x\u00f3a m\u1ed9t d\u00f2ng trong danh s\u00e1ch, th\u1ee9 t\u1ef1 s\u1ebd kh\u00f4ng t\u1ef1 c\u1eadp nh\u1eadt l\u1ea1i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y n\u00ean d\u00f9ng khi b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u00e1nh s\u1ed1 nhanh cho v\u00e0i ch\u1ee5c d\u00f2ng tr\u1edf xu\u1ed1ng.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c c\u1ed9ng l\u1eb7p<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">D\u00e0nh cho b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 \u0111\u1ed9 d\u00e0i l\u1edbn, gi\u00fap b\u1ea1n t\u1ea1o s\u1ed1 th\u1ee9 t\u1ef1 m\u00e0 kh\u00f4ng ph\u1ea3i nh\u1eadp t\u1eebng s\u1ed1 th\u1ee7 c\u00f4ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1ch th\u1ef1c hi\u1ec7n chi ti\u1ebft:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1eadp s\u1ed1 1 v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong c\u1ed9t mu\u1ed1n \u0111\u00e1nh s\u1ed1, v\u00ed d\u1ee5 \u00f4 A2.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i \u00f4 A3 (ngay b\u00ean d\u01b0\u1edbi), nh\u1eadp c\u00f4ng th\u1ee9c: =A2+1<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-455423 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-3.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Di chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi c\u1ee7a \u00f4 A3, khi hi\u1ec7n d\u1ea5u c\u1ed9ng, h\u00e3y k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ebfn h\u1ebft b\u1ea3ng d\u1eef li\u1ec7u.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455424 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-4.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n x\u00f3a m\u1ed9t h\u00e0ng trong b\u1ea3ng, s\u1ed1 th\u1ee9 t\u1ef1 kh\u00f4ng t\u1ef1 c\u1eadp nh\u1eadt.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">D\u1ec5 th\u1ef1c hi\u1ec7n, kh\u00f4ng y\u00eau c\u1ea7u k\u1ef9 thu\u1eadt cao.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng h\u00e0m SEQUENCE\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m SEQUENCE ph\u00f9 h\u1ee3p v\u1edbi Excel phi\u00ean b\u1ea3n 2019 tr\u1edf l\u00ean ho\u1eb7c Microsoft 365, gi\u00fap t\u1ea1o chu\u1ed7i s\u1ed1 m\u00e0 kh\u00f4ng c\u1ea7n k\u00e9o.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Click ch\u1ecdn v\u00e0o \u00f4 n\u01a1i b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u chu\u1ed7i s\u1ed1 th\u1ee9 t\u1ef1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1eadp c\u00f4ng th\u1ee9c sau: =SEQUENCE(n). <\/span><span style=\"font-weight: 400;\">Trong \u0111\u00f3, n l\u00e0 s\u1ed1 h\u00e0ng b\u1ea1n c\u1ea7n \u0111\u00e1nh s\u1ed1. V\u00ed d\u1ee5: mu\u1ed1n \u0111\u00e1nh s\u1ed1 cho 10 d\u00f2ng, g\u00f5: =SEQUENCE(10)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n Enter, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n d\u00e3y s\u1ed1 t\u1eeb 1 \u0111\u1ebfn 10 v\u00e0o c\u00e1c d\u00f2ng li\u1ec1n k\u1ec1.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455425 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-5.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y kh\u00f4ng \u00e1p d\u1ee5ng \u0111\u01b0\u1ee3c n\u1ebfu b\u1ea1n mu\u1ed1n ch\u00e8n th\u00eam s\u1ed1 th\u1ee7 c\u00f4ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Kh\u00f4ng t\u01b0\u01a1ng th\u00edch v\u1edbi c\u00e1c phi\u00ean b\u1ea3n Excel c\u0169.<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng Auto Fill Series\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu c\u00f4ng c\u1ee5 Auto Fill ch\u01b0a xu\u1ea5t hi\u1ec7n tr\u00ean thanh Ribbon c\u1ee7a b\u1ea1n, c\u00f3 th\u1ec3 k\u00edch ho\u1ea1t th\u1ee7 c\u00f4ng b\u1eb1ng c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf Excel, nh\u1ea5n ch\u1ecdn m\u1ee5c File \u1edf g\u00f3c tr\u00ean b\u00ean tr\u00e1i.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455426 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-6.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Truy c\u1eadp v\u00e0o ph\u1ea7n Options \u0111\u1ec3 m\u1edf c\u00e0i \u0111\u1eb7t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455427 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-7.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Trong c\u1eeda s\u1ed5 m\u1edbi, nh\u1ea5n Customize Ribbon, sau \u0111\u00f3 ch\u1ecdn All Commands t\u1ea1i danh s\u00e1ch s\u1ed5 xu\u1ed1ng. T\u00ecm m\u1ee5c c\u00f3 t\u00ean Filter Series or Pattern.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455428 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-8.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: \u1ede c\u1ed9t b\u00ean ph\u1ea3i (Main Tabs), t\u00ecm \u0111\u1ebfn ph\u1ea7n Home, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Add New Group \u0111\u1ec3 t\u1ea1o nh\u00f3m t\u00f9y ch\u1ec9nh.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455429 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-9.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Nh\u1ea5n ch\u1ecdn l\u1ea1i Filter Series or Pattern, sau \u0111\u00f3 b\u1ea5m Add \u0111\u1ec3 th\u00eam v\u00e0o nh\u00f3m v\u1eeba t\u1ea1o, r\u1ed3i x\u00e1c nh\u1eadn b\u1eb1ng c\u00e1ch ch\u1ecdn OK.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455430 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-10.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi \u0111\u00e3 th\u00eam c\u00f4ng c\u1ee5 v\u00e0o Ribbon, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: G\u00f5 s\u1ed1 b\u1eaft \u0111\u1ea7u v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean trong c\u1ed9t (v\u00ed d\u1ee5: 1). Sau \u0111\u00f3 v\u00e0o Home &gt; Fill &gt; Series.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455431 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-11.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Trong h\u1ed9p tho\u1ea1i hi\u1ec7n ra:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u1ecdn Rows n\u1ebfu mu\u1ed1n \u0111\u00e1nh theo h\u00e0ng, ho\u1eb7c Columns n\u1ebfu \u0111\u00e1nh theo c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">M\u1ee5c Type g\u1ed3m 4 l\u1ef1a ch\u1ecdn:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Linear: T\u1ea1o d\u00e3y s\u1ed1 t\u0103ng \u0111\u1ec1u<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Growth: Theo c\u1ea5p s\u1ed1 nh\u00e2n<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Date: D\u1ea1ng ng\u00e0y th\u00e1ng<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Auto Fill: Excel t\u1ef1 \u0111\u1ed9ng x\u00e1c \u0111\u1ecbnh m\u1eabu \u0111i\u1ec1n<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Nh\u1eadp s\u1ed1 b\u1eaft \u0111\u1ea7u v\u00e0o Step value v\u00e0 s\u1ed1 k\u1ebft th\u00fac \u1edf Stop value<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, b\u1ea5m OK \u0111\u1ec3 t\u1ea1o d\u00e3y s\u1ed1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi ho\u00e0n t\u1ea5t, b\u1ea3ng t\u00ednh s\u1ebd hi\u1ec3n th\u1ecb chu\u1ed7i s\u1ed1 \u0111\u01b0\u1ee3c t\u1ea1o theo \u0111\u00fang c\u1ea5u h\u00ecnh b\u1ea1n \u0111\u00e3 \u0111\u1eb7t.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455432 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-12.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng h\u00e0m Row()-1<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y t\u1eadn d\u1ee5ng h\u00e0m ROW \u0111\u1ec3 t\u1ea1o d\u00e3y s\u1ed1 t\u1ef1 \u0111\u1ed9ng d\u1ef1a tr\u00ean v\u1ecb tr\u00ed h\u00e0ng hi\u1ec7n t\u1ea1i, sau \u0111\u00f3 tr\u1eeb \u0111i m\u1ed9t gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh s\u1ed1 b\u1eaft \u0111\u1ea7u theo \u00fd mu\u1ed1n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc thao t\u00e1c:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Trong \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t \u0111\u00e1nh s\u1ed1, nh\u1eadp c\u00f4ng th\u1ee9c: h\u00e0m h\u00e0ng tr\u1eeb \u0111i m\u1ed9t gi\u00e1 tr\u1ecb t\u00f9y ch\u1ec9nh. V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n \u0111ang \u1edf h\u00e0ng s\u1ed1 2 v\u00e0 mu\u1ed1n b\u1eaft \u0111\u1ea7u t\u1eeb s\u1ed1 th\u1ee9 t\u1ef1 1, b\u1ea1n h\u00e3y nh\u1eadp ROW()-1.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">N\u1ebfu b\u1eaft \u0111\u1ea7u t\u1eeb d\u00f2ng s\u1ed1 3 nh\u01b0ng mu\u1ed1n hi\u1ec3n th\u1ecb s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 1, h\u00e3y nh\u1eadp: ROW()-2.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">C\u1ee9 nh\u01b0 v\u1eady, n\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n b\u1eaft \u0111\u1ea7u \u1edf h\u00e0ng th\u1ee9 n, h\u00e3y t\u0103ng l\u00ean con s\u1ed1 t\u01b0\u01a1ng \u1ee9ng.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455434 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-14.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Khi c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c nh\u1eadp, h\u00e3y di chuy\u1ec3n chu\u1ed9t t\u1edbi g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 v\u1eeba nh\u1eadp. Khi con tr\u1ecf chuy\u1ec3n th\u00e0nh d\u1ea5u c\u1ed9ng, k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng ti\u1ebfp theo \u0111\u1ec3 t\u1ea1o chu\u1ed7i s\u1ed1.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455435 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-15.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 n\u00e0y r\u1ea5t nhanh v\u00e0 ti\u1ec7n cho b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 \u0111\u1ed9 d\u00e0i v\u1eeba ph\u1ea3i.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tuy nhi\u00ean, khi b\u1ea3ng c\u00f3 h\u00e0ng tr\u0103m d\u00f2ng, b\u1ea1n n\u00ean k\u1ebft h\u1ee3p v\u1edbi c\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao kh\u00e1c nh\u01b0 Auto Fill ho\u1eb7c t\u1ea1o b\u1ea3ng \u0111\u1ed9ng \u0111\u1ec3 tr\u00e1nh thao t\u00e1c k\u00e9o th\u1ee7 c\u00f4ng m\u1ea5t th\u1eddi gian.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">T\u1ea1i sao n\u00ean bi\u1ebft c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh, vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 kh\u00f4ng ch\u1ec9 mang t\u00ednh ch\u1ea5t h\u00ecnh th\u1ee9c m\u00e0 c\u00f2n gi\u00fap t\u0103ng hi\u1ec7u qu\u1ea3 x\u1eed l\u00fd, qu\u1ea3n l\u00fd v\u00e0 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 nh\u1eefng l\u1ee3i \u00edch n\u1ed5i b\u1eadt khi b\u1ea1n \u00e1p d\u1ee5ng \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u00fang c\u00e1ch trong Excel:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Gi\u00fap theo d\u00f5i d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi b\u1ea3ng t\u00ednh c\u00f3 h\u00e0ng tr\u0103m d\u00f2ng th\u00f4ng tin, vi\u1ec7c g\u00e1n s\u1ed1 th\u1ee9 t\u1ef1 s\u1ebd gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a t\u1eebng d\u00f2ng d\u1eef li\u1ec7u. B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i \u0111\u1ebfm th\u1ee7 c\u00f4ng hay k\u00e9o chu\u1ed9t qu\u00e1 l\u00e2u \u0111\u1ec3 t\u00ecm m\u1ee5c c\u1ea7n xem. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u00ecn v\u00e0o c\u1ed9t s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 bi\u1ebft ngay m\u00ecnh \u0111ang \u1edf \u0111\u00e2u.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455436 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-16.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u1ed7 tr\u1ee3 qu\u00e1 tr\u00ecnh l\u1ecdc, s\u1eafp x\u1ebfp v\u00e0 ph\u00e2n lo\u1ea1i<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">S\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong vi\u1ec7c l\u1ecdc ho\u1eb7c s\u1eafp x\u1ebfp d\u1eef li\u1ec7u m\u00e0 v\u1eabn gi\u1eef nguy\u00ean tr\u00ecnh t\u1ef1 ban \u0111\u1ea7u. Sau khi b\u1ea1n \u00e1p d\u1ee5ng c\u00e1c b\u1ed9 l\u1ecdc theo t\u00ean, ng\u00e0y th\u00e1ng ho\u1eb7c s\u1ed1 l\u01b0\u1ee3ng, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 d\u00f9ng s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0m c\u0103n c\u1ee9 \u0111\u1ec3 s\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u nh\u01b0 c\u0169 n\u1ebfu c\u1ea7n.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">T\u0103ng t\u00ednh tr\u1ef1c quan khi tr\u00ecnh b\u00e0y b\u1ea3ng t\u00ednh<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 lu\u00f4n tr\u00f4ng chuy\u00ean nghi\u1ec7p v\u00e0 d\u1ec5 nh\u00ecn h\u01a1n. C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u1eb7c bi\u1ec7t quan tr\u1ecdng khi b\u1ea1n chia s\u1ebb b\u00e1o c\u00e1o, g\u1eedi file cho \u0111\u1ed3ng nghi\u1ec7p ho\u1eb7c tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u v\u1edbi c\u1ea5p tr\u00ean gi\u00fap h\u1ecd n\u1eafm b\u1eaft th\u00f4ng tin nhanh ch\u00f3ng v\u00e0 r\u00f5 r\u00e0ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455437 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-17.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">D\u1ec5 d\u00e0ng ki\u1ec3m tra v\u00e0 \u0111\u1ed1i chi\u1ebfu th\u00f4ng tin<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi l\u00e0m vi\u1ec7c nh\u00f3m ho\u1eb7c ki\u1ec3m tra l\u1ea1i d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o, vi\u1ec7c c\u00f3 s\u1eb5n s\u1ed1 th\u1ee9 t\u1ef1 s\u1ebd gi\u00fap b\u1ea1n \u0111\u1ed1i chi\u1ebfu th\u00f4ng tin nhanh ch\u00f3ng gi\u1eefa c\u00e1c b\u1ea3ng ho\u1eb7c b\u1ea3n in. Ch\u1ec9 c\u1ea7n n\u00eau \u201cd\u00f2ng s\u1ed1 15\u201d l\u00e0 m\u1ecdi ng\u01b0\u1eddi \u0111\u1ec1u hi\u1ec3u \u0111ang n\u00f3i \u0111\u1ebfn m\u1ee5c n\u00e0o \u0111\u1ec3 tr\u00e1nh nh\u1ea7m l\u1eabn v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian trao \u0111\u1ed5i.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">H\u1ea1n ch\u1ebf nh\u1ea7m l\u1eabn khi thao t\u00e1c tr\u00ean d\u1eef li\u1ec7u l\u1edbn<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh c\u00f3 quy m\u00f4 v\u00e0i tr\u0103m \u0111\u1ebfn h\u00e0ng ng\u00e0n d\u00f2ng, thi\u1ebfu s\u1ed1 th\u1ee9 t\u1ef1 c\u00f3 th\u1ec3 g\u00e2y ra l\u1ed7i thao t\u00e1c, nh\u01b0 ch\u00e8n sai d\u00f2ng, b\u1ecf s\u00f3t d\u1eef li\u1ec7u, ho\u1eb7c nh\u1eadp tr\u00f9ng. C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap b\u1ea1n ki\u1ec3m so\u00e1t ch\u1eb7t ch\u1ebd m\u1ecdi thay \u0111\u1ed5i trong b\u1ea3ng.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u01b0u \u00fd trong c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">M\u1eb7c d\u00f9 vi\u1ec7c \u0111\u00e1nh s\u1ed1 trong Excel kh\u00e1 \u0111\u01a1n gi\u1ea3n, nh\u01b0ng \u0111\u1ec3 b\u1ea3ng d\u1eef li\u1ec7u ho\u1ea1t \u0111\u1ed9ng \u1ed5n \u0111\u1ecbnh v\u00e0 d\u1ec5 ki\u1ec3m so\u00e1t, b\u1ea1n n\u00ean l\u01b0u \u00fd m\u1ed9t v\u00e0i \u0111i\u1ec3m d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Kh\u00f4ng ph\u1ea3i c\u00e1ch n\u00e0o c\u0169ng c\u1eadp nh\u1eadt t\u1ef1 \u0111\u1ed9ng<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00e1c ph\u01b0\u01a1ng ph\u00e1p nh\u01b0 k\u00e9o chu\u1ed9t hay d\u00f9ng c\u00f4ng th\u1ee9c c\u1ed9ng th\u1ee7 c\u00f4ng (v\u00ed d\u1ee5: \u00f4 tr\u00ean c\u1ed9ng m\u1ed9t) kh\u00f4ng t\u1ef1 \u0111i\u1ec1u ch\u1ec9nh l\u1ea1i th\u1ee9 t\u1ef1 khi b\u1ea1n th\u00eam, x\u00f3a ho\u1eb7c l\u1ecdc h\u00e0ng. N\u1ebfu b\u1ea1n c\u1ea7n s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng l\u00e0m m\u1edbi khi l\u1ecdc, n\u00ean d\u00f9ng h\u00e0m SUBTOTAL k\u1ebft h\u1ee3p v\u1edbi IF.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u1ea9n tr\u1ecdng khi sao ch\u00e9p c\u00f4ng th\u1ee9c<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c (nh\u01b0 ROW ho\u1eb7c SEQUENCE), h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng b\u1ea1n \u0111\u00e3 kh\u00f3a \u00f4 \u0111\u1ea7u ti\u00ean \u0111\u00fang c\u00e1ch n\u1ebfu c\u1ea7n c\u1ed1 \u0111\u1ecbnh v\u00f9ng d\u1eef li\u1ec7u. D\u1ea5u \u0111\u00f4 la ($) trong Excel r\u1ea5t quan tr\u1ecdng \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o c\u00f4ng th\u1ee9c ch\u1ea1y \u0111\u00fang khi k\u00e9o xu\u1ed1ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455439 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-19.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u1ea1n ch\u1ebf thao t\u00e1c th\u1ee7 c\u00f4ng v\u1edbi b\u1ea3ng l\u1edbn<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu danh s\u00e1ch d\u1eef li\u1ec7u c\u00f3 h\u00e0ng tr\u0103m d\u00f2ng, vi\u1ec7c k\u00e9o chu\u1ed9t \u0111\u1ec3 \u0111i\u1ec1n s\u1ed1 s\u1ebd g\u00e2y t\u1ed1n th\u1eddi gian v\u00e0 d\u1ec5 sai s\u00f3t. Khi \u0111\u00f3, b\u1ea1n n\u00ean \u01b0u ti\u00ean c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng c\u00e1c h\u00e0m t\u1ef1 \u0111\u1ed9ng nh\u01b0 SEQUENCE ho\u1eb7c Auto Fill Series.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Tr\u00e1nh ch\u00e8n s\u1ed1 th\u1ee9 t\u1ef1 tr\u1ef1c ti\u1ebfp v\u00e0o b\u1ea3ng c\u00f3 c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">V\u1edbi nh\u1eefng b\u1ea3ng \u0111ang t\u00ednh to\u00e1n b\u1eb1ng nhi\u1ec1u h\u00e0m l\u1ed3ng nhau, b\u1ea1n n\u00ean t\u1ea1o m\u1ed9t c\u1ed9t ri\u00eang \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1, tr\u00e1nh \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c c\u00f4ng th\u1ee9c ch\u00ednh. \u0110\u00e2y l\u00e0 \u0111i\u1ec1u c\u1ea7n ch\u00fa \u00fd k\u1ef9 khi thao t\u00e1c v\u1edbi b\u1ea3ng Excel.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455440 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-20.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">\u0110\u1eebng qu\u00ean ki\u1ec3m tra khi in ho\u1eb7c xu\u1ea5t file<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">S\u1ed1 th\u1ee9 t\u1ef1 kh\u00f4ng ch\u1ec9 gi\u00fap qu\u1ea3n l\u00fd n\u1ed9i dung khi thao t\u00e1c tr\u00ean m\u00e1y t\u00ednh m\u00e0 c\u00f2n quan tr\u1ecdng khi in \u1ea5n ho\u1eb7c chia s\u1ebb b\u00e1o c\u00e1o. B\u1ea1n n\u00ean ki\u1ec3m tra k\u1ef9 xem s\u1ed1 th\u1ee9 t\u1ef1 hi\u1ec3n th\u1ecb c\u00f3 kh\u1edbp v\u00e0 \u0111\u1ea7y \u0111\u1ee7 kh\u00f4ng tr\u01b0\u1edbc khi g\u1eedi \u0111i.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">N\u00ean ki\u1ec3m tra v\u00f9ng \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c khi k\u00e9o xu\u1ed1ng<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Trong c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel, b\u1ea1n r\u1ea5t d\u1ec5 m\u1eafc l\u1ed7i n\u1ebfu b\u1ea1n k\u00e9o c\u00f4ng th\u1ee9c qu\u00e1 xa ho\u1eb7c kh\u00f4ng \u0111\u1ebfn h\u1ebft d\u00f2ng c\u00f3 d\u1eef li\u1ec7u. \u0110i\u1ec1u n\u00e0y d\u1eabn \u0111\u1ebfn s\u1ed1 th\u1ee9 t\u1ef1 thi\u1ebfu ho\u1eb7c d\u01b0 v\u00e0 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a b\u1ea3ng t\u00ednh, nh\u1ea5t l\u00e0 khi in ho\u1eb7c g\u1eedi b\u00e1o c\u00e1o.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-455441 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-21.jpg\" alt=\"cach-danh-so-thu-tu-trong-excel-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">N\u00ean s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n n\u1ebfu kh\u00f4ng c\u1ea7n l\u1ecdc d\u1eef li\u1ec7u<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng c\u1ea7n \u0111\u1ebfn h\u00e0m IF ho\u1eb7c SUBTOTAL. N\u1ebfu b\u1ea3ng c\u1ee7a b\u1ea1n kh\u00f4ng c\u1ea7n l\u1ecdc th\u00ec ch\u1ec9 c\u1ea7n d\u00f9ng h\u00e0m ROW ho\u1eb7c ph\u00e9p c\u1ed9ng th\u00f4ng th\u01b0\u1eddng l\u00e0 \u0111\u1ee7 v\u00ec n\u00f3 v\u1eeba nhanh v\u1eeba nh\u1eb9.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel t\u01b0\u1edfng \u0111\u01a1n gi\u1ea3n nh\u01b0ng n\u1ebfu bi\u1ebft c\u00e1ch t\u1ed1i \u01b0u, b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian cho c\u00e1c thao t\u00e1c x\u1eed l\u00fd d\u1eef li\u1ec7u. V\u1edbi 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 nhanh g\u1ecdn \u0111\u01b0\u1ee3c chia s\u1ebb trong b\u00e0i vi\u1ebft, hy v\u1ecdng b\u1ea1n \u0111\u00e3 t\u00ecm ra ph\u01b0\u01a1ng ph\u00e1p ph\u00f9 h\u1ee3p nh\u1ea5t v\u1edbi nhu c\u1ea7u c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh. \u0110\u1eebng qu\u00ean l\u01b0u l\u1ea1i \u0111\u1ec3 s\u1eed d\u1ee5ng m\u1ed7i khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh nh\u00e9.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/span><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-if\/\">T\u1ea5t t\u1ea7n t\u1eadt v\u1ec1 h\u00e0m IF trong Excel: C\u00f4ng th\u1ee9c, c\u00e1ch l\u00e0m, v\u00ed d\u1ee5<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-vlookup\/\">H\u00e0m VLOOKUP trong Excel l\u00e0 g\u00ec? C\u00fa ph\u00e1p k\u00e8m v\u00ed d\u1ee5 chi ti\u1ebft<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n \u0111ang loay hoay v\u1edbi c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel v\u1edbi h\u00e0ng tr\u0103m d\u00f2ng? \u0110\u1eebng lo! B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 chu\u1ea9n trong Excel c\u1ef1c k\u1ef3 nhanh g\u1ecdn t\u1eeb thao t\u00e1c th\u1ee7 c\u00f4ng, s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Fill Series, \u0111\u1ebfn \u1ee9ng d\u1ee5ng h\u00e0m th\u00f4ng minh. [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":455442,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-455419","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft<\/title>\n<meta name=\"description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh g\u1ecdn, d\u1ec5 \u00e1p d\u1ee5ng t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh g\u1ecdn, d\u1ec5 \u00e1p d\u1ee5ng t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2025-05-08T14:01:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\"},\"headline\":\"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft\",\"datePublished\":\"2025-05-08T14:01:38+00:00\",\"dateModified\":\"2025-05-08T14:01:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\"},\"wordCount\":3052,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\",\"name\":\"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg\",\"datePublished\":\"2025-05-08T14:01:38+00:00\",\"dateModified\":\"2025-05-08T14:01:38+00:00\",\"description\":\"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh g\u1ecdn, d\u1ec5 \u00e1p d\u1ee5ng t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"cach-danh-so-thu-tu-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh g\u1ecdn, d\u1ec5 \u00e1p d\u1ee5ng t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/","og_locale":"vi_VN","og_type":"article","og_title":"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft","og_description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh g\u1ecdn, d\u1ec5 \u00e1p d\u1ee5ng t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2025-05-08T14:01:38+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"16 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4"},"headline":"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft","datePublished":"2025-05-08T14:01:38+00:00","dateModified":"2025-05-08T14:01:38+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/"},"wordCount":3052,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/","name":"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg","datePublished":"2025-05-08T14:01:38+00:00","dateModified":"2025-05-08T14:01:38+00:00","description":"B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p 5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nhanh g\u1ecdn, d\u1ec5 \u00e1p d\u1ee5ng t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao v\u00e0 gi\u00fap b\u1ea1n l\u00e0m ch\u1ee7 b\u1ea3ng t\u00ednh.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2025\/05\/cach-danh-so-thu-tu-trong-excel.jpg","width":1200,"height":628,"caption":"cach-danh-so-thu-tu-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"5 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u1ef1c nhanh g\u1ecdn b\u1ea1n n\u00ean bi\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/455419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=455419"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/455419\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/455442"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=455419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=455419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=455419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}