{"id":260502,"date":"2023-09-20T16:39:59","date_gmt":"2023-09-20T09:39:59","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=260502"},"modified":"2023-09-20T16:39:59","modified_gmt":"2023-09-20T09:39:59","slug":"cach-danh-so-thu-tu-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/","title":{"rendered":"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t"},"content":{"rendered":"<p><b>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\"> gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ed1i v\u1edbi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng. V\u1eady b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nh\u01b0 th\u1ebf n\u00e0o ch\u01b0a? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 bi\u1ebft th\u00eam th\u00f4ng tin chi ti\u1ebft nh\u00e9!\u00a0<\/span><\/p>\n<h2>6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel thu\u1eadn ti\u1ec7n nh\u1ea5t<\/h2>\n<p><span style=\"font-weight: 400;\">Excel l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 l\u00e0m vi\u1ec7c ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng. Khi l\u00e0m vi\u1ec7c tr\u00ean c\u00f4ng c\u1ee5 n\u00e0y, k\u1ef9 n\u0103ng s\u1eafp x\u1ebfp d\u1eef li\u1ec7u, \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng. \u0110\u1ed3ng th\u1eddi gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng t\u00ecm ki\u1ebfm v\u00e0 th\u1ec3 hi\u1ec7n s\u1ef1 chuy\u00ean nghi\u1ec7p khi l\u00e0m vi\u1ec7c. Sau \u0111\u00e2y l\u00e0 5 <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng cho c\u00e1c b\u1ea1n tham kh\u1ea3o:\u00a0<\/span><\/p>\n<h3>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng thao t\u00e1c k\u00e9o chu\u1ed9t<\/h3>\n<p><b>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\"> m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong b\u1ea3ng t\u00ednh Excel n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n h\u00e3y m\u1edf file Excel c\u1ea7n s\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 sau \u0111\u00f3 nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 cho 2 \u00f4 \u0111\u1ea7u ti\u00ean. Ti\u1ebfp theo, b\u1ea1n di chu\u1ed9t t\u1edbi 2 \u00f4 v\u1eeba \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-2-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-2-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-260692 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-2.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-2\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-2-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-2-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n c\u1ea7n \u0111\u1eb7t chu\u1ed9t \u1edf g\u00f3c cu\u1ed1i b\u00ean ph\u1ea3i \u0111\u1ec3 xu\u1ea5t hi\u1ec7n m\u1ed9t d\u1ea5u c\u1ed9ng nh\u1ecf. H\u00e3y gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o xu\u1ed1ng t\u1edbi \u00f4 c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-3-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-3-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-260693 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-3.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-3\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-3-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-3-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: \u0110\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho b\u1ea3ng t\u00ednh theo c\u00e1ch n\u00e0y, \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n nh\u1eadp s\u1ed1 0 &#8211; 1 v\u00e0o hai \u00f4 \u0111\u1ea7u. Ti\u1ebfp theo, b\u00f4i \u0111en 2 \u00f4 v\u1eeba \u0111i\u1ec1n s\u1ed1 th\u1ee9 t\u1ef1 -&gt; di chuy\u1ec3n g\u00f3c ph\u1ea3i cu\u1ed1i c\u00f9ng \u0111\u1ec3 xu\u1ea5t hi\u1ec7n d\u1ea5u c\u1ed9ng -&gt; d\u00f9ng chu\u1ed9t k\u00e9o t\u1edbi s\u1ed1 th\u1ee9 t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n. Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 cho trang Excel nhanh ch\u00f3ng, kh\u00f4ng t\u1ed1n nhi\u1ec1u th\u1eddi gian.\u00a0<\/span><\/p>\n<h3>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 Excel b\u1eb1ng Fill<\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\"> s\u1eed d\u1ee5ng Auto Fill. Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u1ea7n k\u00edch ho\u1ea1t t\u00ednh n\u0103ng n\u00e0y b\u1eb1ng c\u00e1ch: Ch\u1ecdn File -&gt; ch\u1ecdn Options -&gt; ch\u1ecdn Customize Ribbon -&gt; ch\u1ecdn All commands. B\u1ea1n h\u00e3y k\u00e9o chu\u1ed9t v\u00e0 t\u00ecm m\u1ee5c Filter series or Pattern. L\u00fac n\u00e0y, m\u00e0n h\u00ecnh m\u00e1y t\u00ednh xu\u1ea5t hi\u1ec7n b\u1ea3ng Main Tabs -&gt; ch\u1ecdn chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Add new Group. Cu\u1ed1i c\u00f9ng, b\u1ea1n ch\u1ecdn Filter Series or Pattern -&gt; ch\u1ecdn Add v\u00e0 ch\u1ecdn OK \u0111\u1ec3 ho\u00e0n t\u1ea5t thao t\u00e1c.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Sau khi k\u00edch ho\u1ea1t Auto Fill, c\u00e1ch th\u1ee9c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng c\u00e1ch n\u00e0y \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u1ea1n c\u1ea7n m\u1edf trang t\u00ednh Excel mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 sau \u0111\u00f3 nh\u1eadp s\u1ed1 th\u1ee9 t\u1ef1 \u1edf \u00f4 th\u1ee9 nh\u1ea5t. Ti\u1ebfp theo, b\u1ea1n ch\u1ecdn Fill v\u00e0 ch\u1ecdn Series. L\u01b0u \u00fd, b\u1ea1n s\u1ebd c\u00f3 b\u1ed1n ki\u1ec3u \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u00f3 l\u00e0:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Linear: S\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Growth: S\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 lu\u1ef9 ti\u1ebfn\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Date: S\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 ng\u00e0y th\u00e1ng n\u0103m\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Auto Fill: S\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-4-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-4-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-260695 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-4.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-4\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-4-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-4-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: L\u00fac n\u00e0y, h\u1ed9p tho\u1ea1i Series hi\u1ec7n ra cho b\u1ea1n l\u1ef1a ch\u1ecdn. Tu\u1ef3 v\u00e0o \u00fd mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 m\u00e0 b\u1ea1n l\u1ef1a ch\u1ecdn th\u00f4ng s\u1ed1 ph\u00f9 h\u1ee3p.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n d\u00f9ng <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel <\/b><span style=\"font-weight: 400;\">theo h\u00e0ng th\u00ec ch\u1ecdn Rows v\u00e0 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo c\u1ed9t th\u00ec ch\u1ecdn Columns.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u01b0\u1eddng h\u1ee3p mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo ki\u1ec3u t\u0103ng d\u1ea7n, b\u1ea1n h\u00e3y ch\u1ecdn ph\u1ea7n type.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u1ea1i m\u1ee5c Step value h\u00e3y nh\u1eadp s\u1ed1 b\u1eaft \u0111\u1ea7u v\u00e0 nh\u1eadp s\u1ed1 cu\u1ed1i c\u00f9ng t\u1ea1i m\u1ee5c Stop value. \u0110\u1ec3 k\u1ebft th\u00fac qu\u00e1 tr\u00ecnh \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng Fill, b\u1ea1n h\u00e3y ch\u1ecdn OK.\u00a0<\/span><\/li>\n<\/ul>\n<h3>H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c<\/h3>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh 2 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c \u0111\u1ec3 s\u1eafp x\u1ebfp stt trong Excel. T\u1ea1i b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u 4 c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c b\u01b0\u1edbc h\u01b0\u1edbng d\u1eabn chi ti\u1ebft cho c\u00e1c b\u1ea1n tham kh\u1ea3o:\u00a0<\/span><\/p>\n<h4>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 Excel b\u1eb1ng h\u00e0m ROW()<\/h4>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n s\u1ee3 khi xo\u00e1 \u00f4 trong Excel s\u1ebd l\u00e0m \u0111\u1ea3o l\u1ed9n s\u1ed1 th\u1ee9 t\u1ef1 th\u00ec c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m ROW. <\/span><b>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\"> n\u00e0y gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110\u1ea7u ti\u00ean, b\u1ea1n h\u00e3y nh\u1eadp =ROW() t\u1ea1i \u00f4 s\u1ed1 th\u1ee9 t\u1ef1 th\u1ee9 nh\u1ea5t. Ti\u1ebfp theo, b\u1ea1n h\u00e3y copy v\u00e0 paste c\u00f4ng th\u1ee9c \u0111\u00f3 v\u00e0 c\u00e1c \u00f4 ph\u00eda sau \u0111\u1ebfn khi mu\u1ed1n d\u1eebng. Cu\u1ed1i d\u00f9ng, b\u1ea1n h\u00e3y d\u00f9ng Fill Handle gi\u00fap qu\u00e1 tr\u00ecnh \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 di\u1ec5n ra nhanh ch\u00f3ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-5-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-5-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260697 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-5.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-5\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-5-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-5-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd, h\u00e0m ROW() s\u1ebd hi\u1ec3n th\u1ecb stt \u1edf h\u00e0ng m\u00e0 b\u1ea1n \u0111ang ch\u1ecdn. V\u00ec v\u1eady, b\u1ea1n c\u1ea7n tr\u1eeb \u0111i 1 \u0111\u1ec3 stt b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng th\u1ee9 hai. Ch\u1eb3ng h\u1ea1n, s\u1ed1 th\u1ee9 t\u1ef1 Excel c\u1ee7a b\u1ea1n b\u1eaft \u0111\u1ea7u t\u1eeb h\u00e0ng th\u1ee9 8 b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c =ROW() &#8211; 7.\u00a0<\/span><\/p>\n<h4>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng h\u00e0m OFFSET()<\/h4>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n c\u1ea7n nh\u1eadp c\u00f4ng th\u1ee9c = OFFSET() v\u00e0o \u00f4 mu\u1ed1n b\u1eaft \u0111\u1ea7u \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1. Ngay sau \u0111\u00f3, h\u1ed9p tho\u1ea1i Function Arguments hi\u1ec7n ra v\u1edbi c\u00e1c tu\u1ef3 ch\u1ecdn:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Reference: L\u00e0 v\u00f9ng tham chi\u1ebfu d\u00f9ng \u0111\u1ec3 l\u00e0m c\u0103n c\u1ee9 kho\u1ea3ng c\u00e1ch.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Rows: L\u00e0 s\u1ed1 h\u00e0ng tham chi\u1ebfu t\u1edbi c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng (n\u1eb1m d\u01b0\u1edbi v\u00f9ng tham chi\u1ebfu) ho\u1eb7c c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 \u00e2m (n\u1eb1m tr\u00ean v\u00f9ng tham chi\u1ebfu).\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Cols: L\u00e0 s\u1ed1 c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 d\u01b0\u01a1ng (n\u1eb1m b\u00ean ph\u1ea3i c\u1ee7a v\u00f9ng tham chi\u1ebfu) hay s\u1ed1 \u00e2m ( n\u1eb1m b\u00ean tr\u00e1i c\u1ee7a v\u00f9ng tham chi\u1ebfu trong b\u1ea3ng t\u00ednh).\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Height: L\u00e0 chi\u1ec1u cao hay s\u1ed1 h\u00e0ng m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu t\u1edbi.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Width: L\u00e0 \u0111\u1ed9 r\u1ed9ng hay s\u1ed1 c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu t\u1edbi.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-6-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-6-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260698 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-6.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-6\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-6-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-6-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ti\u1ebfp theo, b\u1ea1n c\u1ea7n \u0111i\u1ec1n s\u1ed1 \u0111\u1ed1i v\u00e0o h\u00e0m = OFFSET(). V\u00ed d\u1ee5 nh\u01b0 c\u00f4ng th\u1ee9c = OFFSET (A2,-1,0)+1 trong \u0111\u00f3, A2 l\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4 tham gia chi\u1ebfu. L\u00fac n\u00e0y, b\u1ea1n c\u1ea7n nh\u1ea5n Enter \u0111\u1ec3 stt \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-7-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-7-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260699 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-7.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-7\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-7-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-7-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Sau khi s\u1ed1 th\u1ee9 t\u1ef1 \u0111\u1ea7u ti\u00ean xu\u1ea5t hi\u1ec7n, \u1edf ph\u00eda g\u00f3c cu\u1ed1i b\u00ean ph\u1ea3i c\u00f3 d\u1ea5u ch\u1ea5m xanh. B\u1ea1n h\u00e3y ch\u1ecdn v\u00e0o \u0111\u00f3 v\u00e0 k\u00e9o chu\u1ed9t t\u1edbi \u00f4 cu\u1ed1i m\u00e0 b\u1ea1n mu\u1ed1n <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-8-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-8-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260700 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-8.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-8\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-8-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-8-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>XEM NGAY: <a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-rank-trong-excel\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rank trong Excel<\/a><\/strong><\/p>\n<h4>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 Excel b\u1eb1ng h\u00e0m COUNTA()<\/h4>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng \u0111\u00f3 l\u00e0 d\u00f9ng h\u00e0m COUNTA(). \u0110\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo c\u00e1ch n\u00e0y, tr\u01b0\u1edbc ti\u00ean b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh gi\u1edbi h\u1ea1n v\u00f9ng d\u1eef li\u1ec7u sau \u0111\u00f3 ti\u1ebfn h\u00e0nh nh\u1eadp =COUNTA().<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-9-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-9-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260701 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-9.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-9\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-9-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-9-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, b\u1ea1n \u0111ang mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb D2 \u0111\u1ebfn E7 b\u1ea1n s\u1ebd nh\u1eadp h\u00e0m = COUNTA(D2:E7) sau \u0111\u00f3 nh\u1ea5n Enter. Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong b\u1ea3ng Excel thu\u1eadn ti\u1ec7n, nhanh ch\u00f3ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-10-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-10-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260702 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-10.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-10\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-10-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-10-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h4>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel b\u1eb1ng h\u00e0m SUBTOTAL()<\/h4>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1, t\u00ednh trung b\u00ecnh, ph\u00e9p c\u1ed9ng th\u00ec s\u1eed d\u1ee5ng h\u00e0m SUBTOTAL() l\u00e0 l\u1ef1a ch\u1ecdn ho\u00e0n h\u1ea3o. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m \u0111\u1ebfm s\u1ed1 th\u1ee9 t\u1ef1 n\u00e0y nh\u01b0 sau: = SUBTOTAL(Function_num, ref1, [ref2]\u2026)<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Function_num l\u00e0 thu\u1eadt to\u00e1n, \u0111\u1ed1i s\u1ed1 c\u1ea7n c\u00f3.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ref1 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 v\u00f9ng tham chi\u1ebfu s\u1ed1 1 v\u00e0 \u0111\u1ed1i s\u1ed1 c\u1ea7n c\u00f3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ref2 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 v\u00f9ng tham chi\u1ebfu s\u1ed1 2 v\u00e0 \u0111\u1ed1i s\u1ed1 kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i c\u00f3.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-11-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-11-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260703 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-11.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-11\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-11-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-11-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 gi\u00fap m\u1ecdi ng\u01b0\u1eddi hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y, ch\u00fang t\u00f4i s\u1ebd l\u1ea5y v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 nh\u01b0 sau: \u00d4 b\u1eaft \u0111\u1ea7u \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 l\u00e0 B2, khi \u0111\u1ebfm c\u00e1c d\u00f2ng ti\u1ebfp theo b\u1ea1n c\u1ea7n \u0111\u1ebfm c\u1ea3 nh\u1eefng \u00f4 tr\u01b0\u1edbc \u0111\u00f3. T\u1ea1i d\u00f2ng hai = COUNT (B2:B2), d\u00f2ng 3 = COUNT (B2:B3),&#8230; Nh\u01b0 v\u1eady, c\u00f4ng th\u1ee9c \u0111\u1ebfm s\u1ed1 th\u1ee9 t\u1ef1 t\u1ea1i \u00f4 A2 = SUBTOTAL(3, $B$2:B2) sau \u0111\u00f3 b\u1ea1n k\u00e9o d\u1ea5u ch\u1ea5m xanh xu\u1ed1ng t\u1edbi \u00f4 cu\u1ed1i c\u00f9ng.\u00a0<\/span><\/p>\n<h2>M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n \u0111\u00e1nh stt trong Excel c\u1ea7n nh\u1edb<\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\"> m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o. Tuy nhi\u00ean, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u c\u1ee5 th\u1ec3 nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng, b\u1ea1n c\u1ea7n ki\u1ec3m tra t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u. B\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u kh\u00f4ng c\u00f3 l\u1ed7i ho\u1eb7c gi\u00e1 tr\u1ecb tr\u1ed1ng th\u00ec vi\u1ec7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 m\u1edbi chu\u1ea9n x\u00e1c.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p \u0111\u1eb7c bi\u1ec7t, b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua m\u1ed9t s\u1ed1 d\u00f2ng ho\u1eb7c \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 theo \u0111i\u1ec1u ki\u1ec7n. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 linh ho\u1ea1t \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c t\u00ecnh hu\u1ed1ng \u0111\u1eb7c bi\u1ec7t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 g\u1eb7p s\u1ef1 c\u1ed1, b\u1ea1n c\u1ea7n ki\u1ec3m tra th\u1eadt k\u1ef9 c\u00f4ng th\u1ee9c, d\u1eef li\u1ec7u \u0111\u1ec3 t\u00ecm ra nguy\u00ean nh\u00e2n. T\u1eeb \u0111\u00f3, b\u1ea1n t\u00ecm ra \u0111\u01b0\u1ee3c c\u00e1ch kh\u1eafc ph\u1ee5c cho s\u1ef1 c\u1ed1 \u0111\u00f3.\u00a0<\/span><\/li>\n<\/ul>\n<h2>M\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p khi \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/h2>\n<p><span style=\"font-weight: 400;\">T\u1edbi \u0111\u00e2y, ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch \u0111\u00e1nh stt trong Excel. Tuy nhi\u00ean, nhi\u1ec1u ng\u01b0\u1eddi v\u1eabn b\u0103n kho\u0103n, th\u1eafc m\u1eafc v\u1ec1 v\u1ea5n \u0111\u1ec1 n\u00e0y. Sau \u0111\u00e2y, ch\u00fang t\u00f4i s\u1ebd gi\u1ea3i \u0111\u00e1p m\u1ed9t s\u1ed1 c\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p khi \u0111\u00e1nh stt trong Excel cho c\u00e1c b\u1ea1n tham kh\u1ea3o:\u00a0<\/span><\/p>\n<h3>\u0110\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 h\u00e0ng ngang cho Excel nh\u01b0 th\u1ebf n\u00e0o?<\/h3>\n<p><span style=\"font-weight: 400;\">Trong ph\u1ea7n tr\u00ean, ch\u00fang t\u00f4i \u0111\u00e3 chia s\u1ebb <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\"> cho h\u00e0ng ngang m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o. B\u1ea1n h\u00e3y l\u1ef1a ch\u1ecdn c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 ph\u00f9 h\u1ee3p, l\u1ef1a ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a h\u00e0ng ngang -&gt; k\u00e9o chu\u1ed9t t\u1edbi \u00f4 s\u1ed1 th\u1ee9 t\u1ef1 cu\u1ed1i c\u00f9ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-12-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-12-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260704 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-12.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-12\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-12-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-12-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb m\u1ed9t gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh nh\u01b0 th\u1ebf n\u00e0o?<\/h3>\n<p><span style=\"font-weight: 400;\">C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh trong Excel b\u1eb1ng c\u00f4ng th\u1ee9c. Ch\u1eb3ng h\u1ea1n nh\u01b0 =A2-$A$2+1, trong \u0111\u00f3 A2 l\u00e0 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1; c\u00f2n $A$2 l\u00e0 gi\u00e1 tr\u1ecb c\u1ed1 \u0111\u1ecbnh.\u00a0<\/span><\/p>\n<h3>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u00f3 \u0111i\u1ec1u ki\u1ec7n nh\u01b0 th\u1ebf n\u00e0o?<\/h3>\n<p><span style=\"font-weight: 400;\">Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9a h\u00e0m IF ho\u1eb7c h\u00e0m COUNTIF. Ch\u1eb3ng h\u1ea1n nh\u01b0 d\u00f9ng c\u00f4ng th\u1ee9c =IF(B2=&#8221;\u0110i\u1ec1u ki\u1ec7n&#8221;, C1+1, C1), trong \u0111\u00f3 B2 l\u00e0 \u00f4 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n c\u00f2n C1 ch\u1ee9a stt tr\u01b0\u1edbc.<\/span><\/p>\n<h3>Kh\u00f4ng \u0111\u00e1nh stt t\u1ef1 \u0111\u1ed9ng trong Excel do \u0111\u00e2u?<\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu kh\u00f4ng k\u00e9o \u0111\u01b0\u1ee3c s\u1ed1 th\u1ee9 t\u1ef1 trong Excel c\u00f3 th\u1ec3 do t\u00ednh n\u0103ng n\u00e0y \u0111ang b\u1ecb l\u1ed7i. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n h\u00e3y ch\u1ecdn m\u1ee5c File -&gt; ch\u1ecdn Option -&gt; ch\u1ecdn Advanced v\u00e0 t\u00edch \u00f4 Enable fill handle and cell drag-and-drop. Sau c\u00f9ng, b\u1ea1n ch\u1ecdn OK \u0111\u1ec3 ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh. L\u00fac n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 b\u1eb1ng c\u00e1ch k\u00e9o chu\u1ed9t nh\u01b0 b\u00ecnh th\u01b0\u1eddng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-13-300x200.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-13-768x512.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-260705 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-13.jpg\" alt=\"cach-danh-so-thu-tu-trong-Excel-13\" width=\"800\" height=\"533\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-13-300x200.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel-13-768x512.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3>Kh\u00f4ng d\u00f9ng \u0111\u01b0\u1ee3c t\u00ednh n\u0103ng Fill Series do \u0111\u00e2u?<\/h3>\n<p><span style=\"font-weight: 400;\">C\u00f3 r\u1ea5t nhi\u1ec1u ng\u01b0\u1eddi g\u1eb7p ph\u1ea3i l\u1ed7i kh\u00f4ng d\u00f9ng \u0111\u01b0\u1ee3c t\u00ednh n\u0103ng Fill Series \u0111\u1ec3 \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1. L\u1ed7i n\u00e0y c\u00f3 th\u1ec3 xu\u1ea5t ph\u00e1t t\u1eeb nguy\u00ean nh\u00e2n ch\u01b0a k\u00edch ho\u1ea1t t\u00ednh n\u0103ng n\u00e0y. C\u00e1ch k\u00edch ho\u1ea1t t\u00ednh n\u0103ng Fill Series \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00fang t\u00f4i gi\u1edbi thi\u1ec7u ph\u00eda tr\u00ean, b\u1ea1n h\u00e3y \u00e1p d\u1ee5ng \u0111\u1ec3 s\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 Excel nhanh ch\u00f3ng nh\u00e9!\u00a0<\/span><\/p>\n<h2>T\u1ea1m K\u1ebft<\/h2>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady, ch\u00fang t\u00f4i \u0111\u00e3 chia s\u1ebb <\/span><b>c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel<\/b><span style=\"font-weight: 400;\"> cho c\u00e1c b\u1ea1n tham kh\u1ea3o. \u0110\u00e2y l\u00e0 m\u1ed9t k\u1ef9 n\u0103ng quan tr\u1ecdng, ph\u1ee5c v\u1ee5 trong c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n. B\u1ea1n h\u00e3y l\u01b0u l\u1ea1i nh\u1eefng tip tr\u00ean \u0111\u1ec3 bi\u1ebft c\u00e1ch \u0111\u00e1nh th\u1ee9 t\u1ef1 trong b\u1ea3ng Excel nhanh ch\u00f3ng. H\u00e3y theo d\u00f5i k\u00eanh <\/span><b>Ho\u00e0ng H\u00e0 Mobile<\/b><span style=\"font-weight: 400;\"> \u0111\u1ec3 c\u00f3 th\u00eam nhi\u1ec1u tin t\u1ee9c th\u00fa v\u1ecb v\u1ec1 c\u00f4ng ngh\u1ec7 v\u00e0 \u0111\u1eddi s\u1ed1ng nh\u00e9! \u00a0<\/span><\/p>\n<p><strong>XEM TH\u00caM:<\/strong> <strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\">C\u00e1c th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n nh\u1ea5t b\u1ea1n c\u1ea7n n\u1eafm<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110\u00e2y c\u0169ng l\u00e0 m\u1ed9t trong nh\u1eefng k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft \u0111\u1ed1i v\u1edbi nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng. V\u1eady b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eafp x\u1ebfp s\u1ed1 th\u1ee9 t\u1ef1 trong Excel nh\u01b0 th\u1ebf n\u00e0o ch\u01b0a? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi [&hellip;]<\/p>\n","protected":false},"author":73,"featured_media":260691,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-260502","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"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>Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"B\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!\" \/>\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\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"B\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/\" \/>\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:published_time\" content=\"2023-09-20T09:39:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/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=\"H\u1ed3ng Th\u01a1\" \/>\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=\"H\u1ed3ng Th\u01a1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 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\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/\"},\"author\":{\"name\":\"H\u1ed3ng Th\u01a1\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2\"},\"headline\":\"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t\",\"datePublished\":\"2023-09-20T09:39:59+00:00\",\"dateModified\":\"2023-09-20T09:39:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/\"},\"wordCount\":2838,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/\",\"name\":\"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel.jpg\",\"datePublished\":\"2023-09-20T09:39:59+00:00\",\"dateModified\":\"2023-09-20T09:39:59+00:00\",\"description\":\"B\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/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\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t\"}]},{\"@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\/6db3b2e6d8fb7f2e308c4625aeaa7dc2\",\"name\":\"H\u1ed3ng Th\u01a1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g\",\"caption\":\"H\u1ed3ng Th\u01a1\"},\"description\":\"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t","description":"B\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!","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\/","og_locale":"vi_VN","og_type":"article","og_title":"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t","og_description":"B\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-09-20T09:39:59+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel.jpg","type":"image\/jpeg"}],"author":"H\u1ed3ng Th\u01a1","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"H\u1ed3ng Th\u01a1","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/"},"author":{"name":"H\u1ed3ng Th\u01a1","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/6db3b2e6d8fb7f2e308c4625aeaa7dc2"},"headline":"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t","datePublished":"2023-09-20T09:39:59+00:00","dateModified":"2023-09-20T09:39:59+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/"},"wordCount":2838,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/","name":"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel.jpg","datePublished":"2023-09-20T09:39:59+00:00","dateModified":"2023-09-20T09:39:59+00:00","description":"B\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 th\u1ef1c hi\u1ec7n? H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-danh-so-thu-tu-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/cach-danh-so-thu-tu-trong-Excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/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\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"Top 6 c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong Excel d\u00f9ng nhi\u1ec1u nh\u1ea5t"}]},{"@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\/6db3b2e6d8fb7f2e308c4625aeaa7dc2","name":"H\u1ed3ng Th\u01a1","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b74c49ea2aa5069714f9b552602efd03?s=96&d=mm&r=g","caption":"H\u1ed3ng Th\u01a1"},"description":"M\u00ecnh l\u00e0 Th\u01a1 - c\u00f4 g\u00e1i \u0111am m\u00ea vi\u1ebft l\u00e1ch, th\u00edch tr\u1ea3i nghi\u1ec7m nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 m\u1edbi!","url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/hong-tho\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/260502","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\/73"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=260502"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/260502\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/260691"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=260502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=260502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=260502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}