{"id":3093,"date":"2024-12-02T15:27:40","date_gmt":"2024-12-02T15:27:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-gop-o-trong-excel-ma-khong-mat-du-lieu\/"},"modified":"2024-12-02T15:27:40","modified_gmt":"2024-12-02T15:27:40","slug":"cach-gop-o-trong-excel-ma-khong-mat-du-lieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-gop-o-trong-excel-ma-khong-mat-du-lieu\/","title":{"rendered":"C\u00e1ch g\u1ed9p \u00f4 trong Excel m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd cung c\u1ea5p cho c\u00e1c b\u1ea1n nh\u1eefng c\u00e1ch th\u1ee9c \u0111\u1ec3 c\u00f3 th\u1ec3 nhanh ch\u00f3ng g\u1ed9p hai hay nhi\u1ec1u \u00f4 m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t d\u1eef li\u1ec7u trong c\u00e1c \u00f4 n\u00e0y trong c\u00e1c phi\u00ean b\u1ea3n Excel 2016, 2013, 2010 v\u00e0 nh\u1eefng phi\u00ean b\u1ea3n c\u0169 h\u01a1n n\u1eefa.<\/p>\n<p>Trong trang t\u00ednh Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd ph\u1ea3i g\u1ed9p hai \u00f4 hay nhi\u1ec1u \u00f4 l\u1ea1i th\u00e0nh m\u1ed9t \u00f4 l\u1edbn, v\u1edbi m\u1ee5c \u0111\u00edch hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u t\u1ed1t h\u01a1n v\u00e0 \u0111i\u1ec1u ch\u1ec9nh n\u1ed9i dung c\u00f3 c\u1ea5u tr\u00fac g\u1ecdn g\u00e0ng h\u01a1n. \u0110\u00f4i khi, n\u1ed9i dung trong m\u1ed9t \u00f4 qu\u00e1 nhi\u1ec1u v\u00e0 b\u1ea1n quy\u1ebft \u0111\u1ecbnh g\u1ed9p th\u00eam \u00f4 tr\u1ed1ng b\u00ean c\u1ea1nh \u0111\u1ec3 c\u00f3 nhi\u1ec1u kh\u00f4ng gian cho d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh.<\/p>\n<p>D\u00f9 l\u00fd do l\u00e0 g\u00ec, vi\u1ec7c g\u1ed9p \u00f4 trong Excel c\u0169ng c\u00f3 nh\u1eefng kh\u00f3 kh\u0103n nh\u1ea5t \u0111\u1ecbnh v\u00ec n\u1ebfu b\u1ea1n \u0111\u1ecbnh g\u1ed9p nhi\u1ec1u \u00f4 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u, ch\u1ee9c n\u0103ng g\u1ed9p \u00f4 c\u01a1 b\u1ea3n c\u1ee7a Excel s\u1ebd ch\u1ec9 gi\u1eef l\u1ea1i d\u1eef li\u1ec7u c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i ho\u1eb7c c\u1ee7a \u00f4 \u0111\u1ea7u ti\u00ean tr\u00ean c\u00f9ng v\u00e0 x\u00f3a \u0111i th\u00f4ng tin \u1edf nh\u1eefng \u00f4 c\u00f2n l\u1ea1i.<\/p>\n<p>B\u1ea1n s\u1ebd t\u1ef1 h\u1ecfi, li\u1ec7u c\u00f3 <strong>c\u00e1ch g\u1ed9p \u00f4 trong Excel<\/strong> m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t d\u1eef li\u1ec7u kh\u00f4ng? B\u00e0i vi\u1ebft n\u00e0y s\u1ebd cung c\u1ea5p nh\u1eefng c\u00e1ch l\u00e0m v\u00e0 gi\u1ea3i ph\u00e1p gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n n\u00e0y m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng v\u00e0 gi\u1ea3i ph\u00e1p n\u00e0y s\u1ebd ph\u00f9 h\u1ee3p cho m\u1ecdi phi\u00ean b\u1ea3n Excel, t\u1eeb 2016, 2013 \u0111\u1ebfn 2010 v\u00e0 nh\u1eefng phi\u00ean b\u1ea3n c\u0169 h\u01a1n n\u1eefa.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674dd1eae9435\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_gop_o_trong_Excel_su_dung_chuc_nang_Merge_Center\" title=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Merge &amp; Center\">C\u00e1ch g\u1ed9p \u00f4 trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Merge &amp; Center<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cac_lua_chon_gop_o_khac_trong_Excel\" title=\"C\u00e1c l\u1ef1a ch\u1ecdn g\u1ed9p \u00f4 kh\u00e1c trong Excel:\">C\u00e1c l\u1ef1a ch\u1ecdn g\u1ed9p \u00f4 kh\u00e1c trong Excel:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Nhung_truong_hop_xay_ra_loi_khi_keo_cong_thuc_voi_o_duoc_tron_gop\" title=\"Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c v\u1edbi\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n, g\u1ed9p\">Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c v\u1edbi\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n, g\u1ed9p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_keo_cong_thuc_khi_ap_dung_chuc_nang_tron_o\" title=\"C\u00e1ch\u00a0k\u00e9o c\u00f4ng th\u1ee9c khi\u00a0\u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4\">C\u00e1ch\u00a0k\u00e9o c\u00f4ng th\u1ee9c khi\u00a0\u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_1_Bo_chuc_nang_tron_o_truoc_khi_keo_cong_thuc\" title=\"C\u00e1ch 1: B\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 tr\u01b0\u1edbc khi k\u00e9o c\u00f4ng th\u1ee9c\">C\u00e1ch 1: B\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 tr\u01b0\u1edbc khi k\u00e9o c\u00f4ng th\u1ee9c<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_2_Loai_bo_cac_o_bi_tron_o_phia_duoi_roi_keo_cong_thuc_tu_dong_tren_xuong\" title=\"C\u00e1ch 2: Lo\u1ea1i b\u1ecf c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n\u00a0\u1edf ph\u00eda d\u01b0\u1edbi r\u1ed3i k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng tr\u00ean xu\u1ed1ng\">C\u00e1ch 2: Lo\u1ea1i b\u1ecf c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n\u00a0\u1edf ph\u00eda d\u01b0\u1edbi r\u1ed3i k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng tr\u00ean xu\u1ed1ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Chuc_nang_gop_o_trong_Excel_%E2%80%93_nhung_han_che\" title=\"Ch\u1ee9c n\u0103ng g\u1ed9p \u00f4 trong Excel \u2013 nh\u1eefng h\u1ea1n ch\u1ebf\">Ch\u1ee9c n\u0103ng g\u1ed9p \u00f4 trong Excel \u2013 nh\u1eefng h\u1ea1n ch\u1ebf<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_goi_phim_tat_merge_cell_trong_excel\" title=\"C\u00e1ch g\u1ecdi ph\u00edm t\u1eaft merge cell trong excel\">C\u00e1ch g\u1ecdi ph\u00edm t\u1eaft merge cell trong excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Goi_danh_sach_phim_tat_bang_phim_Alt\" title=\"G\u1ecdi danh s\u00e1ch ph\u00edm t\u1eaft b\u1eb1ng ph\u00edm Alt\">G\u1ecdi danh s\u00e1ch ph\u00edm t\u1eaft b\u1eb1ng ph\u00edm Alt<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Goi_phim_tat_merge_cell\" title=\"G\u1ecdi ph\u00edm t\u1eaft merge cell\">G\u1ecdi ph\u00edm t\u1eaft merge cell<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_gop_cac_o_trong_Excel_ma_khong_mat_du_lieu\" title=\"C\u00e1ch g\u1ed9p c\u00e1c \u00f4 trong Excel m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u:\">C\u00e1ch g\u1ed9p c\u00e1c \u00f4 trong Excel m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_1_Gop_o_trong_mot_cot_chuc_nang_Justify\" title=\"C\u00e1ch 1. G\u1ed9p \u00f4 trong m\u1ed9t c\u1ed9t (ch\u1ee9c n\u0103ng Justify)\">C\u00e1ch 1. G\u1ed9p \u00f4 trong m\u1ed9t c\u1ed9t (ch\u1ee9c n\u0103ng Justify)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_2_Gop_nhieu_o_ma_van_giu_nguyen_du_lieu_su_dung_cong_cu_ngoai_Merge_Cells\" title=\"C\u00e1ch 2. G\u1ed9p nhi\u1ec1u \u00f4 m\u00e0 v\u1eabn gi\u1eef nguy\u00ean d\u1eef li\u1ec7u s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 ngo\u00e0i Merge Cells\">C\u00e1ch 2. G\u1ed9p nhi\u1ec1u \u00f4 m\u00e0 v\u1eabn gi\u1eef nguy\u00ean d\u1eef li\u1ec7u s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 ngo\u00e0i Merge Cells<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_3_Dung_chuc_nang_CONCATENATE_de_gop_nhieu_o\" title=\"C\u00e1ch 3. D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE \u0111\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4:\">C\u00e1ch 3. D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE \u0111\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cac_phim_tat_de_gop_o_trong_Excel\" title=\"C\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 g\u1ed9p \u00f4 trong Excel\">C\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 g\u1ed9p \u00f4 trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_nhanh_chong_tim_duoc_cac_o_da_gop\" title=\"C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p\">C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cach_tach_o_da_gop_trong_Excel\" title=\"C\u00e1ch t\u00e1ch \u00f4 \u0111\u00e3 g\u1ed9p trong Excel\">C\u00e1ch t\u00e1ch \u00f4 \u0111\u00e3 g\u1ed9p trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-gop-hai-hoac-nhieu-o-trong-excel-ma-khong-mat-du-lieu.html#Cac_cach_thay_the_viec_gop_o_trong_Excel\" title=\"C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel\">C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_gop_o_trong_Excel_su_dung_chuc_nang_Merge_Center\"><\/span>C\u00e1ch g\u1ed9p \u00f4 trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Merge &amp; Center<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch nhanh nh\u1ea5t v\u00e0 d\u1ec5 nh\u1ea5t \u0111\u1ec3 g\u1ed9p hai ho\u1eb7c nhi\u1ec1u \u00f4 trong Excel l\u00e0 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Merge &amp; Center. C\u00e1ch th\u1ee9c th\u1ef1c hi\u1ec7n ch\u1ec9 bao g\u1ed3m 2 b\u01b0\u1edbc:<br \/>\n1. Ch\u1ecdn c\u00e1c \u00f4 li\u1ec1n k\u1ec1 nhau m\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p<br \/>\n2. T\u1ea1i tab <em>Home &gt; Alignment<\/em>, b\u1ea1n h\u00e3y click v\u00e0o <em>Merge &amp; Center<\/em><\/p>\n<p>Xem th\u00eam: <strong>H\u01b0\u1edbng d\u1eabn g\u1ecdi <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-goi-phim-tat-merge-cell-trong-excel-2007-2010-2013-2016.html\">ph\u00edm t\u1eaft merge trong excel<\/a><\/strong><\/p>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta c\u00f3 d\u1eef li\u1ec7u\u00a0\u1edf \u00f4 A2 v\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p \u00f4 n\u00e0y v\u1edbi c\u00e1c \u00f4 B2 v\u00e0 C2 b\u00ean ph\u1ea3i \u0111\u1ec3 t\u1ea1o th\u00e0nh 1 \u00f4 l\u1edbn ch\u1ee9a \u0111\u01b0\u1ee3c to\u00e0n b\u1ed9 th\u00f4ng tin.<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-99.gif\" title=\"vba101_92019-nho-99\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-234.gif\" title=\"ex101_92019-nho-234\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<figure id=\"attachment_6320\" aria-describedby=\"caption-attachment-6320\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6320 size-medium\" title=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Merge &amp; Center\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cells-excel-300x192-1.png\" alt=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Merge &amp; Center\" width=\"300\" height=\"192\"><figcaption id=\"caption-attachment-6320\" class=\"wp-caption-text\">C\u00e1ch g\u1ed9p \u00f4 trong Excel s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng<\/figcaption><\/figure>\n<p>M\u1ed9t khi b\u1ea1n \u0111\u00e3 click v\u00e0o <em>Merge &amp; Center<\/em>, \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c g\u1ed9p v\u1edbi c\u00e1c \u00f4 c\u00f2n l\u1ea1i th\u00e0nh 1 \u00f4 v\u00e0 v\u0103n b\u1ea3n trong \u00f4 s\u1ebd \u0111\u01b0\u1ee3c c\u0103n gi\u1eefa nh\u01b0 trong \u1ea3nh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<figure id=\"attachment_6315\" aria-describedby=\"caption-attachment-6315\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6315 size-medium\" title=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel ch\u1ee9c n\u0103ng Merge &amp; Center\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-merged-centered-cells-300x137-1.png\" alt=\"C\u00e1ch g\u1ed9p \u00f4 trong Excel ch\u1ee9c n\u0103ng Merge &amp; Center\" width=\"300\" height=\"137\"><figcaption id=\"caption-attachment-6315\" class=\"wp-caption-text\">C\u00e1ch g\u1ed9p \u00f4 ch\u1ee9c n\u0103ng Merge &amp; Center<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cac_lua_chon_gop_o_khac_trong_Excel\"><\/span>C\u00e1c l\u1ef1a ch\u1ecdn g\u1ed9p \u00f4 kh\u00e1c trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 l\u1ef1a ch\u1ecdn c\u00e1c ph\u01b0\u01a1ng ph\u00e1p g\u1ed9p \u00f4 kh\u00e1c trong Excel, b\u1ea1n h\u00e3y click v\u00e0o \u00f4 m\u0169i t\u00ean b\u00ean c\u1ea1nh <em>Merge &amp; Center<\/em> v\u00e0 ch\u1ecdn xem b\u1ea1n mu\u1ed1n g\u1ed9p \u00f4 theo c\u00e1ch n\u00e0o:<\/p>\n<figure id=\"attachment_6316\" aria-describedby=\"caption-attachment-6316\" style=\"width: 143px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6316 size-full\" title=\"Merge &amp; Center\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-merge-options.png\" alt=\"Merge &amp; Center\" width=\"143\" height=\"123\"><figcaption id=\"caption-attachment-6316\" class=\"wp-caption-text\">Merge &amp; Center<\/figcaption><\/figure>\n<p><strong>Merge Across<\/strong> \u2013 g\u1ed9p nhi\u1ec1u \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn theo t\u1eebng d\u00f2ng ri\u00eang bi\u1ec7t:<\/p>\n<figure id=\"attachment_6312\" aria-describedby=\"caption-attachment-6312\" style=\"width: 263px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6312 size-full\" title=\"Merge Across\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-merge-across.png\" alt=\"Merge Across\" width=\"263\" height=\"257\"><figcaption id=\"caption-attachment-6312\" class=\"wp-caption-text\">Merge Across<\/figcaption><\/figure>\n<p><strong>Merge Cells<\/strong> \u2013 g\u1ed9p nhi\u1ec1u \u00f4 th\u00e0nh m\u1ed9t \u00f4 duy nh\u1ea5t m\u00e0 kh\u00f4ng c\u0103n l\u1ec1 ch\u00ednh gi\u1eefa cho th\u00f4ng tin trong \u00f4:<\/p>\n<figure id=\"attachment_6313\" aria-describedby=\"caption-attachment-6313\" style=\"width: 263px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6313 size-full\" title=\"Merge Cells\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-merge-cells.png\" alt=\"Merge Cells\" width=\"263\" height=\"177\"><figcaption id=\"caption-attachment-6313\" class=\"wp-caption-text\">Merge Cells<\/figcaption><\/figure>\n<p><strong>M\u1eb9o.<\/strong> \u0110\u1ec3 thay \u0111\u1ed5i c\u0103n l\u1ec1 sau khi g\u1ed9p \u00f4, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn \u00f4 \u0111\u00e3 g\u1ed9p v\u00e0 click v\u00e0o ki\u1ec3u c\u0103n l\u1ec1 th\u00edch h\u1ee3p trong tab <em>Home &gt; Alignment.<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhung_truong_hop_xay_ra_loi_khi_keo_cong_thuc_voi_o_duoc_tron_gop\"><\/span>Nh\u1eefng tr\u01b0\u1eddng h\u1ee3p x\u1ea3y ra l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c v\u1edbi\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n, g\u1ed9p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24561\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/error-filldown-merge-cell.png\" width=\"950\" height=\"176\" title=\"error-filldown-merge-cell\"><\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 trong h\u00ecnh tr\u00ean, ch\u00fang ta mu\u1ed1n Filldown c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng 2 xu\u1ed1ng t\u1edbi d\u00f2ng 5, nh\u01b0ng\u00a0Excel b\u00e1o l\u1ed7i.<\/p>\n<p>L\u1ed7i n\u00e0y xu\u1ea5t hi\u1ec7n do trong ph\u1ea1m vi v\u00f9ng sao ch\u00e9p c\u00f4ng th\u1ee9c c\u00f3 nh\u1eefng\u00a0\u00f4\u00a0\u0111ang\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n\u00a0\u00f4, m\u00e0\u00a0\u0111\u1ed9 l\u1edbn c\u00e1c\u00a0\u00f4 tr\u1ed9n l\u1ea1i kh\u00f4ng gi\u1ed1ng nhau:<\/p>\n<ul>\n<li>T\u1ea1i d\u00f2ng 2: tr\u1ed9n 3\u00a0\u00f4 D2, E2, F2<\/li>\n<li>T\u1ea1i d\u00f2ng 4: tr\u1ed9n 2\u00a0\u00f4 D4, E4<\/li>\n<li>T\u1ea1i d\u00f2ng 5: tr\u1ed9n 3\u00a0\u00f4 D5, E5, F5<\/li>\n<\/ul>\n<p>Khi\u00a0\u0111\u00f3 ch\u00fang ta kh\u00f4ng th\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c (filldown) m\u1ed9t c\u00e1ch b\u00ecnh th\u01b0\u1eddng\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>Ngo\u00e0i ra vi\u1ec7c tr\u1ed9n\u00a0\u00f4 c\u00f2n khi\u1ebfn ch\u00fang ta g\u1eb7p l\u1ed7i khi mu\u1ed1n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-24562\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/error-on-sort-merge-cell-1024x462-1.gif\" width=\"800\" height=\"361\" title=\"error-on-sort-merge-cell-1024x462-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_keo_cong_thuc_khi_ap_dung_chuc_nang_tron_o\"><\/span>C\u00e1ch\u00a0k\u00e9o c\u00f4ng th\u1ee9c khi\u00a0\u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c nh\u1eefng l\u1ed7i tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 l\u00e0m theo 2 c\u00e1ch sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_Bo_chuc_nang_tron_o_truoc_khi_keo_cong_thuc\"><\/span>C\u00e1ch 1: B\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 tr\u01b0\u1edbc khi k\u00e9o c\u00f4ng th\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n k\u00e9o c\u00f4ng th\u1ee9c, t\u1ea1m th\u1eddi lo\u1ea1i b\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 (B\u1ea5m tr\u1edf l\u1ea1i m\u1ee5c Merge cell &amp; center)<\/li>\n<li>Sau\u00a0\u0111\u00f3 filldown c\u00f4ng th\u1ee9c trong 1 c\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3<\/li>\n<li>Cu\u1ed1i c\u00f9ng: Th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng Merge Across cho v\u00f9ng k\u1ebft qu\u1ea3<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24563\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-filldown-cong-thuc-khi-tron-o-01.gif\" width=\"672\" height=\"369\" title=\"cach-filldown-cong-thuc-khi-tron-o-01\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Loai_bo_cac_o_bi_tron_o_phia_duoi_roi_keo_cong_thuc_tu_dong_tren_xuong\"><\/span>C\u00e1ch 2: Lo\u1ea1i b\u1ecf c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n\u00a0\u1edf ph\u00eda d\u01b0\u1edbi r\u1ed3i k\u00e9o c\u00f4ng th\u1ee9c t\u1eeb d\u00f2ng tr\u00ean xu\u1ed1ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch n\u00e0y th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24564\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-filldown-cong-thuc-khi-tron-o-02.gif\" width=\"672\" height=\"369\" title=\"cach-filldown-cong-thuc-khi-tron-o-02\"><\/p>\n<p>Hy v\u1ecdng r\u1eb1ng qua b\u00e0i vi\u1ebft n\u00e0y c\u00e1c b\u1ea1n s\u1ebd kh\u00f4ng c\u00f2n m\u1eafc ph\u1ea3i l\u1ed7i khi k\u00e9o c\u00f4ng th\u1ee9c trong c\u00e1c\u00a0\u00f4 b\u1ecb tr\u1ed9n, g\u1ed9p n\u1eefa.<\/p>\n<p>Ngo\u00e0i ra ch\u00fang ta h\u1ebft s\u1ee9c l\u01b0u\u00a0\u00fd khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 trong\u00a0Excel. N\u00ean tr\u00e1nh s\u1eed d\u1ee5ng tr\u1ed9n\u00a0\u00f4 trong v\u00f9ng c\u00f3 th\u1ec3 ch\u1ee9a c\u00f4ng th\u1ee9c, ho\u1eb7c trong v\u00f9ng c\u1ea7n s\u1eafp x\u1ebfp d\u1eef li\u1ec7u.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chuc_nang_gop_o_trong_Excel_%E2%80%93_nhung_han_che\"><\/span>Ch\u1ee9c n\u0103ng g\u1ed9p \u00f4 trong Excel \u2013 nh\u1eefng h\u1ea1n ch\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y c\u1ee7a Excel \u0111\u1ec3 g\u1ed9p \u00f4, b\u1ea1n n\u00ean l\u01b0u \u00fd nh\u01b0 sau:<\/p>\n<p>1. H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng\u00a0t\u1ea5t c\u1ea3 nh\u1eefng th\u00f4ng tin b\u1ea1n mu\u1ed1n xu\u1ea5t hi\u1ec7n trong \u00f4 \u0111\u00e3 g\u1ed9p s\u1ebd n\u1eb1m trong \u00f4 \u0111\u1ea7u ti\u00ean b\u00ean tr\u00e1i c\u1ee7a d\u00e3y \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn b\u1edfi l\u1ebd ch\u1ec9 c\u00f3 d\u1eef li\u1ec7u trong \u00f4 n\u00e0y l\u00e0 \u0111\u01b0\u1ee3c gi\u1eef l\u1ea1i sau khi g\u1ed9p \u00f4 v\u00e0 d\u1eef li\u1ec7u trong nh\u1eefng \u00f4 c\u00f2n l\u1ea1i s\u1ebd b\u1ecb x\u00f3a. N\u1ebfu b\u1ea1n mu\u1ed1n g\u1ed9p nhi\u1ec1u \u00f4 m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u, h\u00e3y t\u00ecm hi\u1ec3u \u1edf ph\u1ea7n sau \u1edf b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<br \/>\n2. N\u1ebfu \u00f4 <em>Merge &amp; Center<\/em> c\u00f3 m\u00e0u x\u00e1m, c\u00f3 kh\u1ea3 n\u0103ng l\u00e0 nh\u1eefng \u00f4 b\u1ea1n ch\u1ecdn \u0111ang \u1edf d\u1ea1ng Edit. H\u00e3y nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 tho\u00e1t d\u1ea1ng Edit v\u00e0 sau \u0111\u00f3 th\u1eed g\u1ed9p \u00f4 l\u1ea1i.<br \/>\n3. Kh\u00f4ng c\u00f3 m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p g\u1ed9p \u00f4 n\u00e0o l\u00e0 kh\u1ea3 thi khi b\u1ea1n \u0111ang s\u1eed d\u1ee5ng b\u1ea3ng Excel. B\u1ea1n s\u1ebd ph\u1ea3i \u0111\u1ed5i b\u1ea3ng th\u00e0nh c\u00e1c \u00f4 s\u1ed1 li\u1ec7u th\u00f4ng th\u01b0\u1eddng tr\u01b0\u1edbc (chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea3ng, ch\u1ecdn <em>Table &gt; Convert to Range<\/em>), sau \u0111\u00f3 m\u1edbi ti\u1ebfn h\u00e0nh g\u1ed9p \u00f4.<br \/>\n4. B\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 ch\u1ecdn l\u1ef1a ri\u00eang c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p v\u00e0 \u00f4 ch\u01b0a g\u1ed9p b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 s\u1eb5n c\u00f3 c\u1ee7a Excel m\u00e0 ph\u1ea3i thao t\u00e1c b\u1eb1ng tay \u0111\u01a1n thu\u1ea7n.<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-kiem-tra-du-lieu-dang-ngay-thang-trich-xuat-tu-phan-mem-khac-ra-excel.html\">C\u00e1ch ki\u1ec3m tra d\u1eef li\u1ec7u d\u1ea1ng ng\u00e0y th\u00e1ng tr\u00edch xu\u1ea5t t\u1eeb ph\u1ea7n m\u1ec1n kh\u00e1c ra Excel<\/a><\/p>\n<p>Tr\u1ed9n\u00a0\u00f4 \u2013 Merge Cell \u2013 l\u00e0 m\u1ed9t trong nh\u1eefng ch\u1ee9c n\u0103ng th\u01b0\u1eddng xuy\u00ean\u00a0\u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong\u00a0Excel. N\u00f3 gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 tr\u00ecnh b\u00e0y t\u1ed1t h\u01a1n, d\u1ec5 nh\u00ecn h\u01a1n v\u1edbi nh\u1eefng n\u1ed9i dung l\u1edbn, d\u00e0i h\u01a1n 1\u00a0\u00f4.\u00a0\u0110\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, c\u00f3 l\u1ebd b\u1ea1n c\u1ea7n t\u1edbi ph\u00edm t\u1eaft cho ch\u1ee9c n\u0103ng n\u00e0y. H\u00e3y c\u00f9ng H\u1ecdc\u00a0Excel Online t\u00ecm hi\u1ec3u\u00a0c\u00e1ch g\u1ecdi ph\u00edm t\u1eaft cho ch\u1ee9c n\u0103ng <strong>merge cell<\/strong> trong excel nh\u00e9.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_goi_phim_tat_merge_cell_trong_excel\"><\/span>C\u00e1ch g\u1ecdi ph\u00edm t\u1eaft merge cell trong excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n l\u1ee5c t\u00ecm trong danh s\u00e1ch ph\u00edm t\u1eaft c\u00f3 s\u1eb5n c\u1ee7a\u00a0Excel, h\u1eb3n b\u1ea1n s\u1ebd t\u1ed1n c\u00f4ng v\u00f4\u00a0\u00edch b\u1edfi kh\u00f4ng c\u00f3 s\u1eb5n ph\u00edm t\u1eaft ri\u00eang cho ch\u1ee9c n\u0103ng n\u00e0y. Tuy nhi\u00ean\u00a0Excel h\u1ed7 tr\u1ee3 cho ch\u00fang ta m\u1ed9t t\u00ednh n\u0103ng r\u1ea5t h\u1eefu\u00a0\u00edch gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u1ea7u h\u1ebft c\u00e1c c\u00f4ng c\u1ee5 tr\u00ean thanh c\u00f4ng c\u1ee5 b\u1eb1ng ph\u00edm t\u1eaft.\u00a0\u0110\u00f3 l\u00e0 s\u1eed d\u1ee5ng ph\u00edm ALT.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Goi_danh_sach_phim_tat_bang_phim_Alt\"><\/span>G\u1ecdi danh s\u00e1ch ph\u00edm t\u1eaft b\u1eb1ng ph\u00edm Alt<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi b\u1ea5m ph\u00edm ALT tr\u00ean b\u00e0n ph\u00edm <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24393\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/icon-phim-alt.png\" width=\"70\" height=\"58\" title=\"icon-phim-alt\"><\/p>\n<p>tr\u00ean thanh c\u00f4ng c\u1ee5 c\u1ee7a\u00a0Excel s\u1ebd xu\u1ea5t hi\u1ec7n c\u00e1c ph\u00edm t\u1eaft\u00a0\u0111\u1ea1i di\u1ec7n cho t\u1eebng th\u1ebb, t\u1eebng nh\u00f3m, t\u1eebng ch\u1ee9c n\u0103ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24394\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phim-alt-goi-phim-tat-thanh-cong-cu-1024x196-1.png\" width=\"1024\" height=\"196\" title=\"phim-alt-goi-phim-tat-thanh-cong-cu-1024x196-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Goi_phim_tat_merge_cell\"><\/span>G\u1ecdi ph\u00edm t\u1eaft merge cell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f4ng c\u1ee5 Merge cell n\u1eb1m trong nh\u00f3m Alignment, trong th\u1ebb Home. V\u00ec v\u1eady ch\u00fang ta s\u1ebd b\u1ea5m <strong>ph\u00edm H<\/strong>\u00a0\u0111\u1ec3 ch\u1ecdn th\u1ebb Home tr\u01b0\u1edbc.<\/p>\n<p>Ti\u1ebfp\u00a0\u0111\u00f3 b\u1ea5m<strong> ph\u00edm M<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24547\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phim-tat-home-merge-cell-01.png\" width=\"833\" height=\"197\" title=\"phim-tat-home-merge-cell-01\"><\/p>\n<p>Danh s\u00e1ch c\u00e1c ch\u1ee9c n\u0103ng c\u00f3 trong Merge &amp; Center s\u1ebd xu\u1ea5t hi\u1ec7n g\u1ed3m:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24548\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/phim-tat-trong-the-merge-cell.png\" width=\"184\" height=\"163\" title=\"phim-tat-trong-the-merge-cell\"><\/p>\n<ul>\n<li>Merge &amp; center: tr\u1ed9n c\u00e1c\u00a0\u00f4, n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u01b0a v\u00e0o gi\u1eefa v\u00f9ng\u00a0\u00f4 tr\u1ed9n (tr\u1ed9n\u00a0\u00f4\u00a0\u0111\u1ed3ng th\u1eddi\u00a0\u0111\u01b0a n\u1ed9i dung v\u00e0o gi\u1eefa\u00a0\u00f4)<\/li>\n<li>Merge Across: tr\u1ed9n c\u00e1c\u00a0\u00f4 tr\u00ean c\u00f9ng 1 h\u00e0ng (n\u1ebfu v\u00f9ng c\u00f3 nhi\u1ec1u h\u00e0ng th\u00ec s\u1ebd c\u00f3 m\u1ed7i h\u00e0ng 1\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n)<\/li>\n<li>Merge Cells: tr\u1ed9n t\u1ea5t c\u1ea3 c\u00e1c\u00a0\u00f4 trong v\u00f9ng th\u00e0nh 1\u00a0\u00f4 (nhi\u1ec1u h\u00e0ng nhi\u1ec1u c\u1ed9t v\u1ec1 c\u00f9ng 1\u00a0\u00f4, ch\u1ec9 tr\u1ed9n\u00a0\u00f4 m\u00e0 kh\u00f4ng\u00a0\u0111\u01b0a v\u00e0o gi\u1eefa)<\/li>\n<li>Unmerge Cells: b\u1ecf ch\u1ee9c n\u0103ng tr\u1ed9n\u00a0\u00f4 trong 1\u00a0\u00f4\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c tr\u1ed9n t\u1eeb tr\u01b0\u1edbc\u00a0\u0111\u00f3.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady ta c\u00f3 t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft nh\u01b0 sau:<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Merge &amp; center: <strong><code class=\"excel-formula-inline\">Alt + H + M + C<\/code><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Merge Across:<strong><code class=\"excel-formula-inline\"> Alt + H + M + A<\/code><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Merge Cells:\u00a0<strong><code class=\"excel-formula-inline\">Alt + H + M + M<\/code><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Unmerge Cells:\u00a0<strong><code class=\"excel-formula-inline\">Alt + H + M + U<\/code><\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_gop_cac_o_trong_Excel_ma_khong_mat_du_lieu\"><\/span>C\u00e1ch g\u1ed9p c\u00e1c \u00f4 trong Excel m\u00e0 kh\u00f4ng m\u1ea5t d\u1eef li\u1ec7u:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u1ee9c n\u0103ng g\u1ed9p \u00f4 truy\u1ec1n th\u1ed1ng c\u1ee7a Excel s\u1ebd ch\u1ec9 gi\u1eef l\u1ea1i th\u00f4ng tin\/ d\u1eef li\u1ec7u trong \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i trong d\u00e3y \u00f4 m\u00e0 b\u1ea1n \u0111\u00e3 l\u1ef1a ch\u1ecdn. M\u1eb7c d\u00f9 Excel \u0111\u00e3 c\u00f3 nhi\u1ec1u c\u1ea3i ti\u1ebfn trong c\u00e1c phi\u00ean b\u1ea3n g\u1ea7n \u0111\u00e2y, Excel d\u01b0\u1eddng nh\u01b0 \u0111\u00e3 b\u1ecf qua v\u1ea5n \u0111\u1ec1 g\u1ed9p \u00f4 n\u00e0y v\u00ec ch\u00fang v\u1eabn t\u1ed3n t\u1ea1i \u1edf c\u00e1c phi\u00ean b\u1ea3n Excel 2013 v\u00e0 2016. Tuy nhi\u00ean, lu\u00f4n c\u00f3 \u0111\u01b0\u1eddng v\u00f2ng \u0111\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n nh\u01b0 th\u1ebf n\u00e0y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_1_Gop_o_trong_mot_cot_chuc_nang_Justify\"><\/span>C\u00e1ch 1. G\u1ed9p \u00f4 trong m\u1ed9t c\u1ed9t (ch\u1ee9c n\u0103ng Justify)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch nhanh v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 <strong>g\u1ed9p \u00f4 trong Excel<\/strong> m\u00e0 v\u1eabn gi\u1eef \u0111\u1ea7y \u0111\u1ee7 n\u1ed9i dung trong c\u00e1c \u00f4. Tuy nhi\u00ean, n\u00f3 y\u00eau c\u1ea7u c\u00e1c \u00f4 \u0111\u01b0\u1ee3c g\u1ed9p ph\u1ea3i c\u00f9ng n\u1eb1m trong m\u1ed9t c\u1ed9t.<\/p>\n<ul>\n<li>Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ea1n mu\u1ed1n g\u1ed9p.<\/li>\n<li>\u0110i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t sao cho n\u00f3 c\u00f3 th\u1ec3 ch\u1ee9a v\u1eeba \u0111\u01b0\u1ee3c th\u00f4ng tin c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c \u00f4.<\/li>\n<\/ul>\n<figure id=\"attachment_6304\" aria-describedby=\"caption-attachment-6304\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6304 size-medium\" title=\"G\u1ed9p \u00f4 trong m\u1ed9t c\u1ed9t\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/adjust-column-width-300x133-1.png\" alt=\"G\u1ed9p \u00f4 trong m\u1ed9t c\u1ed9t\" width=\"300\" height=\"133\"><figcaption id=\"caption-attachment-6304\" class=\"wp-caption-text\">G\u1ed9p \u00f4 trong m\u1ed9t c\u1ed9t<\/figcaption><\/figure>\n<ul>\n<li>\u1ede tab <em>Home<\/em>, ph\u1ea7n <em>Editing<\/em>, b\u1ea1n ch\u1ecdn <em>Fill<\/em> \u2013 c\u00e1ch n\u00e0y s\u1ebd chuy\u1ec3n to\u00e0n b\u1ed9 th\u00f4ng tin c\u1ee7a c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0o \u00f4 tr\u00ean c\u00f9ng.<\/li>\n<li>Click v\u00e0o<em> Merge and Center<\/em> ho\u1eb7c <em>Merge Cells<\/em>, t\u00f9y v\u00e0o vi\u1ec7c b\u1ea1n mu\u1ed1n th\u00f4ng tin trong \u00f4 \u0111\u01b0\u1ee3c g\u1ed9p c\u00f3 c\u0103n l\u1ec1 ch\u00ednh gi\u1eefa hay kh\u00f4ng.<\/li>\n<\/ul>\n<p>N\u1ebfu nh\u1eefng gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c g\u1ed9p tr\u00e0n ra c\u00e1c h\u00e0ng d\u01b0\u1edbi \u0111\u00f3, b\u1ea1n h\u00e3y \u0111i\u1ec1u ch\u1ec9nh cho c\u1ed9t r\u1ed9ng h\u01a1n v\u00e0 l\u1eb7p l\u1ea1i quy tr\u00ecnh n\u00e0y.<\/p>\n<p>C\u00e1ch g\u1ed9p \u00f4 n\u00e0y d\u1ec5 th\u1ef1c hi\u1ec7n nh\u01b0ng c\u0169ng c\u00f3 nh\u1eefng nh\u01b0\u1ee3c \u0111i\u1ec3m nh\u01b0 sau:<\/p>\n<ul>\n<li>D\u00f9ng Justify, b\u1ea1n ch\u1ec9 c\u00f3 g\u1ed9p c\u00e1c \u00f4 trong m\u1ed9t c\u1ed9t duy nh\u1ea5t.<\/li>\n<li>C\u00e1ch n\u00e0y ch\u1ec9 ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c \u00f4 ch\u1ee9a v\u0103n b\u1ea3n, \u00f4 ch\u1ee9a s\u1ed1 c\u0169ng nh\u01b0 c\u00f4ng th\u1ee9c kh\u00f4ng th\u1ec3 g\u1ed9p theo c\u00e1ch n\u00e0y.<\/li>\n<li>C\u00e1ch n\u00e0y s\u1ebd kh\u00f4ng th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c n\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 m\u1ed9t \u00f4 tr\u1ed1ng n\u00e0o n\u1eb1m gi\u1eefa c\u00e1c \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_2_Gop_nhieu_o_ma_van_giu_nguyen_du_lieu_su_dung_cong_cu_ngoai_Merge_Cells\"><\/span>C\u00e1ch 2. G\u1ed9p nhi\u1ec1u \u00f4 m\u00e0 v\u1eabn gi\u1eef nguy\u00ean d\u1eef li\u1ec7u s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 ngo\u00e0i Merge Cells<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4 trong Excel m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 <a href=\"https:\/\/www.ablebits.com\/excel-merge-cells\/index.php\">Merge Cells for Excel<\/a>.<\/p>\n<figure id=\"attachment_6319\" aria-describedby=\"caption-attachment-6319\" style=\"width: 287px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6319 size-full\" title=\"G\u1ed9p nhi\u1ec1u \u00f4\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cells-addin.png\" alt=\"G\u1ed9p nhi\u1ec1u \u00f4\" width=\"287\" height=\"118\"><figcaption id=\"caption-attachment-6319\" class=\"wp-caption-text\">G\u1ed9p nhi\u1ec1u \u00f4<\/figcaption><\/figure>\n<p>B\u1eb1ng c\u00e1ch d\u00f9ng c\u00f4ng c\u1ee5 ngo\u00e0i n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng g\u1ed9p nhi\u1ec1u \u00f4 ch\u1ee9a b\u1ea5t c\u1ee9 d\u1eef li\u1ec7u n\u00e0o, t\u1eeb ch\u1eef, s\u1ed1, ng\u00e0y th\u00e1ng cho \u0111\u1ebfn k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. B\u1ea1n c\u00f2n c\u00f3 th\u1ec3 ph\u00e2n t\u00e1ch nh\u1eefng th\u00f4ng tin sau khi g\u1ed9p b\u1eb1ng nh\u1eefng k\u00fd hi\u1ec7u nh\u01b0 d\u1ea5u ph\u1ea9y, kho\u1ea3ng c\u00e1ch, d\u1ea5u g\u1ea1ch ch\u00e9o hay d\u1ea5u g\u1ea1ch ngang.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 g\u1ed9p c\u00e1c \u00f4 theo \u0111\u00fang c\u00e1ch b\u1ea1n mu\u1ed1n, b\u1ea1n h\u00e3y t\u00ecm hi\u1ec3u nh\u1eefng l\u1ef1a ch\u1ecdn sau \u0111\u00e2y nh\u00e9:<\/p>\n<ul>\n<li>Ch\u1ecdn <strong>Cells into one<\/strong> \u1edf d\u01b0\u1edbi ph\u1ea7n <em>\u201cWhat to merge\u201d<\/em>.<\/li>\n<li>Ch\u1ecdn nh\u1eefng k\u00fd hi\u1ec7u ph\u00e2n t\u00e1ch th\u00f4ng tin d\u01b0\u1edbi ph\u1ea7n <em>\u201cSeparate values with\u201d<\/em>.<\/li>\n<li>Ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n ch\u1ee9a th\u00f4ng tin cu\u1ed1i c\u00f9ng: \u00f4 tr\u00ean c\u00f9ng b\u00ean ph\u1ea3i, \u00f4 tr\u00ean c\u00f9ng b\u00ean tr\u00e1i, \u00f4 d\u01b0\u1edbi c\u00f9ng b\u00ean ph\u1ea3i ho\u1eb7c \u00f4 d\u01b0\u1edbi c\u00f9ng b\u00ean tr\u00e1i.<\/li>\n<li>H\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng \u00f4 <strong>Merge all areas in the selection<\/strong> \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn. N\u1ebfu \u00f4 n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c ch\u1ecdn, c\u00f4ng c\u1ee5 n\u00e0y s\u1ebd \u0111\u00f3ng vai tr\u00f2 nh\u01b0 ch\u1ee9c n\u0103ng CONCATENATE, ngh\u0129a l\u00e0 g\u1ed9p c\u00e1c th\u00f4ng tin d\u1eef li\u1ec7u v\u00e0o m\u1ed9t \u00f4 m\u00e0 kh\u00f4ng g\u1ed9p c\u00e1c \u00f4 ch\u1ee9a th\u00f4ng tin \u0111\u00f3.<\/li>\n<\/ul>\n<figure id=\"attachment_6321\" aria-describedby=\"caption-attachment-6321\" style=\"width: 276px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6321 size-medium\" title=\"Cells into one\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/merge-cells-separate-values-276x300-1.png\" alt=\"Cells into one\" width=\"276\" height=\"300\"><figcaption id=\"caption-attachment-6321\" class=\"wp-caption-text\">Cells into one<\/figcaption><\/figure>\n<p>Ngo\u00e0i vi\u1ec7c g\u1ed9p c\u00e1c \u00f4, c\u00f4ng c\u1ee5 n\u00e0y c\u00f2n gi\u00fap b\u1ea1n g\u1ed9p c\u00e1c c\u1ed9t v\u00e0 h\u00e0ng m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, b\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn trong danh s\u00e1ch \u1edf ph\u1ea7n <em>\u201cWhat to merge\u201d<\/em>.<\/p>\n<p>C\u00f4ng c\u1ee5 n\u00e0y ph\u00f9 h\u1ee3p v\u1edbi c\u1ea3 Excel 2016, 2013, 2010, 2007 v\u00e0 2003.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_3_Dung_chuc_nang_CONCATENATE_de_gop_nhieu_o\"><\/span>C\u00e1ch 3. D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE \u0111\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u1eefng ai \u0111\u00e3 quen thu\u1ed9c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c c\u1ee7a <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel c\u01a1 b\u1ea3n<\/a> th\u00ec s\u1ebd th\u1ea5y h\u1ee9ng th\u00fa v\u1edbi c\u00e1ch g\u1ed9p \u00f4 n\u00e0y. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng CONCATENATE \u0111\u1ec3 g\u1ed9p c\u00e1c th\u00f4ng tin v\u00e0o m\u1ed9t \u00f4 tr\u01b0\u1edbc, sau \u0111\u00f3 m\u1edbi g\u1ed9p c\u00e1c \u00f4.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n g\u1ed9p \u00f4 A2 v\u00e0 B2 trong Excel, c\u1ea3 hai \u00f4 n\u00e0y \u0111\u1ec1u ch\u1ee9a d\u1eef li\u1ec7u. \u0110\u1ec3 kh\u00f4ng b\u1ecb m\u1ea5t d\u1eef li\u1ec7u trong \u00f4 th\u1ee9 2 khi g\u1ed9p, b\u1ea1n h\u00e3y g\u1ed9p d\u1eef li\u1ec7u c\u1ee7a ch\u00fang b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t trong 2 c\u00f4ng th\u1ee9c sau:<br \/>\n=CONCATENATE(A2,\u201d, \u201c,B2)<\/p>\n<p>=A2&amp;\u201d, \u201c&amp;B2<\/p>\n<figure id=\"attachment_6309\" aria-describedby=\"caption-attachment-6309\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6309 size-medium\" title=\"D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-concatenate-combine-cells-300x86-1.png\" alt=\"D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE\" width=\"300\" height=\"86\"><figcaption id=\"caption-attachment-6309\" class=\"wp-caption-text\"><em>D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE<\/em><\/figcaption><\/figure>\n<p>C\u00f4ng th\u1ee9c n\u00e0y tuy nhi\u00ean s\u1ebd t\u1eadp h\u1ee3p c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c g\u1ed9p v\u00e0o m\u1ed9t \u00f4 ri\u00eang bi\u1ec7t (D2). N\u1ebfu b\u1ea1n c\u1ea7n g\u1ed9p hai \u00f4 (A2 v\u00e0 B2) v\u1edbi th\u00f4ng tin g\u1ed1c, b\u1ea1n s\u1ebd c\u1ea7n l\u00e0m th\u00eam m\u1ed9t v\u00e0i b\u01b0\u1edbc sau:<\/p>\n<ul>\n<li>Copy \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c CONCATENATE (D2)<\/li>\n<li>Paste (d\u00e1n) c\u00f4ng th\u1ee9c v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean tr\u00ean c\u00f9ng b\u00ean tr\u00e1i c\u1ee7a d\u00e3y \u00f4 b\u1ea1n mu\u1ed1n g\u1ed9p (A2). \u0110\u1ec3 l\u00e0m v\u1eady, b\u1ea1n h\u00e3y ch\u1ecdn A2, click chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 v\u00e0 ch\u1ecdn <em>Paste Special &gt; Values<\/em>.<\/li>\n<li>Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n g\u1ed9p (A2 v\u00e0 B2) sau \u0111\u00f3 click <em>Merge and Center<\/em>.<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 g\u1ed9p nhi\u1ec1u \u00f4 trong Excel m\u00e0 v\u1eabn gi\u1eef nguy\u00ean d\u1eef li\u1ec7u, c\u00f4ng th\u1ee9c CONCATENATE ch\u1ec9 d\u00e0i h\u01a1n m\u1ed9t ch\u00fat th\u00f4i. \u01afu \u0111i\u1ec3m c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ph\u00e2n t\u00e1ch c\u00e1c th\u00f4ng tin \u0111\u01b0\u1ee3c g\u1ed9p b\u1eb1ng c\u00e1c d\u1ea5u ch\u1ec9 trong m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t, v\u00ed d\u1ee5:<br \/>\n=CONCATENATE(A2, \u201c: \u201c, B2, \u201c, \u201c, C2)<\/p>\n<figure id=\"attachment_6310\" aria-describedby=\"caption-attachment-6310\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6310 size-medium\" title=\"D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-concatenate-different-delimiters-300x82-1.png\" alt=\"D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE 1\" width=\"300\" height=\"82\"><figcaption id=\"caption-attachment-6310\" class=\"wp-caption-text\">D\u00f9ng ch\u1ee9c n\u0103ng CONCATENATE 1<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cac_phim_tat_de_gop_o_trong_Excel\"><\/span>C\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 g\u1ed9p \u00f4 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu b\u1ea1n g\u1ed9p \u00f4 trong Excel hay g\u1ed9p c\u1ed9t trong excel v\u1edbi c\u00e1ch th\u00f4ng th\u01b0\u1eddng, b\u1ea1n c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng nh\u1eefng ph\u00edm t\u1eaft d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p>1. Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n g\u1ed9p.<br \/>\n2. Nh\u1ea5n ph\u00edm <em><strong>Alt<\/strong><\/em> \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111i\u1ec1u khi\u1ec3n thanh c\u00f4ng c\u1ee5 tr\u00ean Excel v\u00e0 h\u00e3y gi\u1eef ph\u00edm cho \u0111\u1ebfn khi m\u1ed9t d\u00e3y ch\u1eef t\u1eaft hi\u1ec7n l\u00ean.<br \/>\n3. Nh\u1ea5n ph\u00edm <em><strong>H<\/strong><\/em> \u0111\u1ec3 s\u1eed d\u1ee5ng tab Home.<br \/>\n4. Ch\u1ecdn ph\u00edm <em><strong>M<\/strong><\/em> \u0111\u1ec3 s\u1eed d\u1ee5ng Merge &amp; Center.<br \/>\n5. Nh\u1ea5n m\u1ed9t trong c\u00e1c ph\u00edm sau \u0111\u00e2y:<br \/>\n\u2013 <em><strong>C<\/strong><\/em> \u0111\u1ec3 g\u1ed9p v\u00e0 c\u0103n l\u1ec1 ch\u00ednh gi\u1eefa cho c\u00e1c \u00f4<br \/>\n\u2013 <em><strong>A<\/strong><\/em> \u0111\u1ec3 g\u1ed9p c\u00e1c \u00f4 theo t\u1eebng h\u00e0ng ri\u00eang bi\u1ec7t<br \/>\n\u2013 <em><strong>M<\/strong><\/em> \u0111\u1ec3 g\u1ed9p \u00f4 m\u00e0 kh\u00f4ng c\u0103n l\u1ec1 ch\u00ednh gi\u1eefa<\/p>\n<figure id=\"attachment_6322\" aria-describedby=\"caption-attachment-6322\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6322 size-medium\" title=\"C\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 g\u1ed9p \u00f4 trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/shortcut-merge-cells-excel-300x179-1.png\" alt=\"C\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 g\u1ed9p \u00f4 trong Excel\" width=\"300\" height=\"179\"><figcaption id=\"caption-attachment-6322\" class=\"wp-caption-text\">C\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 g\u1ed9p \u00f4 trong Excel<\/figcaption><\/figure>\n<p>\u0110\u1ea7u ti\u00ean, vi\u1ec7c s\u1eed d\u1ee5ng ph\u00edm t\u1eaft c\u00f3 th\u1ec3 khi\u1ebfn b\u1ea1n th\u1ea5y b\u1ed1i r\u1ed1i, nh\u01b0ng ch\u1ec9 c\u1ea7n luy\u1ec7n t\u1eadp m\u1ed9t ch\u00fat, b\u1ea1n s\u1ebd th\u1ea5y \u0111\u00e2y l\u00e0 c\u00e1ch \u0111\u1ec3 g\u1ed9p \u00f4 nhanh h\u01a1n thay v\u00ec d\u00f9ng chu\u1ed9t.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_nhanh_chong_tim_duoc_cac_o_da_gop\"><\/span>C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u00ecm ra c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p trong trang t\u00ednh Excel, b\u1ea1n h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc d\u01b0\u1edbi \u0111\u00e2y:<br \/>\n1. Ch\u1ecdn <em><strong>Ctrl + F<\/strong> <\/em>\u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i <strong>Find and Replace<\/strong>, ho\u1eb7c ch\u1ecdn <em>Find &amp; Select &gt; Find<\/em>.<br \/>\n2. \u1ede thanh <strong><em>Find<\/em>,<\/strong> ch\u1ecdn <strong><em>Options &gt; Format.<\/em><\/strong><\/p>\n<figure id=\"attachment_6311\" aria-describedby=\"caption-attachment-6311\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6311 size-medium\" title=\"C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-find-format-300x160-1.png\" alt=\"C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p\" width=\"300\" height=\"160\"><figcaption id=\"caption-attachment-6311\" class=\"wp-caption-text\">C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p<\/figcaption><\/figure>\n<p style=\"text-align: left\">3. \u1ede tab <em>Alignment<\/em>, b\u1ea1n h\u00e3y tick v\u00e0o \u00f4 <strong>Merge Cells<\/strong> \u1edf d\u01b0\u1edbi ph\u1ea7n <em>Text Control<\/em> v\u00e0 nh\u1ea5n <em>OK<\/em>.<\/p>\n<figure id=\"attachment_6305\" aria-describedby=\"caption-attachment-6305\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6305 size-medium\" title=\"C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/alignment-merged-cells-300x210-1.png\" alt=\"C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p 1\" width=\"300\" height=\"210\"><figcaption id=\"caption-attachment-6305\" class=\"wp-caption-text\">C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p 1<\/figcaption><\/figure>\n<p style=\"text-align: left\">4. Cu\u1ed1i c\u00f9ng, b\u1ea1n h\u00e3y ch\u1ecdn <strong>Find Next<\/strong> \u0111\u1ec3 ch\u1ecdn \u00f4 b\u1ecb g\u1ed9p g\u1ea7n nh\u1ea5t, ho\u1eb7c ch\u1ecdn <strong>Find All<\/strong> \u0111\u1ec3 t\u00ecm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ecb g\u1ed9p. N\u1ebfu b\u1ea1n ch\u1ecdn ph\u01b0\u01a1ng ph\u00e1p sau, Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c \u00f4 b\u1ecb g\u1ed9p v\u00e0 gi\u00fap b\u1ea1n di chuy\u1ec3n gi\u1eefa c\u00e1c \u00f4 \u0111\u00f3 b\u1eb1ng c\u00e1ch ch\u1ecdn t\u1eebng \u00f4 trong danh s\u00e1ch n\u00e0y.<\/p>\n<figure id=\"attachment_6318\" aria-describedby=\"caption-attachment-6318\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6318 size-medium\" title=\"C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p 2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-merged-cells-excel-300x247-1.png\" alt=\"C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p 2\" width=\"300\" height=\"247\"><figcaption id=\"caption-attachment-6318\" class=\"wp-caption-text\">C\u00e1ch nhanh ch\u00f3ng t\u00ecm \u0111\u01b0\u1ee3c c\u00e1c \u00f4 \u0111\u00e3 g\u1ed9p 2<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tach_o_da_gop_trong_Excel\"><\/span>C\u00e1ch t\u00e1ch \u00f4 \u0111\u00e3 g\u1ed9p trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi \u0111\u00e3 g\u1ed9p \u00f4, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00e1ch ch\u00fang ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm t\u1eaft <code class=\"excel-formula-inline\"><em><strong>Ctrl + Z<\/strong><\/em><\/code> ho\u1eb7c click v\u00e0o ph\u00edm Undo tr\u00ean thanh Quick Access (ch\u1ec9 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c khi b\u1ea1n t\u00e1ch \u00f4 ngay sau khi g\u1ed9p \u00f4).<\/p>\n<p>M\u1ed9t c\u00e1ch n\u1eefa b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n l\u00e0 ch\u1ecdn \u00f4 \u0111\u00e3 g\u1ed9p, v\u00e0o ph\u1ea7n <em>Merge &amp; Center<\/em> ho\u1eb7c click v\u00e0o m\u0169i t\u00ean nh\u1ecf ngay c\u1ea1nh \u0111\u00f3 v\u00e0 ch\u1ecdn <strong>Unmerge Cells:<\/strong><\/p>\n<figure id=\"attachment_6317\" aria-describedby=\"caption-attachment-6317\" style=\"width: 143px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6317 size-full\" title=\"C\u00e1ch t\u00e1ch \u00f4 \u0111\u00e3 g\u1ed9p trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-unmerge-cells.png\" alt=\"C\u00e1ch t\u00e1ch \u00f4 \u0111\u00e3 g\u1ed9p trong Excel\" width=\"143\" height=\"123\"><figcaption id=\"caption-attachment-6317\" class=\"wp-caption-text\">C\u00e1ch t\u00e1ch \u00f4 \u0111\u00e3 g\u1ed9p trong Excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cac_cach_thay_the_viec_gop_o_trong_Excel\"><\/span>C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c g\u1ed9p \u00f4 c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n tr\u00ecnh b\u00e0y th\u00f4ng tin trong Excel nh\u01b0ng c\u0169ng c\u00f3 nh\u1eefng b\u1ea5t l\u1ee3i nh\u1ea5t \u0111\u1ecbnh:<\/p>\n<ul>\n<li>B\u1ea1n kh\u00f4ng th\u1ec3 ph\u00e2n lo\u1ea1i (sort) trong m\u1ed9t c\u1ed9t c\u00f3 ch\u1ee9a \u00f4 \u0111\u00e3 g\u1ed9p.<\/li>\n<li>Auto Fill hay Fill Flash s\u1ebd kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c n\u1ebfu trong v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n ch\u1ecdn c\u00f3 \u00f4 \u0111\u00e3 g\u1ed9p.<\/li>\n<li>B\u1ea1n kh\u00f4ng th\u1ec3 \u0111\u1ed5i m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a \u00f4 g\u1ed9p th\u00e0nh b\u1ea3ng Excel.<\/li>\n<\/ul>\n<p>V\u00ec v\u1eady, h\u00e3y suy t\u00ednh k\u1ef9 tr\u01b0\u1edbc khi b\u1ea1n g\u1ed9p \u00f4 trong Excel v\u00e0 ch\u1ec9 l\u00e0m khi b\u1ea1n th\u1ea5y th\u1ef1c s\u1ef1 c\u1ea7n thi\u1ebft.<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n g\u1ed9p nh\u1eefng \u00f4 c\u00f3 v\u1ecb tr\u00ed \u1edf gi\u1eefa trang t\u00ednh Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng <strong>Center Across Selection<\/strong> \u0111\u1ec3 thay th\u1ebf:<\/p>\n<ul>\n<li>Ch\u1ecdn \u00f4 b\u1ea1n mu\u1ed1n g\u1ed9p, trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 B4 v\u00e0 C4.<\/li>\n<li>Nh\u1ea5n <code class=\"excel-formula-inline\"><em><strong>Ctrl + 1<\/strong><\/em><\/code> \u0111\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i Format Cells.<\/li>\n<li>T\u1ea1i tab <strong><em>Alignment<\/em><\/strong>, ch\u1ecdn <code class=\"excel-formula-inline\"><strong>Center Across Selection<\/strong><\/code> \u1edf danh s\u00e1ch <em>Horizontal<\/em>, sau \u0111\u00f3 nh\u1ea5n OK.<\/li>\n<\/ul>\n<figure id=\"attachment_6306\" aria-describedby=\"caption-attachment-6306\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6306 size-medium\" title=\"C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/center-across-selection-300x285-1.png\" alt=\"C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel\" width=\"300\" height=\"285\"><figcaption id=\"caption-attachment-6306\" class=\"wp-caption-text\">C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel<\/figcaption><\/figure>\n<p>K\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 sau, c\u00f3 th\u1ec3 th\u1ea5y tr\u00f4ng ch\u00fang kh\u00f4ng kh\u00e1c g\u00ec l\u00e0 hai \u00f4 \u0111\u00e3 b\u1ecb g\u1ed9p:<\/p>\n<figure id=\"attachment_6307\" aria-describedby=\"caption-attachment-6307\" style=\"width: 270px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6307 size-full\" title=\"C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel 1\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/center-across-selection-result.png\" alt=\"C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel 1\" width=\"270\" height=\"120\"><figcaption id=\"caption-attachment-6307\" class=\"wp-caption-text\">C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel 1<\/figcaption><\/figure>\n<p>Nh\u01b0ng th\u1ef1c t\u1ebf, ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 ch\u1ecdn \u00f4 B4 v\u00e0 C4 m\u1ed9t c\u00e1ch ri\u00eang bi\u1ec7t:<\/p>\n<figure id=\"attachment_6308\" aria-describedby=\"caption-attachment-6308\" style=\"width: 272px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6308 size-full\" title=\"C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel 2\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/center-across-selection-result2.png\" alt=\"C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel 2\" width=\"272\" height=\"120\"><figcaption id=\"caption-attachment-6308\" class=\"wp-caption-text\">C\u00e1c c\u00e1ch thay th\u1ebf vi\u1ec7c g\u1ed9p \u00f4 trong Excel 2<\/figcaption><\/figure>\n<p>Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 g\u1ed9p c\u00e1c \u00f4 trong Excel v\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n \u0111\u1ec3 kh\u00f4ng l\u00e0m m\u1ea5t d\u1eef li\u1ec7u trong c\u00e1c \u00f4. Hy v\u1ecdng ch\u00fang s\u1ebd h\u1eefu \u00edch cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n v\u1edbi Excel. C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 d\u00e0nh th\u1eddi gian v\u00e0 h\u1eb9n g\u1eb7p b\u1ea1n trong c\u00e1c b\u00e0i vi\u1ebft ti\u1ebfp theo.<\/p>\n<p>Nh\u1eefng ki\u1ebfn th\u1ee9c b\u1ea1n \u0111ang xem thu\u1ed9c kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao c\u1ee7a H\u1ecdc Excel Online<\/a>. Kh\u00f3a h\u1ecdc n\u00e0y cung c\u1ea5p cho b\u1ea1n ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7 v\u00e0 c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong excel, \u1ee9ng d\u1ee5ng excel trong c\u00f4ng vi\u1ec7c\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc n\u00e0y.\u00a0H\u00e3y tham gia ngay t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-99.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3094,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3093","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3093","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3093"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3093\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3094"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}