{"id":5379,"date":"2024-12-16T02:09:24","date_gmt":"2024-12-16T02:09:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-sua-loi-excel-bi-an-dong-khong-unhide-duoc\/"},"modified":"2024-12-16T02:09:24","modified_gmt":"2024-12-16T02:09:24","slug":"huong-dan-cach-sua-loi-excel-bi-an-dong-khong-unhide-duoc","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-sua-loi-excel-bi-an-dong-khong-unhide-duoc\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eeda l\u1ed7i excel b\u1ecb \u1ea9n d\u00f2ng kh\u00f4ng unhide \u0111\u01b0\u1ee3c"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"filter-trong-excel-bi-an? cite=\">\n<p>\u0110\u00e3 khi n\u00e0o b\u1ea1n g\u1eb7p tr\u01b0\u1eddng h\u1ee3p trong file excel c\u00f3 d\u00f2ng b\u1ecb \u1ea9n m\u00e0 b\u1ea1n kh\u00f4ng th\u1ec3 m\u1edf \u1ea9n (unhide) \u0111\u01b0\u1ee3c kh\u00f4ng? \u0110\u00e2y c\u00f2n l\u1ea1i l\u00e0 tr\u01b0\u1eddng h\u1ee3p <strong>filter trong excel b\u1ecb \u1ea9n?<\/strong> T\u1ea1i sao l\u1ea1i x\u1ea3y ra tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau (t\u1ea3i file v\u00ed d\u1ee5 t\u1ea1i:\u00a0<a href=\"http:\/\/bit.ly\/2SaVb77\">http:\/\/bit.ly\/2SaVb77<\/a>)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24531\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vi-du-bang-du-lieu-an-dong-khong-unhide-duoc.png\" width=\"615\" height=\"168\" title=\"vi-du-bang-du-lieu-an-dong-khong-unhide-duoc\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u00e1c d\u00f2ng\u00a0\u0111\u00e3 b\u1ecb\u00a0\u1ea9n\u00a0\u0111i. Nh\u01b0ng khi ch\u1ecdn unhide c\u00e1c d\u00f2ng b\u1ecb\u00a0\u1ea9n th\u00ec kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 g\u00ec.<\/p>\n<p>C\u00e1ch s\u1eeda l\u1ed7i n\u00e0y nh\u01b0 th\u1ebf n\u00e0o?<\/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-675f8bd39c34f\" 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-sua-loi-excel-bi-dong-khong-unhide-duoc.html#Nguyen_nhan_bang_du_lieu_co_dong_an_khong_unhide_duoc\" title=\"Nguy\u00ean nh\u00e2n b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 d\u00f2ng\u00a0\u1ea9n kh\u00f4ng unhide\u00a0\u0111\u01b0\u1ee3c\">Nguy\u00ean nh\u00e2n b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 d\u00f2ng\u00a0\u1ea9n kh\u00f4ng unhide\u00a0\u0111\u01b0\u1ee3c<\/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-sua-loi-excel-bi-dong-khong-unhide-duoc.html#Cach_khac_phuc_loi_khong_unhide_duoc_dong_an\" title=\"C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i kh\u00f4ng unhide\u00a0\u0111\u01b0\u1ee3c d\u00f2ng\u00a0\u1ea9n\">C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i kh\u00f4ng unhide\u00a0\u0111\u01b0\u1ee3c d\u00f2ng\u00a0\u1ea9n<\/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-sua-loi-excel-bi-dong-khong-unhide-duoc.html#Loc_du_lieu_truc_tiep_trong_bang_voi_Advanced_Filter\" title=\"L\u1ecdc d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp trong b\u1ea3ng v\u1edbi Advanced Filter\">L\u1ecdc d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp trong b\u1ea3ng v\u1edbi Advanced Filter<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Nguyen_nhan_bang_du_lieu_co_dong_an_khong_unhide_duoc\"><\/span>Nguy\u00ean nh\u00e2n b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 d\u00f2ng\u00a0\u1ea9n kh\u00f4ng unhide\u00a0\u0111\u01b0\u1ee3c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi ch\u00fa\u00a0\u00fd v\u00e0o ph\u1ea7n s\u1ed1 d\u00f2ng m\u00e0u xanh, ch\u00fang ta nh\u1eadn th\u1ea5y\u00a0\u0111\u00e2y l\u00e0 d\u1ea5u hi\u1ec7u cho bi\u1ebft b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111ang\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 Filter (l\u1ecdc d\u1eef li\u1ec7u). Tuy nhi\u00ean kh\u00f4ng c\u00f3 k\u00fd hi\u1ec7u Filter =&gt;\u00a0\u0110\u00e2y l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc n\u00e2ng cao <strong>Advanced Filter<\/strong>.<\/p>\n<p>\u0110\u1ec3 ki\u1ec3m tra c\u00f3\u00a0\u0111\u00fang nguy\u00ean nh\u00e2n n\u00e0y kh\u00f4ng, ch\u00fang ta ch\u1ecdn th\u1ebb Data<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24532\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/nhan-biet-bang-du-lieu-dang-o-che-do-filter.png\" width=\"756\" height=\"392\" title=\"nhan-biet-bang-du-lieu-dang-o-che-do-filter\"><\/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-464.gif\" title=\"ex101_92019-nho-464\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Khi th\u1ea5y bi\u1ec3u t\u01b0\u1ee3ng <strong>Clear<\/strong> (lo\u1ea1i b\u1ecf ch\u1ebf\u00a0\u0111\u1ed9 l\u1ecdc) c\u00f3 n\u1ed5i r\u00f5 l\u00ean (kh\u00f4ng ch\u00ecm nh\u01b0 bi\u1ec3u t\u01b0\u1ee3ng <strong>Reapply<\/strong> b\u00ean d\u01b0\u1edbi) th\u00ec ch\u1ee9ng t\u1ecf b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111ang\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 l\u1ecdc d\u1eef li\u1ec7u.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_khac_phuc_loi_khong_unhide_duoc_dong_an\"><\/span>C\u00e1ch kh\u1eafc ph\u1ee5c l\u1ed7i kh\u00f4ng unhide\u00a0\u0111\u01b0\u1ee3c d\u00f2ng\u00a0\u1ea9n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta ch\u1ec9 vi\u1ec7c b\u1ea5m v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Clear trong th\u1ebb Data l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u s\u1ebd t\u1ef1\u00a0\u0111\u1ed9ng m\u1edf c\u00e1c d\u00f2ng b\u1ecb\u00a0\u1ea9n:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24533\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bo-loc-advanced-filter.png\" width=\"755\" height=\"508\" title=\"bo-loc-advanced-filter\"><\/p>\n<p style=\"text-align: center\"><em>B\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 khi b\u1ecf l\u1ecdc<\/em><\/p>\n<p>Ch\u00fa\u00a0\u00fd: Ch\u1ec9 x\u1ea3y ra tr\u01b0\u1eddng h\u1ee3p n\u00e0y v\u1edbi <strong>d\u00f2ng b\u1ecb\u00a0\u1ea9n<\/strong>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Loc_du_lieu_truc_tiep_trong_bang_voi_Advanced_Filter\"><\/span>L\u1ecdc d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp trong b\u1ea3ng v\u1edbi Advanced Filter<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng AutoFilter trong\u00a0excel\u00a0\u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u trong b\u1ea3ng m\u00e0\u00a0\u00edt khi\u00a0\u0111\u1ec3\u00a0\u00fd\u00a0\u0111\u1ebfn Advanced Filter c\u0169ng c\u00f3 t\u00e1c d\u1ee5ng l\u1ecdc d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp trong b\u1ea3ng.<\/p>\n<p>C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p>V\u00ed d\u1ee5 mu\u1ed1n l\u1ecdc d\u1eef li\u1ec7u theo nh\u00e2n vi\u00ean l\u00e0 L\u00e2m:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24534\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/loc-du-lieu-voi-advanced-filter.png\" width=\"940\" height=\"393\" title=\"loc-du-lieu-voi-advanced-filter\"><\/p>\n<ul>\n<li>Filter the list, in-place l\u00e0 c\u00e1ch th\u1ee9c l\u1ecdc: l\u1ecdc tr\u1ef1c ti\u1ebfp trong b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>List range: v\u00f9ng b\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n l\u1ecdc (bao g\u1ed3m c\u1ea3 d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1)<\/li>\n<li>Criteria range:\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n l\u1ecdc (g\u1ed3m ti\u00eau\u00a0\u0111\u1ec1 v\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n t\u01b0\u01a1ng \u1ee9ng theo ti\u00eau \u0111\u1ec1 \u0111\u00f3)<\/li>\n<\/ul>\n<p>Khi b\u1ea5m OK th\u00ec ch\u00fang ta s\u1ebd c\u00f3 k\u1ebft qu\u1ea3 l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c l\u1ecdc gi\u1ed1ng nh\u01b0\u00a0\u1edf\u00a0\u0111\u1ec1 b\u00e0i. V\u00e0 c\u00e1c d\u00f2ng\u00a0\u0111\u00e3 b\u1ecb\u00a0\u1ea9n b\u1edfi ch\u1ee9c n\u0103ng l\u1ecdc n\u00e0y s\u1ebd kh\u00f4ng Unhide\u00a0\u0111\u01b0\u1ee3c.<\/p>\n<p>\u0110\u00e2y kh\u00f4ng h\u1eb3n l\u00e0 1 l\u1ed7i c\u1ee7a\u00a0Excel, n\u00f3 ch\u1ec9 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a ch\u1ee9c n\u0103ng L\u1ecdc. C\u00e1ch kh\u1eafc ph\u1ee5c\u00a0\u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 b\u1ecf ch\u1ebf\u00a0\u0111\u1ed9 l\u1ecdc\u00a0\u0111i m\u00e0 th\u00f4i. Nh\u01b0ng qua\u00a0\u0111\u00f3 ch\u00fang ta c\u0169ng h\u1ecdc th\u00eam\u00a0\u0111\u01b0\u1ee3c nh\u1eefng ki\u1ebfn th\u1ee9c m\u1edbi v\u1ec1 Advanced Filter, c\u0169ng kh\u00e1 th\u00fa v\u1ecb ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>Xem th\u00eam c\u00e1c b\u00e0i vi\u1ebft v\u1ec1\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a Advanced Filter nh\u00e9:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-loc-tranh-du-lieu-gan-giong-nhau-bang-advanced-filter.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1ecdc tr\u00e1nh d\u1eef li\u1ec7u g\u1ea7n gi\u1ed1ng nhau b\u1eb1ng advanced filter<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lap-bao-cao-chi-tiet-nxt-kho-bang-advanced-filter-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp b\u00e1o c\u00e1o chi ti\u1ebft NXT kho b\u1eb1ng Advanced Filter trong Excel<\/a><\/p>\n<p style=\"padding-left: 30px\">H\u01b0\u1edbng d\u1eabn <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-khac-phuc-loi-khong-mo-duoc-file-xls-tren-excel-2010.html\">c\u00e1ch kh\u1eafc ph\u1ee5c file excel b\u1ecb l\u1ed7i kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c<\/a><\/strong><\/p>\n<p style=\"padding-left: 30px\">\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-464.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5381,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-5379","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\/5379","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=5379"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5379\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5381"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}