{"id":44564,"date":"2022-04-12T18:51:33","date_gmt":"2022-04-12T11:51:33","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=44564"},"modified":"2022-05-09T11:31:08","modified_gmt":"2022-05-09T04:31:08","slug":"huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515737\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb5e04c5.png\" alt=\"\" width=\"800\" height=\"450\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Gop_o_trong_Excel_cung_mot_cot\"><\/span><span id=\"Gop_o_trong_Excel_cung_mot_cot\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">G\u1ed9p \u00f4 trong Excel c\u00f9ng m\u1ed9t c\u1ed9t<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> <strong>Nh\u1ea5n ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 tr\u00ean c\u00f9ng m\u1ed9t c\u1ed9t<\/strong> m\u00e0 b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n g\u1ed9p &gt; Ti\u1ebfp theo, b\u1ea1n th\u1ef1c hi\u1ec7n \u0111i\u1ec1u ch\u1ec9nh cho \u0111\u1ebfn khi c\u00e1c th\u00f4ng tin v\u1eeba \u0111\u1ee7 t\u1ea5t c\u1ea3 c\u00e1c \u00f4.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515707\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb7c1a9d.jpeg\" alt=\"\" width=\"862\" height=\"519\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Tr\u00ean thanh menu, b\u1ea1n <strong>ch\u1ecdn v\u00e0o m\u1ee5c Home<\/strong> &gt; Ch\u1ecdn ti\u1ebfp v\u00e0o m\u1ee5c<strong> Editing<\/strong> &gt; \u1ea4n v\u00e0o m\u1ee5c<strong> Fill.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515710\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb860cbf.jpeg\" alt=\"\" width=\"1563\" height=\"669\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5p ch\u1ecdn ti\u1ebfp v\u00e0o \u00f4 <strong>Justify.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515708\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb9bf0e5.jpeg\" alt=\"\" width=\"1561\" height=\"673\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> L\u00fac n\u00e0y, <strong>c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c g\u1ed9p l\u1ea1i v\u1edbi nhau<\/strong> v\u00e0 <strong>\u0111i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng<\/strong> ch\u1ee9a n\u1ed9i dung c\u1ee7a c\u00e1c \u00f4 sao cho ph\u00f9 h\u1ee3p.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515709\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ebbe323d.jpeg\" alt=\"\" width=\"895\" height=\"566\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_chuc_nang_CONCATENATE_de_gop_o_trong_Excel\"><\/span><span id=\"Su_dung_chuc_nang_CONCATENATE_de_gop_o_trong_Excel\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng CONCATENATE \u0111\u1ec3 g\u1ed9p \u00f4 trong Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u1ede c\u00e1c \u00f4 mu\u1ed1n g\u1ed9p, b\u1ea1n ti\u1ebfn h\u00e0nh x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a c\u00e1c \u00f4 n\u00e0y.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515712\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ebca5631.jpeg\" alt=\"\" width=\"893\" height=\"565\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Trong \u00f4 m\u1edbi, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c <strong>=CONCATENATE(Xn,\u201d, \u201c,Yn)<\/strong> ho\u1eb7c <strong>=Xn&amp;\u201d, \u201c&amp;Yn.<\/strong><\/p>\n<p><strong>L\u01b0u \u00fd: D\u1ea5u \u201c,\u201d<\/strong> l\u00e0 k\u00fd hi\u1ec7u s\u1eed d\u1ee5ng \u0111\u1ec3 ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c \u00f4 v\u1edbi nhau.<\/p>\n<p>Ch\u1eb3ng h\u1ea1n, b\u1ea1n mu\u1ed1n cho ra th\u00f4ng tin v\u1ec1 <strong>Xn : Xy (M\u1ee9t : 80000)<\/strong> th\u00ec b\u1ea1n s\u1ebd nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau: <strong>=CONCATENATE(B4,\u201d,\u201c,C4).<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515715\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ebd98854.jpeg\" alt=\"\" width=\"893\" height=\"565\" \/><\/p>\n<p>Khi th\u1ef1c hi\u1ec7n c\u00f4ng th\u1ee9c nh\u01b0 tr\u00ean th\u00ec b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515714\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ebe8cb50.jpeg\" alt=\"\" width=\"898\" height=\"568\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_gop_o_trong_Excel_bang_chuc_nang_Merge_Center\"><\/span><span id=\"Cach_gop_o_trong_Excel_bang_chuc_nang_Merge_Center\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel b\u1eb1ng ch\u1ee9c n\u0103ng Merge &amp; Center<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1: Nh\u1ea5n ch\u1ecdn nh\u1eefng \u00f4 \u0111\u1ee9ng k\u1ebf nhau<\/strong> m\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515716\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ebfb3f37.jpeg\" alt=\"\" width=\"895\" height=\"563\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea5m v\u00e0o m\u1ee5c Home v\u00e0 <strong>\u1ea5n ch\u1ecdn Merge &amp;<\/strong> <strong>Center.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515717\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec0ccf2a.jpeg\" alt=\"\" width=\"1152\" height=\"568\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Trong m\u1ee5c Merge &amp; Center g\u1ed3m c\u00e1c t\u00f9y ch\u1ecdn sau:<\/p>\n<ul>\n<li><strong>Merge &amp; Center<\/strong> : Khi ch\u1ecdn t\u00f9y ch\u1ecdn n\u00e0y th\u00ec Excel s\u1ebd th\u1ef1c hi\u1ec7n g\u1ed9p nhi\u1ec1u \u00f4 th\u00e0nh m\u1ed9t \u00f4 duy nh\u1ea5t v\u00e0 n\u1eb1m \u1edf v\u1ecb tr\u00ed ch\u00ednh gi\u1eefa c\u1ee7a b\u1ea3ng.<\/li>\n<li><strong>Merge Across:<\/strong> Th\u1ef1c hi\u1ec7n g\u1ed9p nh\u1eefng \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn th\u00e0nh t\u1eebng \u00f4 ri\u00eang bi\u1ec7t.<\/li>\n<li><strong>Merge Cells:<\/strong> T\u00f9y ch\u1ecdn n\u00e0y s\u1ebd thao t\u00e1c g\u1ed9p c\u00e1c \u00f4 m\u00e0 b\u1ea1n ch\u1ecdn th\u00e0nh m\u1ed9t \u00f4 duy nh\u1ea5t nh\u01b0ng kh\u00f4ng n\u1eb1m \u1edf v\u1ecb tr\u00ed gi\u1eefa c\u1ee7a \u00f4.<\/li>\n<li><strong> Unmerge Cells:<\/strong> Th\u1ef1c hi\u1ec7n h\u1ee7y g\u1ed9p \u00f4 \u0111\u00e3 th\u1ef1c hi\u1ec7n g\u1ed9p.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515718\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec2d7b72.jpeg\" alt=\"\" width=\"1157\" height=\"565\" \/><\/p>\n<p>B\u1ea1n ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn tr\u00ean l\u00e0 \u0111\u01b0\u1ee3c, k\u1ebft qu\u1ea3 sau khi g\u1ed9p c\u00e1c \u00f4 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515719\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec498d11.jpeg\" alt=\"\" width=\"1156\" height=\"566\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_gop_o_trong_Excel_dung_phim_tat\"><\/span><span id=\"Cach_gop_o_trong_Excel_dung_phim_tat\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel d\u00f9ng ph\u00edm t\u1eaft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> L\u1ef1a ch\u1ecdn c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515707\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb7c1a9d.jpeg\" alt=\"\" width=\"862\" height=\"519\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Tr\u00ean b\u00e0n ph\u00edm, b\u1ea1n <strong>nh\u1ea5p t\u1ed5 h\u1ee3p ph\u00edm Alt<\/strong> \u0111\u1ec3 thao t\u00e1c \u0111i\u1ec1u khi\u1ec3n thanh c\u00f4ng c\u1ee5 c\u1ee7a Excel &gt; <strong>Nh\u1ea5n gi\u1eef cho \u0111\u1ebfn l\u00fac xu\u1ea5t hi\u1ec7n m\u1ed9t d\u00e3y ph\u00edm t\u1eaft.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515721\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec602169.jpeg\" alt=\"\" width=\"800\" height=\"563\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> <strong>\u1ea4n ch\u1ecdn ph\u00edm H<\/strong> \u0111\u1ec3 \u0111i\u1ec1u khi\u1ec3n <strong>tab Home.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515722\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec732c92.jpeg\" alt=\"\" width=\"802\" height=\"564\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Ch\u1ecdn ti\u1ebfp<strong> ph\u00edm M<\/strong> \u0111\u1ec3 ch\u1ecdn m\u1ee5c<strong> Merge &amp; Center.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515725\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec81d659.jpeg\" alt=\"\" width=\"1175\" height=\"564\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Cu\u1ed1i c\u00f9ng, b\u1ea1n \u1ea5n c\u00e1c ph\u00edm sau \u0111\u00e2y \u0111\u1ec3 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn g\u1ed9p c\u1ee7a m\u1ee5c Merger &amp; Center.<\/p>\n<ul>\n<li><strong>B\u1ea5m v\u00e0o ph\u00edm C<\/strong> \u0111\u1ec3 ch\u1ecdn v\u00e0o \u00f4 <strong>Merge and Center<\/strong> \u0111\u1ec3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn g\u1ed9p th\u00e0nh m\u1ed9t h\u00e0ng v\u00e0 \u1edf v\u1ecb tr\u00ed ch\u00ednh gi\u1eefa.<\/li>\n<li><strong>Nh\u1ea5n ph\u00edm A<\/strong> \u0111\u1ec3 ch\u1ecdn t\u00f9y ch\u1ecdn<strong> Merge Across:<\/strong> T\u00f9y ch\u1ecdn n\u00e0y s\u1ebd g\u1ed9p c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn th\u00e0nh t\u1eebng h\u00e0ng ri\u00eang bi\u1ec7t.<\/li>\n<li><strong>Nh\u1ea5n ph\u00edm M<\/strong> ch\u1ecdn v\u00e0o m\u1ee5c<strong> Merge Cells<\/strong> \u0111\u1ec3 nh\u1eefng \u00f4 n\u00e0y \u0111\u01b0\u1ee3c g\u1ed9p v\u1edbi nhau nh\u01b0ng kh\u00f4ng c\u0103n l\u1ec1 \u1edf gi\u1eefa.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515724\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec90414d.jpeg\" alt=\"\" width=\"1174\" height=\"561\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 sau khi g\u1ed9p b\u1eb1ng ph\u00edm t\u1eaft nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515723\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ec9d8af5.jpeg\" alt=\"\" width=\"1177\" height=\"566\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_gop_o_trong_Excel_khong_lam_mat_du_lieu\"><\/span><span id=\"Cach_gop_o_trong_Excel_khong_lam_mat_du_lieu\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel kh\u00f4ng l\u00e0m m\u1ea5t d\u1eef li\u1ec7u<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 g\u1ed9p \u00f4 tr\u00ean Excel nh\u01b0ng d\u1eef li\u1ec7u v\u1eabn c\u00f2n nguy\u00ean th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c to\u00e1n t\u1eed &amp;. V\u1edbi c\u00f4ng th\u1ee9c to\u00e1n t\u1eed &amp; n\u00f3 s\u1ebd gi\u00fap cho v\u0103n b\u1ea3n c\u1ee7a c\u00e1c \u00f4 \u1edf th\u00e0nh m\u1ed9t \u00f4 h\u1ee3p nh\u1ea5t.<\/p>\n<p>Nh\u1eadp c\u00f4ng th\u1ee9c to\u00e1n t\u1eed v\u00e0o v\u1ecb tr\u00ed \u00f4 c\u1ea7n k\u1ebft n\u1ed1i sau: <strong>=A2&amp;\u201d \u201c&amp;B2<\/strong>. A2, B2 l\u00e0 2 \u00f4 m\u00e0 b\u1ea1n s\u1eed d\u1ee5ng \u0111\u1ec3 gh\u00e9p d\u1eef li\u1ec7u.<br \/>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n gi\u1eefa \u00f4 A2 v\u00e0 B2 c\u00f3 kho\u1ea3ng c\u00e1ch th\u00ec gi\u1eefa \u00f4 A2 v\u00e0 B2 trong d\u1ea5u ngo\u1eb7c k\u00e9p b\u1ea1n th\u00eam m\u1ed9t kho\u1ea3ng tr\u1ed1ng. N\u1ebfu kh\u00f4ng mu\u1ed1n th\u00eam kho\u1ea3ng tr\u1ed1ng gi\u1eefa A2 v\u00e0 B2 th\u00ec b\u1ea1n h\u00e3y \u0111\u1eb7t 2 \u00f4 t\u1ea1i v\u1ecb tr\u00ed k\u1ebf b\u00ean nhau.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> \u1ede v\u1ecb tr\u00ed c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 n\u1ed1i \u00f4 A2 v\u00e0 B2, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c to\u00e1n t\u1eed sau: <strong>=A2&amp;\u201d \u201c&amp;B2.<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515733\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ecb18712.jpeg\" alt=\"\" width=\"802\" height=\"562\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> <strong>Click v\u00e0o ph\u00edm Enter<\/strong> tr\u00ean b\u00e0n ph\u00edm v\u00e0 <strong>xem k\u1ebft qu\u1ea3.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-515734\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4ecd05e4a.jpeg\" alt=\"\" width=\"802\" height=\"566\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Luu_y_khi_thuc_hien_gop_o_trong_Excel\"><\/span><span id=\"Luu_y_khi_thuc_hien_gop_o_trong_Excel\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">L\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n g\u1ed9p \u00f4 trong Excel<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><span style=\"font-weight: 400;\">Trong l\u00fac th\u1ef1c hi\u1ec7n g\u1ed9p\u00a0 c\u00e1c \u00f4 v\u00e0 c\u1ed9t v\u1edbi nhau th\u00ec duy nh\u1ea5t \u00f4 d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i c\u1ee7a c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i, c\u00f2n c\u00e1c \u00f4 kh\u00e1c s\u1ebd b\u1ecb x\u00f3a.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">N\u1ebfu c\u00f4ng c\u1ee5<strong> Merge &amp; Center<\/strong> tr\u00ean ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh Excel chuy\u1ec3n sang m\u00e0u x\u00e1m th\u00ec c\u00f3 th\u1ec3 \u00f4 b\u1ea1n v\u1eeba ch\u1ecdn \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda r\u1ed3i. B\u1ea1n h\u00e3y th\u1eed nh\u1ea5n Enter \u0111\u1ec3 c\u00e1c \u00f4 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c g\u1ed9p l\u1ea1i v\u1edbi nhau.<\/span><\/li>\n<li>Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng Excel (\u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c), kh\u00f4ng c\u00f3 c\u00e1ch n\u00e0o \u0111\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c \u00f4. Tr\u01b0\u1edbc ti\u00ean, b\u1ea1n ph\u1ea3i thay \u0111\u1ed5i b\u1ea3ng th\u00e0nh c\u00e1c \u00f4 d\u1eef li\u1ec7u b\u00ecnh th\u01b0\u1eddng (b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea3ng, ch\u1ecdn Table &gt; Nh\u1ea5n ti\u1ebfp v\u00e0o m\u1ee5c Convert to Range, r\u1ed3i m\u1edbi th\u1ef1c hi\u1ec7n ti\u1ebfp vi\u1ec7c g\u1ed9p \u00f4.<\/li>\n<li>Tr\u00ean \u1ee9ng d\u1ee5ng Excel kh\u00f4ng \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p s\u1eb5n c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 b\u1ea1n l\u1ef1a ch\u1ecdn gi\u1eefa nh\u1eefng \u00f4 \u0111\u00e3 g\u1ed9p v\u00e0 \u00f4 ch\u01b0a g\u1ed9p. Ch\u00ednh v\u00ec th\u1ebf, b\u1ea1n ph\u1ea3i th\u1ef1c hi\u1ec7n theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 18pt;\">T\u1ea1m k\u1ebft<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady, Divine Shop \u0111\u00e3 chia s\u1ebb cho b\u1ea1n c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n. Hy v\u1ecdng v\u1edbi b\u00e0i h\u01b0\u1edbng d\u1eabn tr\u00ean s\u1ebd gi\u00fap \u00edch v\u1edbi b\u1ea1n. Ch\u00fac b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.<\/p>\n<ul>\n<li><em><strong>\u00a0<\/strong><\/em><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a class=\"https:\/\/divineshop.vn\/search?tag=microsoft\" href=\"https:\/\/divineshop.vn\/search?tag=microsoft\" target=\"_blank\" rel=\"https:\/\/divineshop.vn\/search?tag=microsoft noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1.png\" alt=\"\" class=\"wp-image-276759\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/04\/Microsoft-office-1-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<div class=\"wp-container-69e52d13f380e wp-block-group\"><div class=\"wp-block-group__inner-container\"><\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<!--nextpage-->\n\n\n\n<figure class=\"wp-block-image size-full\"><a class=\"https:\/\/divineshop.vn\/search?q=windows\" href=\"https:\/\/divineshop.vn\/search?q=windows\" target=\"_blank\" rel=\"https:\/\/divineshop.vn\/search?q=windows noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png\" alt=\"\" class=\"wp-image-256838\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2024\/07\/Windows-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0<\/p>\n","protected":false},"author":12,"featured_media":44566,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[38,255],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n\" \/>\n<meta property=\"og:description\" content=\"Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T11:51:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-05-09T04:31:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"552\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg\",\"width\":800,\"height\":552},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/\",\"name\":\"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#primaryimage\"},\"datePublished\":\"2022-04-12T11:51:33+00:00\",\"dateModified\":\"2022-05-09T04:31:08+00:00\",\"description\":\"Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n\",\"datePublished\":\"2022-04-12T11:51:33+00:00\",\"dateModified\":\"2022-05-09T04:31:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#webpage\"},\"wordCount\":1413,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg\",\"keywords\":[\"divineshop\",\"Th\u1ee7 thu\u1eadt Excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#respond\"]}],\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0","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:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n","og_description":"Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0","og_url":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T11:51:33+00:00","article_modified_time":"2022-05-09T04:31:08+00:00","og_image":[{"width":800,"height":552,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"10 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg","width":800,"height":552},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/","name":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#primaryimage"},"datePublished":"2022-04-12T11:51:33+00:00","dateModified":"2022-05-09T04:31:08+00:00","description":"Khi so\u1ea1n th\u1ea3o tr\u00ean b\u1ea3ng t\u00ednh Excel, b\u1ea1n mu\u1ed1n th\u1ef1c hi\u1ec7n vi\u1ec7c g\u1ed9p \u00f4 \u0111\u1ec3 gi\u00fap th\u00f4ng tin \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb t\u1ed1t h\u01a1n. V\u1eady c\u00e1ch g\u1ed9p \u00f4 trong Excel nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y xem b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y ngay.\u00a0","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"H\u01b0\u1edbng d\u1eabn 5 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n","datePublished":"2022-04-12T11:51:33+00:00","dateModified":"2022-05-09T04:31:08+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#webpage"},"wordCount":1413,"commentCount":0,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien_623d4eb4439d8.jpeg","keywords":["divineshop","Th\u1ee7 thu\u1eadt Excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/divineshop.vn\/tin-tuc\/huong-dan-5-cach-gop-o-trong-excel-nhanh-chong-va-de-thuc-hien\/#respond"]}],"copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/44564"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=44564"}],"version-history":[{"count":3,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/44564\/revisions"}],"predecessor-version":[{"id":84053,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/44564\/revisions\/84053"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/44566"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=44564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=44564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=44564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}