{"id":9505,"date":"2025-01-02T08:27:37","date_gmt":"2025-01-02T08:27:37","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri\/"},"modified":"2025-01-02T08:27:37","modified_gmt":"2025-01-02T08:27:37","slug":"huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ea9n gi\u1ea5u n\u1ed9i dung trong Excel m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t gi\u00e1 tr\u1ecb"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o ch\u00fang ta c\u0169ng mu\u1ed1n hi\u1ec3n th\u1ecb h\u1ebft n\u1ed9i dung tr\u00ean Excel. C\u00f3 nh\u1eefng l\u00fac ch\u00fang ta c\u1ea7n ph\u1ea3i \u1ea9n, gi\u1ea5u m\u1ed9t s\u1ed1 n\u1ed9i dung \u0111i \u0111\u1ec3 tr\u00e1nh b\u1ecb s\u1eeda, x\u00f3a ho\u1eb7c kh\u00f4ng mu\u1ed1n ng\u01b0\u1eddi kh\u00e1c nh\u00ecn th\u1ea5y. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 v\u1eeba \u1ea9n, gi\u1ea5u \u0111\u01b0\u1ee3c n\u1ed9i dung m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t \u0111i gi\u00e1 tr\u1ecb? C\u00f3 bao nhi\u00eau c\u00e1ch \u0111\u1ec3 <a href=\"http:\/\/blog.ezworkapp.com\/cach-va-gop-cot-trong-excel-2010-2013-2016.html\"><strong>\u1ea9n c\u1ed9t trong Excel<\/strong><\/a>? H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc\u00a0Excel Online<\/strong><\/a> nh\u00e9.<\/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-67764df8db0f1\" 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\/huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri.html#An_sheet_chua_dieu_kien\" title=\"\u1ea8n sheet ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n\">\u1ea8n sheet ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n<\/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\/huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri.html#An_dong_an_cot_chua_du_lieu_phu\" title=\"\u1ea8n d\u00f2ng,\u00a0\u1ea9n c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u ph\u1ee5\">\u1ea8n d\u00f2ng,\u00a0\u1ea9n c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u ph\u1ee5<\/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\/huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri.html#Lam_du_lieu_trong_o_tro_nen_%E2%80%9Ctang_hinh%E2%80%9D\" title=\"L\u00e0m d\u1eef li\u1ec7u trong\u00a0\u00f4 tr\u1edf n\u00ean \u201ct\u00e0ng h\u00ecnh\u201d\">L\u00e0m d\u1eef li\u1ec7u trong\u00a0\u00f4 tr\u1edf n\u00ean \u201ct\u00e0ng h\u00ecnh\u201d<\/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\/huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri.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\/huong-dan-cach-an-giau-noi-dung-trong-excel-ma-khong-lam-mat-gia-tri.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><span class=\"ez-toc-section\" id=\"An_sheet_chua_dieu_kien\"><\/span>\u1ea8n sheet ch\u1ee9a\u00a0\u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n ch\u1ec9 c\u1ea7n t\u1eadp trung c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n\u00a0\u1edf 1 sheet, sau\u00a0\u0111\u00f3\u00a0\u1ea9n sheet\u00a0\u0111\u00f3\u00a0\u0111i\u00a0\u0111\u1ec3 tr\u00e1nh ng\u01b0\u1eddi kh\u00e1c t\u1ef1\u00a0\u00fd s\u1eeda, x\u00f3a c\u00e1c n\u1ed9i dung n\u00e0y.<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24159\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/an-sheet-dieu-kien.png\" width=\"863\" height=\"331\" title=\"an-sheet-dieu-kien\"><\/p>\n<p>Trong 1\u00a0workbook c\u00f3 r\u1ea5t nhi\u1ec1u sheet, m\u1ed7i sheet l\u1ea1i c\u00f3 1 n\u1ed9i dung ri\u00eang. Nh\u01b0ng t\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung nh\u01b0 \u0111i\u1ec1u ki\u1ec7n, nh\u01b0 d\u1eef li\u1ec7u nh\u00e1p, ph\u1ee5\u2026 \u0111\u01b0\u1ee3c t\u1ea1o\u00a0\u1edf 1 v\u00f9ng d\u1eef li\u1ec7u kh\u00e1c t\u00e1ch bi\u1ec7t kh\u1ecfi d\u1eef li\u1ec7u ch\u00ednh s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t c\u1ea3 trong sheet DK. Khi ch\u00fang ta\u00a0\u1ea9n sheet DK\u00a0\u0111i th\u00ec c\u00e1c n\u1ed9i dung\u00a0\u0111\u00f3 v\u1eabn ho\u1ea1t\u00a0\u0111\u1ed9ng m\u00e0 kh\u00f4ng b\u1ecb nh\u00ecn th\u1ea5y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"An_dong_an_cot_chua_du_lieu_phu\"><\/span>\u1ea8n d\u00f2ng,\u00a0\u1ea9n c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u ph\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c c\u1ed9t d\u1eef li\u1ec7u ph\u1ee5, c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ee7a Advanced Filter m\u00e0 th\u01b0\u1eddng l\u00e0m tr\u1ef1c ti\u1ebfp trong b\u1ea3ng d\u1eef li\u1ec7u g\u1ed1c s\u1ebd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t t\u1ea1i nh\u1eefng v\u1ecb tr\u00ed d\u00f2ng, c\u1ed9t ri\u00eang bi\u1ec7t, c\u00f3 th\u1ec3\u00a0\u1ea9n\u00a0\u0111i khi kh\u00f4ng c\u1ea7n s\u1eed d\u1ee5ng\u00a0\u0111\u1ebfn.<\/p>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/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\/2025\/01\/ex101_92019-nho-61.gif\" title=\"ex101_92019-nho-61\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24160\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/an-column-dieu-kien-advfilter.png\" width=\"1228\" height=\"388\" title=\"an-column-dieu-kien-advfilter\"><\/p>\n<p>Trong b\u00e1o c\u00e1o chi ti\u1ebft tr\u00ean, ch\u00fang ta th\u1ea5y c\u00f3 s\u1eed d\u1ee5ng v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n t\u1ea1i c\u1ed9t G:J\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng advanced Filter. V\u00e0 v\u00f9ng\u00a0\u0111i\u1ec1u ki\u1ec7n n\u00e0y sau khi\u00a0\u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp xong s\u1ebd\u00a0\u1ea9n\u00a0\u0111i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_du_lieu_trong_o_tro_nen_%E2%80%9Ctang_hinh%E2%80%9D\"><\/span>L\u00e0m d\u1eef li\u1ec7u trong\u00a0\u00f4 tr\u1edf n\u00ean \u201ct\u00e0ng h\u00ecnh\u201d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>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\/2025\/01\/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\/2025\/01\/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>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft th\u00eam kh\u00e1 nhi\u1ec1u c\u00e1ch\u00a0\u0111\u1ec3\u00a0\u1ea9n, gi\u1ea5u d\u1eef li\u1ec7u t\u00f9y theo m\u1ee5c\u00a0\u0111ich khi l\u00e0m vi\u1ec7c. Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u00e1p d\u1ee5ng t\u1ed1t ki\u1ebfn th\u1ee9c n\u00e0y v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-du-lieu-su-dung-custom-format.html\">\u0110\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u s\u1eed d\u1ee5ng Custom Format<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-an-va-khoa-cong-thuc-trong-excel-2010-2013-2016.html\">C\u00e1ch \u1ea9n v\u00e0 kh\u00f3a c\u00f4ng th\u1ee9c trong Excel 2010, 2013, 2016<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-chuc-nang-khoa-va-bao-mat-trong-excel.html\">T\u00ecm hi\u1ec3u v\u1ec1 ch\u1ee9c n\u0103ng Kh\u00f3a v\u00e0 B\u1ea3o m\u1eadt trong Excel<\/a><\/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\/2025\/01\/ex101_92019-nho-61.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9506,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9505","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\/9505","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=9505"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9505\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9506"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}