{"id":272014,"date":"2023-12-07T19:27:04","date_gmt":"2023-12-07T12:27:04","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=272014"},"modified":"2023-12-07T19:27:04","modified_gmt":"2023-12-07T12:27:04","slug":"cach-gop-o-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/","title":{"rendered":"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft"},"content":{"rendered":"<p><span style=\"font-weight: 400;\"><strong>C\u00e1ch g\u1ed9p \u00f4 trong Excel<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng thao t\u00e1c kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 c\u1ea7n thi\u1ebft cho ho\u1ea1t \u0111\u1ed9ng tr\u00ean Excel. Vi\u1ec7c n\u00e0y \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng. Vi\u1ec7c n\u00e0y v\u1eeba gi\u00fap t\u1ea1o n\u00ean h\u00ecnh th\u1ee9c \u0111\u1eb9p, ch\u1ec9nh chu, chuy\u00ean nghi\u1ec7p cho b\u1ea3ng v\u1eeba gi\u00fap t\u00ednh to\u00e1n \u0111\u01a1n gi\u1ea3n h\u01a1n. Tuy nhi\u00ean, hi\u1ec7n t\u1ea1i vi\u1ec7c g\u1ed9p \u00f4 ch\u00fang ta \u0111ang th\u1ef1c kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 ch\u1ec9 d\u1eebng l\u1ea1i \u1edf m\u1ed9t s\u1ed1 y\u00eau c\u1ea7u nh\u1ea5t \u0111\u1ecbnh. \u0110\u1eb7c bi\u1ec7t, \u0111\u1ed1i v\u1edbi nh\u1eefng \u00f4 c\u00f3 nhi\u1ec1u n\u1ed9i dung kh\u00e1c nhau nh\u01b0ng b\u1ea1n c\u1ea7n g\u1ed9p l\u1ea1i. H\u1ea7u h\u1ebft c\u00e1c n\u1ed9i dung s\u1ebd b\u1ecb m\u1ea5t tr\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i ho\u1eb7c \u00f4 \u0111\u1ea7u ti\u00ean tr\u00ean c\u00f9ng. V\u1eady n\u00ean, vi\u1ec7c n\u00e0y s\u1ebd khi\u1ebfn b\u1ea1n g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n c\u0169ng nh\u01b0 b\u1ea5t ti\u1ec7n h\u01a1n khi th\u1ef1c hi\u1ec7n.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi, Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n c\u00e1c c\u00e1ch g\u1ed9p \u00f4 trong Excel, c\u00e1c l\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u00e0 c\u00e1c \u0111i\u1ec1u c\u1ea7n l\u01b0u \u00fd.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e1c c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Theo c\u00e1ch g\u1ed9p \u00f4 trong Excel trong truy\u1ec1n th\u1ed1ng th\u00ec vi\u1ec7c g\u1ed9p nhi\u1ec1u \u00f4 s\u1ebd b\u1ecb m\u1ea5t d\u1eef li\u1ec7u. N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i gi\u1eef li\u1ec7u c\u00e1c \u00f4 th\u00ec s\u1ebd kh\u00e1 kh\u00f3 kh\u0103n, ng\u01b0\u1eddi d\u00f9ng ph\u1ea3i g\u00f5 tay l\u1ea1i to\u00e0n b\u1ed9 sau khi g\u1ed9p \u00f4. Th\u1ebf nh\u01b0ng, n\u00f3 s\u1ebd l\u00e0m m\u1ea5t th\u1eddi gian v\u00e0 kh\u00f4ng t\u1eadn d\u00f9ng \u0111\u01b0\u1ee3c h\u1ebft. Ch\u00fang ta v\u1eabn c\u00f3 c\u00e1ch g\u1ed9p nhi\u1ec1u \u00f4 m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u b\u00ean d\u01b0\u1edbi:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel b\u1eb1ng Justify<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn c\u00e1c \u00f4 c\u00f3 c\u1ea7n g\u1ed9p. C\u00e1c \u00f4 n\u00e0y ph\u1ea3i c\u00f9ng m\u1ed9t h\u00e0ng ho\u1eb7c c\u00f9ng m\u1ed9t c\u1ed9t. \u0110i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng ho\u1eb7c h\u1eb9p c\u1ee7a \u00f4 \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ec3 hi\u1ec7n d\u1eef li\u1ec7u trong \u00f4.<\/span><\/p>\n<figure id=\"attachment_293200\" aria-describedby=\"caption-attachment-293200\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-293200 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-7.jpg\" alt=\"Cach-gop-o-trong-Excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293200\" class=\"wp-caption-text\">Ch\u1ecdn c\u00e1c \u00f4 c\u00f3 c\u1ea7n g\u1ed9p<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Tr\u00ean tab Home, b\u1ea1n l\u1ef1a ch\u1ecdn Editing. Sau \u0111\u00f3 b\u1ea1n l\u1ef1a ch\u1ecdn l\u1ec7nh Fill \u0111\u1ec3 chuy\u1ec3n \u0111\u1ed5i to\u00e0n b\u1ed9 th\u00f4ng tin \u1edf c\u00e1c \u00f4 c\u00f2n l\u1ea1i l\u00ean \u00f4 tr\u00ean c\u00f9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ch\u1ecdn Justify \u0111\u1ec3 g\u1ed9p \u00f4. Vi\u1ec7c n\u00e0y s\u1ebd t\u00f9y v\u00e0o \u0111\u1ecbnh d\u1ea1ng c\u0103n gi\u1eefa hay c\u0103n tr\u00e1i n\u1ed9i dung b\u1ea1n mu\u1ed1n th\u1ec3 hi\u1ec7n \u0111\u1ec3 l\u1ef1a ch\u1ecdn.\u00a0<\/span><\/p>\n<figure id=\"attachment_293201\" aria-describedby=\"caption-attachment-293201\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-293201 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-8.jpg\" alt=\"Cach-gop-o-trong-Excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293201\" class=\"wp-caption-text\">Ch\u1ecdn Fill, ti\u1ebfp t\u1ee5c ch\u1ecdn\u00a0<span style=\"font-weight: 400;\">Justify<\/span> \u0111\u1ec3 g\u1ed9p \u00f4<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel b\u1eb1ng Justify n\u00e0y l\u00e0 m\u1ed9t trong nh\u1eefng c\u00e1ch kh\u00e1 nhanh v\u00e0 thu\u1eadn l\u1ee3i. Thao t\u00e1c th\u1ef1c hi\u1ec7n c\u0169ng \u0111\u01a1n gi\u1ea3n. Tuy nhi\u00ean, c\u00e1ch n\u00e0y ch\u1ec9 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1ed1i v\u1edbi c\u00e1c \u00f4 c\u00f9ng m\u1ed9t h\u00e0ng hay c\u00f9ng m\u1ed9t c\u1ed9t. Justify ch\u1ec9 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c \u0111\u1ed1i v\u1edbi d\u00e3y \u00f4 ch\u1ec9 c\u00f3 d\u1eef li\u1ec7u ch\u1eef, kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c v\u1edbi tr\u01b0\u1eddng h\u1ee3p c\u00f3 s\u1ed1 ho\u1eb7c c\u00f4ng th\u1ee9c. V\u1eady n\u00ean b\u1ea1n c\u00f3 th\u1ec3 c\u00e2n nh\u1eafc khi s\u1eed d\u1ee5ng c\u00e1ch n\u00e0y.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel b\u1eb1ng Merge and Center<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: M\u1edf Excel, ch\u1ecdn file v\u00e0 m\u1edf file b\u1ea1n c\u1ea7n thao t\u00e1c.<\/span><\/p>\n<figure id=\"attachment_293202\" aria-describedby=\"caption-attachment-293202\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-293202 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-9.jpg\" alt=\"Cach-gop-o-trong-Excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293202\" class=\"wp-caption-text\">M\u1edf Excel, ch\u1ecdn file v\u00e0 m\u1edf file b\u1ea1n c\u1ea7n thao t\u00e1c.<\/figcaption><\/figure>\n<p>B\u01b0\u1edbc 2: \u1ea4n ch\u1ecdn c\u00e1c c\u1ed9t n\u1eb1m k\u1ebf s\u00e1t nhau m\u00e0 b\u1ea1n \u0111ang mu\u1ed1n g\u1ed9p<\/p>\n<figure id=\"attachment_293203\" aria-describedby=\"caption-attachment-293203\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293203 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-10.jpg\" alt=\"Cach-gop-o-trong-Excel-10.\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293203\" class=\"wp-caption-text\">L\u1ef1a ch\u1ecdn c\u00e1c c\u1ed9t n\u1eb1m k\u1ebf s\u00e1t nhau theo y\u00eau c\u1ea7u g\u1ed9p<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i tab &#8220;Home&#8221;, ch\u1ecdn l\u1ec7nh &#8221; Merge and Center.<\/span><\/span><\/p>\n<figure id=\"attachment_293204\" aria-describedby=\"caption-attachment-293204\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293204 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-11.jpg\" alt=\"Cach-gop-o-trong-Excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293204\" class=\"wp-caption-text\">\u1ede tab &#8220;Home&#8221;, b\u1ea1n l\u1ef1a ch\u1ecdn l\u1ec7nh &#8221; Merge and Center&#8221;<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u1ede &#8220;Merge and Center&#8221; s\u1ebd c\u00f3 4 m\u1ee5c \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n, bao g\u1ed3m:<\/span><\/p>\n<ul>\n<li>Merge &amp; Center \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4 th\u00e0nh m\u1ed9t \u00f4 v\u00e0 n\u00f3 n\u1eb1m \u1edf v\u1ecb tr\u00ed gi\u1eefa b\u1ea3ng<\/li>\n<li>Merge Across \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 g\u1ed9p c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn theo t\u1eebng \u00f4 ri\u00eang bi\u1ec7t<\/li>\n<li>Merge Cells \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 g\u1ed9p c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn th\u00e0nh 1 \u00f4 duy nh\u1ea5t. Tuy nhi\u00ean, n\u00f3 s\u1ebd kh\u00f4ng n\u1eb1m \u1edf gi\u1eefa.<\/li>\n<li>Ummerge Cells \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 h\u1ee7y g\u1ed9p \u00f4.<\/li>\n<\/ul>\n<figure id=\"attachment_293205\" aria-describedby=\"caption-attachment-293205\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293205 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-12.jpg\" alt=\"Cach-gop-o-trong-Excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293205\" class=\"wp-caption-text\">4 l\u1ef1a ch\u1ecdn \u1edf &#8220;Merge and Center&#8221;<\/figcaption><\/figure>\n<p>Sau khi l\u1ef1a ch\u1ecdn l\u1ec7nh c\u1ea7n d\u00f9ng, Excel s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 l\u1ea1i cho b\u1ea1n.<span style=\"font-weight: 400;\">\u00a0C\u00e1c n\u1ed9i dung v\u00e0 c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c g\u1ed9p l\u1ea1i v\u1edbi nhau.\u00a0<\/span><\/p>\n<figure id=\"attachment_293206\" aria-describedby=\"caption-attachment-293206\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293206 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-13.jpg\" alt=\"Cach-gop-o-trong-Excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293206\" class=\"wp-caption-text\">C\u00e1c n\u1ed9i dung v\u00e0 c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c g\u1ed9p l\u1ea1i v\u1edbi nhau.<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong excel b\u1eb1ng l\u1ec7nh n\u00e0y s\u1ebd thu\u1eadn ti\u1ec7n v\u00e0 nhanh ch\u00f3ng h\u01a1n so v\u1edbi Justify. D\u00f9 \u1edf b\u1ea5t k\u1ef3 n\u1ed9i dung \u1edf d\u1ea1ng d\u1eef li\u1ec7u ch\u1eef, s\u1ed1 ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t \u0111\u1ec1u c\u00f3 th\u1ec3 g\u1ed9p l\u1ea1i.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel b\u1eb1ng Concatenate<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n g\u1ed9p d\u1eef li\u1ec7u c\u1ee7a 2 \u00f4 A2 v\u00e0 A3 v\u00e0o m\u1ed9t \u00f4 ri\u00eang bi\u1ec7t n\u00e0o \u0111\u00f3, kh\u00f4ng ph\u1ea3i l\u00e0 A2 v\u00e0 A3. V\u1eady c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c =Concatenate(A2,\u201d.\u201d,B2).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 b\u1ea1n mu\u1ed1n t\u1eadp h\u1ee3p 2 \u00f4 A2 v\u00e0 B2 c\u00f9ng v\u1edbi th\u00f4ng tin g\u1ed1c, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p.<\/span><\/p>\n<figure id=\"attachment_293208\" aria-describedby=\"caption-attachment-293208\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293208 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-15.jpg\" alt=\"Cach-gop-o-trong-Excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293208\" class=\"wp-caption-text\">X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p<\/figcaption><\/figure>\n<p>B\u01b0\u1edbc 2: Sau \u0111\u00f3, b\u1ea1n ti\u1ebfn h\u00e0nh nh\u1eadp c\u00f4ng th\u1ee9c =<span style=\"font-weight: 400;\">Concatenate(Xn,\u201d.\u201d,Yn) &#8211; V\u1ecb tr\u00ed 2 \u00f4 b\u1ea5t k\u1ef3 b\u1ea1n mu\u1ed1n g\u1ed9p. Sau \u0111\u00f3 nh\u1ea5n Enter, Excel s\u1ebd tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 cho b\u1ea1n.<\/span><\/p>\n<figure id=\"attachment_293209\" aria-describedby=\"caption-attachment-293209\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293209 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-16.jpg\" alt=\"Cach-gop-o-trong-Excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293209\" class=\"wp-caption-text\">Nh\u1ea5n Enter, Excel s\u1ebd tr\u1ea3 l\u1ea1i k\u1ebft qu\u1ea3 cho b\u1ea1n.<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">C\u00e1ch n\u00e0y th\u1ef1c hi\u1ec7n kh\u00e1 nhanh ch\u00f3ng v\u00e0 t\u1ed1i \u01b0u. B\u1ea1n c\u00f3 th\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4 v\u1edbi n\u1ed9i dung kh\u00e1c nhau m\u00e0 c\u00f3 th\u1ec3 gi\u1eef \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u ban \u0111\u1ea7u. \u0110\u1eb7c bi\u1ec7t, khi s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n th\u00eam c\u00e1c d\u1ea5u ng\u1eaft c\u00e2u \u0111\u1ec3 khi k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 nh\u00ecn r\u00f5 r\u00e0ng v\u00e0 kh\u00f4ng b\u1ecb r\u1ed1i m\u1eaft.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p d\u1eef li\u1ec7u trong 2 hay nhi\u1ec1u c\u1ed9t trong Excel thu\u1eadn ti\u1ec7n<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i c\u00e1ch g\u1ed9p \u00f4 trong Excel, \u0111\u00f4i l\u00fac b\u1ea1n c\u0169ng c\u1ea7n g\u1ed9p nhi\u1ec1u d\u1eef li\u1ec7u th\u00f4ng tin h\u01a1n. N\u00f3 c\u00f3 th\u1ec3 l\u00e0 g\u1ed9p nhi\u1ec1u c\u1ed9t ho\u1eb7c nhi\u1ec1u h\u00e0ng. V\u1eady n\u00ean, ch\u00fang ta c\u1ea7n 1 c\u00e1ch t\u1ed1i \u01b0u h\u01a1n \u0111\u1ec3 th\u1ef1c hi\u1ec7n. C\u00f3 2 c\u00e1ch g\u1ed9p \u00f4 trong Excel theo c\u1ed9t b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">G\u1ed9p 2 c\u1ed9t b\u1eb1ng To\u00e1n t\u1eed<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">To\u00e1n t\u1eed ho\u1eb7c c\u00f4ng th\u1ee9c l\u00e0 c\u00e1ch c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn g\u1ed9p c\u00e1c h\u00e0ng v\u1edbi nhau theo c\u00f4ng th\u1ee9c Excel v\u00e0 c\u00f3 th\u1ec3 d\u00f9ng d\u1ea5u c\u00e2u \u0111\u1ec3 ph\u00e2n t\u00e1ch c\u00e1c n\u1ed9i dung. \u0110\u1ec3 th\u1ef1c hi\u1ec7n, b\u1ea1n d\u00f9ng c\u00f4ng th\u1ee9c =A2&amp;\u201d \u201c&amp;B2\u201d \u201c&amp;C2, v\u1edbi A2, B2 v\u00e0 C2 l\u00e0 c\u00e1c \u00f4 c\u1ea7n g\u1ed9p. \u0110\u1ed3ng th\u1eddi, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d\u1ea5u c\u00e2u ho\u1eb7c k\u00fd hi\u1ec7u \u0111\u1ec3 ng\u0103n c\u00e1ch nh\u1eefng n\u1ed9i dung b\u1eb1ng c\u00e1ch chen gi\u1eefa hai d\u1ea5u ngo\u1eb7c k\u00e9p.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c\u201c=A2&amp;\u201d \u201c&amp;B2\u201d \u201c&amp;C2<\/span><\/p>\n<figure id=\"attachment_293210\" aria-describedby=\"caption-attachment-293210\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293210 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-17.jpg\" alt=\"Cach-gop-o-trong-Excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293210\" class=\"wp-caption-text\">Nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o \u00f4<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: \u1ea4n Enter \u0111\u1ec3 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c hi\u1ec7n ra.<\/span><\/p>\n<figure id=\"attachment_293211\" aria-describedby=\"caption-attachment-293211\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293211 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-18.jpg\" alt=\"Cach-gop-o-trong-Excel-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293211\" class=\"wp-caption-text\">\u1ea4n Enter \u0111\u1ec3 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c hi\u1ec7n ra<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u00f9ng m\u1ed9t c\u1ed9t \u0111\u1ec3 ti\u1ebft ki\u1ec7m th\u1eddi gian c\u0169ng nh\u01b0 chuy\u00ean nghi\u1ec7p h\u01a1n.\u00a0<\/span><\/p>\n<figure id=\"attachment_293212\" aria-describedby=\"caption-attachment-293212\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293212 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-19.jpg\" alt=\"Cach-gop-o-trong-Excel-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293212\" class=\"wp-caption-text\">K\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 c\u00f2n l\u1ea1i trong c\u00f9ng m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<h3><span style=\"font-weight: 400;\">G\u1ed9p 2 c\u1ed9t b\u1eb1ng Concatenate<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Concatenate c\u0169ng kh\u00e1 t\u01b0\u01a1ng t\u01b0 v\u00e0 gi\u1ed1ng v\u1edbi to\u00e1n t\u1eed. C\u00e1ch g\u1ed9p \u00f4 trong Excel n\u00e0y cho ph\u00e9p b\u1ea1n c\u00f3 th\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4 kh\u00e1c nhau l\u1ea1i. Trong c\u00e1ch l\u00e0m n\u00e0y, b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng d\u1ea5u c\u00e2u ho\u1eb7c k\u00fd t\u1ef1 \u0111\u1ec3 ng\u0103n c\u00e1ch gi\u1eefa c\u00e1c n\u1ed9i dung, chen gi\u1eefa hai d\u1ea5u ngo\u1eb7c k\u00e9p trong c\u00f4ng th\u1ee9c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1eadp c\u00f4ng th\u1ee9c =Concatenate(A2&amp;\u201d \u201c&amp;B2\u201d \u201c&amp;C2)<\/span><\/p>\n<figure id=\"attachment_293194\" aria-describedby=\"caption-attachment-293194\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293194 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-1.jpg\" alt=\"Cach-gop-o-trong-Excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293194\" class=\"wp-caption-text\">Nh\u1eadp c\u00f4ng th\u1ee9c =Concatenate<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 g\u1ed9p n\u1ed9i dung nhi\u1ec1u c\u1ed9t l\u1ea1i.<\/span><\/p>\n<figure id=\"attachment_293195\" aria-describedby=\"caption-attachment-293195\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293195 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-2.jpg\" alt=\"Cach-gop-o-trong-Excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293195\" class=\"wp-caption-text\">Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 g\u1ed9p n\u1ed9i dung<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: K\u00e9o c\u00f4ng th\u1ee9c cho \u0111\u1ebfn h\u1ebft d\u1ea3i \u00f4 b\u1ea1n c\u1ea7n g\u1ed9p n\u1ed9i dung. T\u1ea5t c\u1ea3 c\u00e1c \u00f4 ph\u1ea3i c\u00f9ng chung m\u1ed9t c\u1ed9t v\u1edbi c\u1ed9t \u1edf tr\u00ean.<\/span><\/p>\n<figure id=\"attachment_293196\" aria-describedby=\"caption-attachment-293196\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293196 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-3.jpg\" alt=\"Cach-gop-o-trong-Excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293196\" class=\"wp-caption-text\">K\u00e9o c\u00f4ng th\u1ee9c cho \u0111\u1ebfn h\u1ebft d\u1ea3i \u00f4 b\u1ea1n c\u1ea7n g\u1ed9p n\u1ed9i dung<\/figcaption><\/figure>\n<h2><span style=\"font-weight: 400;\">C\u00e1c l\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n c\u00e1ch g\u1ed9p \u00f4 trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 qu\u1ea3 th\u1ef1c kh\u00f4ng qu\u00e1 kh\u00f3. N\u00f3 nh\u01b0 m\u1ed9t thao t\u00e1c c\u01a1 b\u1ea3n trong s\u1eed d\u1ee5ng Excel. Tuy nhi\u00ean, n\u1ebfu b\u1ea1n kh\u00f4ng hi\u1ec3u r\u00f5 s\u00e2u b\u1ea3n ch\u1ea5t c\u1ee7a thao t\u00e1c n\u00e0y c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 kh\u00f4ng \u0111\u00fang nh\u01b0 mong mu\u1ed1n. Khi g\u1ed9p \u00f4 b\u1ea1n c\u0169ng c\u1ea7n l\u01b0u \u00fd:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu g\u1ed9p \u00f4 c\u1ed9t b\u00ecnh th\u01b0\u1eddng m\u00e0 kh\u00f4ng d\u00f9ng c\u00e1c l\u1ec7nh tr\u00ean \u0111\u00e2y th\u00ec c\u00e1c k\u00ed t\u1ef1 v\u00e0 n\u1ed9i dung \u1edf c\u00e1c \u00f4 s\u1ebd b\u1ecb m\u1ea5t. N\u1ed9i dung ch\u1ec9 \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i \u1edf \u00f4 \u0111\u1ea7u ti\u00ean trong d\u1ea3i \u00f4 c\u1ea7n g\u1ed9p.<\/span><\/p>\n<figure id=\"attachment_293197\" aria-describedby=\"caption-attachment-293197\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293197 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-4.jpg\" alt=\"Cach-gop-o-trong-Excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293197\" class=\"wp-caption-text\">C\u00e1c l\u01b0u \u00fd khi th\u1ef1c hi\u1ec7n c\u00e1ch g\u1ed9p \u00f4<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n \u0111ang nh\u1eadp b\u1ea3ng ho\u1eb7c \u0111ang ch\u1ec9nh s\u1eeda b\u1ea3ng th\u00ec kh\u00f4ng th\u1ec3 g\u1ed9p c\u1ed9t ho\u1eb7c \u00f4. C\u00f4ng c\u1ee5 Merge &amp; Center kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c s\u1ebd hi\u1ec7n m\u00e0u x\u00e1m. B\u1ea1n ch\u1ec9 c\u1ea7n \u1ea5n n\u00fat Enter \u0111\u1ec3 k\u1ebft th\u00fac qu\u00e1 tr\u00ecnh nh\u1eadp v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1ch g\u1ed9p \u00f4 trong Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">N\u1ebfu d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n \u0111ang \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u1edf d\u1ea1ng d\u1eef li\u1ec7u b\u1ea3ng th\u00ec kh\u00f4ng th\u1ec3 ti\u1ebfn h\u00e0nh g\u1ed9p \u00f4. V\u1eady n\u00ean, b\u1ea1n c\u1ea7n chuy\u1ec3n b\u1ea3ng v\u1ec1 d\u1ea1ng d\u1eef li\u1ec7u th\u00f4ng th\u01b0\u1eddng \u0111\u1ec3 g\u1ed9p. C\u00e1ch th\u1ef1c hi\u1ec7n: ch\u1ec9 c\u1ea7n ch\u1ecdn Table Tools, sau \u0111\u00f3 ch\u1ecdn Design v\u00e0 ch\u1ecdn Convert to Range.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">L\u1ed7i th\u01b0\u1eddng g\u1eb7p v\u1edbi c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c g\u1ed9p v\u00e0 c\u00e1ch x\u1eed l\u00fd<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n c\u00e1ch g\u1ed9p \u00f4 trong Excel s\u1ebd kh\u00f4ng tr\u00e1nh kh\u1ecfi nh\u1eefng l\u1ed7i th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n. Th\u1ebf nh\u01b0ng b\u1ea1n \u0111\u00e3 hi\u1ec3u r\u00f5 h\u1ebft c\u00e1c l\u1ed7i \u1ea5y, vi\u1ec7c hi\u1ec3u n\u00e0y s\u1ebd gi\u00fap b\u1ea1n nhanh t\u00ecm ra c\u00e1ch x\u1eed l\u00fd. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 2 l\u1ed7i th\u01b0\u1eddng hay g\u1eb7p:<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>M\u1ea5t d\u1eef li\u1ec7u:<\/strong> \u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i th\u01b0\u1eddng xuy\u00ean g\u1eb7p ph\u1ea3i. Khi g\u1ed9p \u00f4, n\u1ebfu b\u1ea1n ch\u1ec9 ch\u1ecdn d\u1ea3i \u00f4 c\u1ea7n g\u1ed9p. Sau \u0111\u00f3 l\u1ef1a ch\u1ecdn l\u1ec7nh Merge &amp; Center th\u00ec d\u1eef li\u1ec7u tr\u1eeb \u00f4 \u0111\u1ea7u ti\u00ean c\u00e1c \u00f4 c\u00f2n l\u1ea1i s\u1ebd \u0111\u1ec1u b\u1ecb m\u1ea5t. V\u1eady n\u00ean b\u1ea1n c\u00f3 th\u1ec3 thay v\u00e0o \u0111\u00f3 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c v\u00e0 c\u00e1c l\u1ec7nh \u1edf tr\u00ean \u0111\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4 nh\u1eefng kh\u00f4ng b\u1ecb m\u1ea5t d\u1eef li\u1ec7u.<\/span><\/p>\n<figure id=\"attachment_293229\" aria-describedby=\"caption-attachment-293229\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293229 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel.jpg\" alt=\"Cach-gop-o-trong-Excel-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293229\" class=\"wp-caption-text\">L\u1ed7i c\u00f3 th\u1ec3 x\u1ea3y ra khi k\u00e9o c\u00f4ng th\u1ee9c v\u1edbi c\u00e1c \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c g\u1ed9p<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">K\u00edch th\u01b0\u1edbc c\u1ee7a c\u00e1c \u00f4 kh\u00f4ng gi\u1ed1ng nhau: Ngh\u0129a l\u00e0 khi th\u1ef1c hi\u1ec7n, nh\u1eefng \u00f4 trong d\u1ea3i \u00f4 c\u1ea7n g\u1ed9p c\u00f3 k\u00edch th\u01b0\u1edbc v\u00e0 \u0111\u1ed9 l\u1edbn kh\u00f4ng gi\u1ed1ng nhau. Ho\u1eb7c trong c\u00e1c \u00f4 \u0111\u00f3 \u0111\u00e3 \u0111\u01b0\u1ee3c g\u1ed9p tr\u01b0\u1edbc \u0111\u00f3. \u0110\u1ec3 c\u00f3 th\u1ec3 g\u1ed9p \u00f4 \u0111\u01b0\u1ee3c trong tr\u01b0\u1eddng h\u1ee3p n\u00e0, b\u1ea1n c\u1ea7n t\u00e1ch c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p \u0111\u1ec3 c\u00e1c \u00f4 c\u00f9ng \u0111\u1ed9 l\u1edbn m\u1edbi c\u00f3 th\u1ec3 g\u1ed9p \u00f4 l\u1ea1i \u0111\u01b0\u1ee3c.\u00a0\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">C\u00e1c ph\u00edm t\u1eaft d\u00f9ng \u0111\u1ec3 c\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel ngo\u00e0i c\u00e1ch d\u00f9ng c\u00e2u l\u1ec7nh th\u00ec c\u00f3 c\u00e1ch th\u1ee9 2 l\u00e0 d\u00f9ng ph\u00edm. C\u00e1ch n\u00e0y s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c th\u1eddi gian t\u00ecm ki\u1ebfm c\u00e1c l\u1ec7nh c\u0169ng nh\u01b0 th\u1ef1c hi\u1ec7n \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb h\u01a1n. Ch\u1ee7 y\u1ebfu s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 t\u00ecm, ch\u1ecdn v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c c\u00f4ng vi\u00ean. Quy tr\u00ecnh g\u1ed3m c\u00e1c b\u01b0\u1edbc nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn c\u00e1c \u00f4 trong d\u1ea3i \u00f4 b\u1ea1n mu\u1ed1n g\u1ed9p.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n v\u00e0 gi\u1eef ph\u00edm Alt tr\u00ean thanh c\u00f4ng c\u1ee5 Excel \u0111\u1ebfn khi c\u00e1c ch\u1eef vi\u1ebft t\u1eaft c\u1ee7a t\u1eebng l\u1ec7nh \u0111\u01b0\u1ee3c hi\u1ec7n l\u00ean.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: \u1ea4n ch\u1ecdn ph\u00edm H \u0111\u1ec3 t\u00ecm tab Home, \u1ea5n ch\u1ecdn.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Nh\u1ea5n ch\u1ecdn ph\u00edm M \u0111\u1ec3 t\u00ecm Merge &amp; Center v\u00e0 \u1ea5n ch\u1ecdn.\u00a0<\/span><\/li>\n<li><span style=\"font-weight: 400;\">B\u01b0\u1edbc 5: Nh\u1eadn ch\u1ecdn ph\u00edm C n\u1ebfu b\u1ea1n mu\u1ed1n c\u0103n gi\u1eefa, ph\u00edm A n\u1ebfu b\u1ea1n mu\u1ed1n g\u1ed9p \u00f4 theo t\u1eebng h\u00e0ng ho\u1eb7c ph\u00edm M \u0111\u1ec3 c\u0103n tr\u00e1i.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_293198\" aria-describedby=\"caption-attachment-293198\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293198 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-5.jpg\" alt=\"Cach-gop-o-trong-Excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293198\" class=\"wp-caption-text\">C\u00e1c ph\u00edm t\u1eaft d\u00f9ng \u0111\u1ec3 c\u00e1ch g\u1ed9p \u00f4 trong Excel<\/figcaption><\/figure>\n<h2><span style=\"font-weight: 400;\">C\u00e1ch t\u1eaft c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p trong Excel\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n bao nhi\u00eau th\u00ec c\u00e1ch t\u00e1ch \u00f4 \u0111\u00e3 g\u1ed9p c\u0169ng kh\u00f4ng ph\u1ee9c t\u1ea1p. \u0110\u1ec3 th\u1ef1c hi\u1ec7n, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nhanh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm. L\u1ef1a ch\u1ecdn d\u1ea3i \u00f4 \u0111\u00e3 g\u1ed9p v\u00e0 mu\u1ed1n t\u00e1ch \u00f4. Sau \u0111\u00f3 \u1ea5n ch\u1ecdn t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Z \u0111\u1ec3 th\u1ef1c hi\u1ec7n. Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 m\u1edf tab Quick Access, ch\u1ecdn Undo \u0111\u1ec3 t\u00e1ch \u00f4.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00e1ch th\u1ee9 2 c\u0169ng s\u1eed d\u1ee5ng tab Merge &amp; Center. C\u00e1ch n\u00e0y s\u1ebd th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch ch\u1ecdn d\u1ea3i \u00f4 mu\u1ed1n t\u00e1ch, v\u00e0o Merge &amp; Center v\u00e0 ch\u1ecdn Unmerge Cells.\u00a0<\/span><\/p>\n<figure id=\"attachment_293199\" aria-describedby=\"caption-attachment-293199\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-293199 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-6.jpg\" alt=\"Cach-gop-o-trong-Excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/Cach-gop-o-trong-Excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-293199\" class=\"wp-caption-text\">C\u00e1ch t\u1eaft c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p trong Excel<\/figcaption><\/figure>\n<h2><span style=\"font-weight: 400;\">L\u1eddi k\u1ebft<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y. C\u00e1ch s\u1eed d\u1ee5ng v\u00e0 th\u1ef1c hi\u1ec7n kh\u00f4ng qu\u00e1 kh\u00f3. Ngo\u00e0i c\u00e1ch g\u1ed9p truy\u1ec1n th\u1ed1ng d\u1ec5 l\u00e0m m\u1ea5t d\u1eef li\u1ec7u v\u00e0 kh\u00f4ng t\u1ed1i \u01b0u. Nh\u1eefng c\u00e1ch m\u00e0 Ho\u00e0ng H\u00e0 Mobile chia s\u1ebb tr\u00ean \u0111\u00e2y ch\u1eafc ch\u1eafn s\u1ebd gi\u00fap \u0111\u01b0\u1ee3c cho b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c nhanh v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. Kh\u00f4ng nh\u1eefng th\u1ebf,vi\u1ec7c g\u1ed9p \u00f4 s\u1ebd gi\u00fap cho b\u1ea3ng c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y r\u00f5 r\u00e0ng, c\u1ee5 th\u1ec3 v\u00e0 n\u1ed5i b\u1eadt h\u01a1n. B\u1ecf \u0111i nh\u1eefng ph\u1ea7n kh\u00f4ng c\u1ea7n thi\u1ebft, t\u00f3m g\u1ecdn n\u1ed9i dung nh\u01b0ng v\u1eabn \u0111\u1ea7y \u0111\u1ee7 s\u1ebd t\u1ea1o \u1ea5n t\u01b0\u1ee3ng v\u00e0 c\u00e1i nh\u00ecn t\u1ed1t h\u01a1n cho b\u00e0i l\u00e0m c\u1ee7a b\u1ea1n. Hi v\u1ecdng b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n c\u00f3 th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt m\u1edbi \u0111\u1ec3 chuy\u00ean nghi\u1ec7p h\u01a1n trong vi\u1ec7c s\u1eed d\u1ee5ng Excel.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1eebng qu\u00ean theo d\u00f5i ngay Ho\u00e0ng H\u00e0 \u0111\u1ec3 c\u1eadp nh\u1eadt nh\u1eefng th\u00f4ng tin v\u00e0 xu h\u01b0\u1edbng m\u1edbi nh\u1ea5t hi\u1ec7n nay nh\u00e9.\u00a0<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-can-bac-2-trong-excel\/\">H\u00e0m c\u0103n b\u1eadc 2 (SQRT) trong Excel c\u00f3 v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 t\u1eebng tr\u01b0\u1eddng h\u1ee3p<\/a><\/strong><\/li>\n<li class=\"elementor-heading-title elementor-size-default\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-trim\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m TRIM trong Excel c\u00f3 v\u00ed d\u1ee5 minh ho\u1ea1<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng thao t\u00e1c kh\u00e1 \u0111\u01a1n gi\u1ea3n v\u00e0 c\u1ea7n thi\u1ebft cho ho\u1ea1t \u0111\u1ed9ng tr\u00ean Excel. Vi\u1ec7c n\u00e0y \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng. Vi\u1ec7c n\u00e0y v\u1eeba gi\u00fap t\u1ea1o n\u00ean h\u00ecnh th\u1ee9c \u0111\u1eb9p, ch\u1ec9nh chu, chuy\u00ean nghi\u1ec7p cho b\u1ea3ng v\u1eeba gi\u00fap t\u00ednh to\u00e1n \u0111\u01a1n gi\u1ea3n h\u01a1n. Tuy nhi\u00ean, hi\u1ec7n t\u1ea1i [&hellip;]<\/p>\n","protected":false},"author":98,"featured_media":293231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-272014","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>C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft<\/title>\n<meta name=\"description\" content=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y. Tham kh\u1ea3o ngay c\u00e1ch g\u1ed9p \u00f4 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-gop-o-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y. Tham kh\u1ea3o ngay c\u00e1ch g\u1ed9p \u00f4 nh\u00e9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-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-12-07T12:27:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 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-gop-o-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/5aa28972be61851c04dcfef6f144b977\"},\"headline\":\"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft\",\"datePublished\":\"2023-12-07T12:27:04+00:00\",\"dateModified\":\"2023-12-07T12:27:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/\"},\"wordCount\":3334,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/\",\"name\":\"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg\",\"datePublished\":\"2023-12-07T12:27:04+00:00\",\"dateModified\":\"2023-12-07T12:27:04+00:00\",\"description\":\"C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y. Tham kh\u1ea3o ngay c\u00e1ch g\u1ed9p \u00f4 nh\u00e9.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-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\":\"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/5aa28972be61851c04dcfef6f144b977\",\"name\":\"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/eb0de1eab1cb5baa82a596e4e7564289.jpg?ver=1775470282\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/eb0de1eab1cb5baa82a596e4e7564289.jpg?ver=1775470282\",\"caption\":\"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-ai-diem\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft","description":"C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y. Tham kh\u1ea3o ngay c\u00e1ch g\u1ed9p \u00f4 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-gop-o-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft","og_description":"C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y. Tham kh\u1ea3o ngay c\u00e1ch g\u1ed9p \u00f4 nh\u00e9.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-12-07T12:27:04+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"17 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/"},"author":{"name":"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/5aa28972be61851c04dcfef6f144b977"},"headline":"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft","datePublished":"2023-12-07T12:27:04+00:00","dateModified":"2023-12-07T12:27:04+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/"},"wordCount":3334,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/","name":"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg","datePublished":"2023-12-07T12:27:04+00:00","dateModified":"2023-12-07T12:27:04+00:00","description":"C\u00e1ch g\u1ed9p \u00f4 trong Excel l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi ph\u1ea7n m\u1ec1m n\u00e0y. Tham kh\u1ea3o ngay c\u00e1ch g\u1ed9p \u00f4 nh\u00e9.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/12\/cah-gop-o-trong-Excel-21.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cach-gop-o-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":"C\u00e1ch g\u1ed9p \u00f4 trong Excel nhanh ch\u00f3ng m\u00e0 b\u1ea1n n\u00ean bi\u1ebft"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/5aa28972be61851c04dcfef6f144b977","name":"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/eb0de1eab1cb5baa82a596e4e7564289.jpg?ver=1775470282","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/eb0de1eab1cb5baa82a596e4e7564289.jpg?ver=1775470282","caption":"Nguy\u1ec5n Th\u1ecb \u00c1i Di\u1ec5m"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-thi-ai-diem\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/272014","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\/98"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=272014"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/272014\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/293231"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=272014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=272014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=272014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}