{"id":764,"date":"2024-12-02T02:47:52","date_gmt":"2024-12-02T02:47:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-an-va-gop-cot-trong-excel-2010-2013-2016\/"},"modified":"2024-12-02T02:47:52","modified_gmt":"2024-12-02T02:47:52","slug":"cach-an-va-gop-cot-trong-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-an-va-gop-cot-trong-excel-2010-2013-2016\/","title":{"rendered":"C\u00e1ch \u1ea9n v\u00e0 g\u1ed9p c\u1ed9t trong Excel 2010, 2013, 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn <strong>c\u00e1ch \u1ea9n c\u1ed9t<\/strong> trong Excel 2010-2013, 2016. B\u1ea1n s\u1ebd nhanh ch\u00f3ng hi\u1ec3u ch\u1ee9c n\u0103ng \u1ea9n c\u1ed9t c\u0169ng nh\u01b0 t\u00ecm hi\u1ec3u c\u00e1ch g\u1ed9p v\u00e0 b\u1ecf g\u1ed9p c\u1ed9t v\u1edbi Outline.<\/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-674d1fd7775c3\" 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-va-gop-cot-trong-excel-2010-2013-2016.html#Excel_%E2%80%93_An_cac_cot_da_chon\" title=\"Excel \u2013 \u1ea8n c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn\">Excel \u2013 \u1ea8n c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-va-gop-cot-trong-excel-2010-2013-2016.html#Su_dung_tuy_chon_Group_de_an_va_hien_thi_cac_cot\" title=\"S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Group \u0111\u1ec3 \u1ea9n v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c c\u1ed9t\">S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Group \u0111\u1ec3 \u1ea9n v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c c\u1ed9t<\/a><\/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-va-gop-cot-trong-excel-2010-2013-2016.html#Cach_giau_%E2%80%93_tang_hinh_du_lieu_trong_Excel\" title=\"C\u00e1ch gi\u1ea5u \u2013 t\u00e0ng h\u00ecnh d\u1eef li\u1ec7u trong Excel\">C\u00e1ch gi\u1ea5u \u2013 t\u00e0ng h\u00ecnh d\u1eef li\u1ec7u 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-4\" href=\"https:\/\/blog.hocexcel.online\/cach-va-gop-cot-trong-excel-2010-2013-2016.html#Cach_thu_1_dinh_dang_mau_chu_trung_mau_nen\" title=\"C\u00e1ch th\u1ee9 1:\u00a0\u0111\u1ecbnh d\u1ea1ng m\u00e0u ch\u1eef\u00a0tr\u00f9ng m\u00e0u n\u1ec1n\">C\u00e1ch th\u1ee9 1:\u00a0\u0111\u1ecbnh d\u1ea1ng m\u00e0u ch\u1eef\u00a0tr\u00f9ng m\u00e0u n\u1ec1n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-va-gop-cot-trong-excel-2010-2013-2016.html#Cach_thu_2_dinh_dang_trong_Custome_format\" title=\"C\u00e1ch th\u1ee9 2:\u00a0\u0111\u1ecbnh d\u1ea1ng trong Custome format\">C\u00e1ch th\u1ee9 2:\u00a0\u0111\u1ecbnh d\u1ea1ng trong Custome format<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Excel_%E2%80%93_An_cac_cot_da_chon\"><\/span><strong>Excel \u2013 \u1ea8n c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u1ea9n m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t trong trang t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u00e0m nh\u01b0 sau<\/p>\n<p style=\"text-align: justify\">1. M\u1edf trang t\u00ednh v\u00e0 ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t b\u1ea1n mu\u1ed1n \u1ea9n.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nh\u1eefng c\u1ed9t kh\u00f4ng li\u1ec1n nhau b\u1eb1ng c\u00e1ch gi\u1eef ph\u00edm Ctrl.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5p chu\u1ed9t ph\u1ea3i t\u1ea1i m\u1ed9t trong c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn v\u00e0 ch\u1ecdn <strong><em>Hide<\/em><\/strong>.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-36.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4541 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-36.bmp\" width=\"442\" height=\"324\" title=\"new-bitmap-image-2-36\"><\/a><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>: Ph\u00edm t\u1eaft cho thao t\u00e1c n\u00e0y l\u00e0 : <em><strong>Ctrl+0<\/strong><\/em>.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_tuy_chon_Group_de_an_va_hien_thi_cac_cot\"><\/span><strong>S\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn Group \u0111\u1ec3 \u1ea9n v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c c\u1ed9t<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u1ea8n c\u1ed9t l\u00e0 m\u1ed9t vi\u1ec7c l\u00e0m ph\u1ed5 bi\u1ebfn khi d\u00f9ng Excel. B\u1ea1n c\u00f3 bao gi\u1edd ngh\u0129 ch\u1ee9c n\u0103ng Group c\u1ee7a Excel nh\u01b0 l\u00e0 m\u1ed9t c\u00e1ch \u0111\u1ec3 \u1ea9n v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c c\u1ed9t? Tr\u00ean th\u1ef1c t\u1ebf, n\u00f3 l\u00e0m cho qu\u00e1 tr\u00ecnh n\u00e0y \u0111\u01a1n gi\u1ea3n h\u01a1n nhi\u1ec1u. N\u00f3 th\u1ef1c s\u1ef1 h\u1eefu \u00edch n\u1ebfu b\u1ea1n c\u1ea7n c\u00e1c c\u1ed9t kh\u00f4ng li\u1ec1n k\u1ec1 \u1edf k\u1ebf nhau.<\/p>\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-42.gif\" title=\"ex101_92019-nho-42\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Khi b\u1ea1n nh\u00f3m c\u00e1c c\u1ed9t, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng nh\u1ecf \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o trong l\u01b0\u1edbi Excel. Ch\u00fang cho ph\u00e9p b\u1ea1n \u1ea9n v\u00e0 b\u1ecf \u1ea9n d\u1eef li\u1ec7u nhanh ch\u00f3ng. C\u00e1c bi\u1ec3u t\u01b0\u1ee3ng n\u00e0y c\u0169ng hi\u1ec3n th\u1ecb cho b\u1ea1n c\u1ed9t n\u00e0o \u0111\u00e3 \u1ea9n v\u00e0 c\u00e1i n\u00e0o c\u00f3 th\u1ec3 \u1ea9n.<\/p>\n<p style=\"text-align: justify\">1. Ch\u1ecdn b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5n <em><strong>Shift + Alt + m\u0169i t\u00ean ph\u1ea3i<\/strong><\/em>.<\/p>\n<p style=\"text-align: justify\">3. B\u1ea1n s\u1ebd th\u1ea5y h\u1ed9p tho\u1ea1i Group xu\u1ea5t hi\u1ec7n. Ch\u1ecdn <em><strong>Columns<\/strong><\/em> v\u00e0 nh\u1ea5p OK \u0111\u1ec3 x\u00e1c nh\u1eadn.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-37.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4542 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-37.bmp\" width=\"188\" height=\"145\" title=\"new-bitmap-image-2-37\"><\/a><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:<\/strong> B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 m\u1edf h\u1ed9p tho\u1ea1i tr\u00ean b\u1eb1ng c\u00e1ch ch\u1ecdn <em><strong>Data -&gt; Group -&gt; Group<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-38.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4543 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-38.bmp\" width=\"291\" height=\"131\" title=\"new-bitmap-image-2-38\"><\/a><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:<\/strong> B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u v\u00e0 nh\u1ea5n Shift + Alt + m\u0169i t\u00ean tr\u00e1i \u0111\u1ec3 b\u1ecf nh\u00f3m.<\/p>\n<p style=\"text-align: justify\">Thao t\u00e1c n\u00e0y s\u1ebd th\u00eam c\u00e1c k\u00fd hi\u1ec7u Outline \u0111\u1eb7c bi\u1ec7t v\u00e0o b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-39.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4544 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-39.bmp\" width=\"600\" height=\"155\" title=\"new-bitmap-image-2-39\"><\/a><\/p>\n<p style=\"text-align: justify\">4. B\u00e2y gi\u1edd h\u00e3y ch\u1ecdn c\u00e1c c\u1ed9t b\u1ea1n mu\u1ed1n \u1ea9n t\u1eebng c\u00e1i m\u1ed9t v\u00e0 nh\u1ea5n Shift + Alt + m\u0169i t\u00ean ph\u1ea3i cho t\u1eebng c\u1ed9t.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:<\/strong>\u00a0Kh\u00f4ng th\u1ec3 ch\u1ecdn c\u1ed9t kh\u00f4ng li\u1ec1n k\u1ec1<\/p>\n<p style=\"text-align: justify\">Ngay khi b\u1ea1n nh\u1ea5n ph\u00edm t\u1eaft, b\u1ea1n s\u1ebd th\u1ea5y bi\u1ec3u t\u01b0\u1ee3ng \u201c-\u201c \u00a0\u0111\u01b0\u1ee3c th\u00eam v\u00e0o ph\u00eda tr\u00ean c\u00e1c c\u1ed9t \u0111\u00e3 ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-40.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4545 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-40.bmp\" width=\"600\" height=\"183\" title=\"new-bitmap-image-2-40\"><\/a><\/p>\n<p style=\"text-align: justify\">5. Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u201c-\u201c s\u1ebd \u1ea9n c\u1ed9t v\u00e0 bi\u1ec3u t\u01b0\u1ee3ng s\u1ebd thay \u0111\u1ed5i sang \u201c+\u201d cho ph\u00e9p b\u1ea1n b\u1ecf \u1ea9n d\u1eef li\u1ec7u.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-41.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4546 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-41.bmp\" width=\"438\" height=\"188\" title=\"new-bitmap-image-2-41\"><\/a><\/p>\n<p style=\"text-align: justify\">6. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c con s\u1ed1 nh\u1ecf \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean tr\u00e1i. Ch\u00fang cho ph\u00e9p b\u1ea1n \u1ea9n v\u00e0 b\u1ecf \u1ea9n t\u1ea5t c\u1ea3 c\u00e1c nh\u00f3m <a href=\"http:\/\/online-pharmacy.org\/supplements\/ashwagandha-stress-anxiety-reducing-ayurvedic-herb\/\">http:\/\/online-pharmacy.org<\/a> c\u00f9ng c\u1ea5p ngay l\u1eadp t\u1ee9c. V\u00ed d\u1ee5: trong b\u1ea3ng trong h\u00ecnh, nh\u1ea5p v\u00e0o 1 s\u1ebd \u1ea9n to\u00e0n b\u1ed9 b\u1ea3ng v\u00e0 nh\u1ea5p v\u00e0o 2 s\u1ebd \u1ea9n c\u1ed9t C v\u00e0 E. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch n\u1ebfu b\u1ea1n c\u1ea7n t\u1ea1o ph\u00e2n c\u1ea5p c\u1ee7a nh\u00f3m.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/04\/New-Bitmap-Image-2-42.bmp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4547 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-bitmap-image-2-42.bmp\" width=\"438\" height=\"188\" title=\"new-bitmap-image-2-42\"><\/a><\/p>\n<p><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_giau_%E2%80%93_tang_hinh_du_lieu_trong_Excel\"><\/span>C\u00e1ch gi\u1ea5u \u2013 t\u00e0ng h\u00ecnh d\u1eef li\u1ec7u trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1eady c\u00f2n n\u1ebfu nh\u01b0 b\u1ea1n v\u1eabn mu\u1ed1n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u201ct\u00e0ng h\u00ecnh\u201d m\u00e0 kh\u00f4ng ph\u1ea3i \u1ea9n c\u1ed9t th\u00ec sao? T\u00e0ng h\u00ecnh ch\u00ednh l\u00e0 vi\u1ec7c d\u1eef li\u1ec7u v\u1eabn t\u1ed3n t\u1ea1i trong\u00a0\u00f4, kh\u00f4ng h\u1ec1 b\u1ecb\u00a0\u1ea9n m\u00e0\u00a0\u0111\u01b0\u1ee3c thay\u00a0\u0111\u1ed5i c\u00e1ch\u00a0\u0111\u1ecbnh d\u1ea1ng\u00a0\u0111\u1ec3 kh\u00f4ng nh\u00ecn th\u1ea5y b\u1eb1ng m\u1eaft th\u01b0\u1eddng\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_1_dinh_dang_mau_chu_trung_mau_nen\"><\/span>C\u00e1ch th\u1ee9 1:\u00a0\u0111\u1ecbnh d\u1ea1ng m\u00e0u ch\u1eef\u00a0tr\u00f9ng m\u00e0u n\u1ec1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24161\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/to-mau-du-lieu-cung-mau-nen.png\" width=\"485\" height=\"202\" title=\"to-mau-du-lieu-cung-mau-nen\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean, ch\u00fang ta th\u1ea5y t\u1ea1i\u00a0\u00f4 A2:<\/p>\n<ul>\n<li>C\u00f3 n\u1ed9i dung l\u00e0 H\u1ecdc\u00a0Excel Online<\/li>\n<li>\u0110\u01b0\u1ee3c t\u00f4 m\u00e0u ch\u1eef l\u00e0 m\u00e0u tr\u1eafng (c\u00f9ng m\u00e0u v\u1edbi m\u00e0u n\u1ec1n)<\/li>\n<\/ul>\n<p>Tuy nhi\u00ean k\u1ebft qu\u1ea3 t\u1ea1i\u00a0\u00f4 A2 n\u1ebfu nh\u00ecn b\u1eb1ng m\u1eaft th\u01b0\u1eddng s\u1ebd th\u1ea5y nh\u01b0 kh\u00f4ng c\u00f3 n\u1ed9i dung g\u00ec. Ph\u1ea3i nh\u00ecn t\u1ea1i thanh Formula Bar m\u1edbi th\u1ea5y gi\u00e1 tr\u1ecb c\u1ee7a\u00a0\u00f4 A2.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_2_dinh_dang_trong_Custome_format\"><\/span>C\u00e1ch th\u1ee9 2:\u00a0\u0111\u1ecbnh d\u1ea1ng trong Custome format<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24162\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dinh-dang-an-du-lieu-voi-custome-format.png\" width=\"911\" height=\"481\" title=\"dinh-dang-an-du-lieu-voi-custome-format\"><\/p>\n<p>Trong c\u00e1ch l\u00e0m n\u00e0y, ch\u00fang ta th\u1ea5y d\u1eef li\u1ec7u trong\u00a0\u00f4 A2 v\u1eabn kh\u00f4ng hi\u1ec3n th\u1ecb d\u00f9 m\u00e0u ch\u1eef l\u00e0 m\u00e0u\u00a0\u0111en.\u00a0\u0110\u00f3 l\u00e0 do t\u1ea1i\u00a0\u00f4 A2 ch\u00fang ta\u00a0\u0111\u00e3\u00a0\u0111\u1ecbnh d\u1ea1ng:<\/p>\n<ul>\n<li>Custom format<\/li>\n<li>Type: nh\u1eadp 3 d\u1ea5u ch\u1ea5m ph\u1ea9y li\u1ec1n nhau\u00a0(;)<\/li>\n<\/ul>\n<p>Khi\u00a0\u0111\u1ecbnh d\u1ea1ng 3 d\u1ea5u ch\u1ea5m ph\u1ea9y li\u1ec1n nhau,\u00a0Excel s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb b\u1ea5t k\u1ef3 n\u1ed9i dung n\u00e0o. V\u1ec1 b\u1ea3n ch\u1ea5t d\u1eef li\u1ec7u v\u1eabn t\u1ed3n t\u1ea1i trong\u00a0\u00f4, ch\u1ec9 l\u00e0 do c\u00e1ch\u00a0\u0111\u1ecbnh d\u1ea1ng khi\u1ebfn d\u1eef li\u1ec7u kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb\u00a0\u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y tr\u1ef1c ti\u1ebfp. N\u1ebfu nh\u00ecn v\u00e0o thanh Formula Bar s\u1ebd th\u1ea5y xu\u1ea5t hi\u1ec7n n\u1ed9i dung trong\u00a0\u00f4\u00a0\u0111\u00f3.<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-bao-vekhoa-cot-trong-excel.html\">C\u00e1ch b\u1ea3o v\u1ec7\/kh\u00f3a c\u1ed9t \u1ea9n trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-de-nhung-o-hang-cot-chua-su-dung-trong-excel.html\">C\u00e1ch \u0111\u1ec3 \u1ea9n nh\u1eefng \u00f4, h\u00e0ng, c\u1ed9t ch\u01b0a s\u1eed d\u1ee5ng trong Excel<\/a><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc\u00a0<strong><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a><\/strong>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Trong kh\u00f3a h\u1ecdc n\u00e0y c\u00e1c b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c t\u00ecm hi\u1ec3u nh\u1eefng ki\u1ebfn th\u1ee9c \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng v\u1ec1 c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, vi\u1ec7c \u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m, c\u00f4ng c\u1ee5 \u0111\u00f3 v\u00e0o trong c\u00f4ng vi\u1ec7c. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng c\u00f3 r\u1ea5t nhi\u1ec1u \u01b0u \u0111\u00e3i cho b\u1ea1n khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y<\/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\/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-42.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":765,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-764","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/764","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=764"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/765"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}