{"id":2308,"date":"2024-12-02T07:24:14","date_gmt":"2024-12-02T07:24:14","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-xoa-cac-style-rac-trong-excel-2010-2013-2016\/"},"modified":"2024-12-02T07:24:14","modified_gmt":"2024-12-02T07:24:14","slug":"huong-dan-cach-xoa-cac-style-rac-trong-excel-2010-2013-2016","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/huong-dan-cach-xoa-cac-style-rac-trong-excel-2010-2013-2016\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a c\u00e1c style r\u00e1c trong Excel 2010 2013 2016"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Cell Styles l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3\u00a0\u0111\u1ecbnh d\u1ea1ng nhanh r\u1ea5t hi\u1ec7u qu\u1ea3 trong\u00a0Excel. Tuy nhi\u00ean trong m\u1ed9t s\u1ed1 file\u00a0excel ch\u00fang ta th\u1ea5y xu\u1ea5t hi\u1ec7n r\u1ea5t nhi\u1ec1u c\u00e1c Style r\u00e1c, style l\u1ea1 kh\u00f4ng c\u1ea7n t\u1edbi. L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 x\u00f3a c\u00e1c style r\u00e1c n\u00e0y? Hay l\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 kh\u00f4i ph\u1ee5c c\u00e1c style v\u1ec1\u00a0\u0111\u00fang m\u1eb7c\u00a0\u0111\u1ecbnh ban\u00a0\u0111\u1ea7u c\u1ee7a\u00a0Excel? H\u00e3y t\u00ecm hi\u1ec3u qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.<\/p>\n<p>V\u00ed d\u1ee5 v\u1ec1 c\u00e1c style r\u00e1c trong\u00a0Excel:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24576\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/style-rac-trong-excel.png\" width=\"877\" height=\"286\" title=\"style-rac-trong-excel\"><\/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-674d609db3fef\" 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-xoa-cac-style-rac-trong-excel-2010-2013-2016.html#Cach_xoa_cac_style_rac_trong_Excel_2010_2013_2016\" title=\"C\u00e1ch x\u00f3a c\u00e1c style r\u00e1c trong Excel 2010, 2013, 2016\">C\u00e1ch x\u00f3a c\u00e1c style r\u00e1c trong Excel 2010, 2013, 2016<\/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\/huong-dan-cach-xoa-cac-style-rac-trong-excel-2010-2013-2016.html#Xoa_thu_cong_bang_thao_tac_Delete\" title=\"X\u00f3a th\u1ee7 c\u00f4ng b\u1eb1ng thao t\u00e1c Delete\">X\u00f3a th\u1ee7 c\u00f4ng b\u1eb1ng thao t\u00e1c Delete<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-xoa-cac-style-rac-trong-excel-2010-2013-2016.html#Xoa_toan_bo_bang_lenh_VBA_phuc_hoi_Style_mac_dinh_trong_Excel\" title=\"X\u00f3a to\u00e0n b\u1ed9 b\u1eb1ng l\u1ec7nh VBA ph\u1ee5c h\u1ed3i Style m\u1eb7c\u00a0\u0111\u1ecbnh trong\u00a0Excel\">X\u00f3a to\u00e0n b\u1ed9 b\u1eb1ng l\u1ec7nh VBA ph\u1ee5c h\u1ed3i Style m\u1eb7c\u00a0\u0111\u1ecbnh trong\u00a0Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_xoa_cac_style_rac_trong_Excel_2010_2013_2016\"><\/span>C\u00e1ch x\u00f3a c\u00e1c style r\u00e1c trong Excel 2010, 2013, 2016<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_thu_cong_bang_thao_tac_Delete\"><\/span>X\u00f3a th\u1ee7 c\u00f4ng b\u1eb1ng thao t\u00e1c Delete<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o Style c\u1ea7n x\u00f3a, sau\u00a0\u0111\u00f3 ch\u1ecdn m\u1ee5c Delete:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24577\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xoa-cell-style-bang-lenh-delete.png\" width=\"366\" height=\"177\" title=\"xoa-cell-style-bang-lenh-delete\"><\/p>\n<p>C\u00e1ch n\u00e0y\u00a0\u0111\u01a1n gi\u1ea3n, d\u1ec5 l\u00e0m nh\u01b0ng l\u1ea1i kh\u00e1 th\u1ee7 c\u00f4ng. V\u1edbi s\u1ed1 l\u01b0\u1ee3ng style r\u00e1c nhi\u1ec1u th\u00ec b\u1ea1n s\u1ebd m\u1ea5t nhi\u1ec1u th\u1eddi gian khi ch\u1ec9 c\u00f3 th\u1ec3 x\u00f3a l\u1ea7n l\u01b0\u1ee3t t\u1eebng style.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xoa_toan_bo_bang_lenh_VBA_phuc_hoi_Style_mac_dinh_trong_Excel\"><\/span>X\u00f3a to\u00e0n b\u1ed9 b\u1eb1ng l\u1ec7nh VBA ph\u1ee5c h\u1ed3i Style m\u1eb7c\u00a0\u0111\u1ecbnh trong\u00a0Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1ch n\u00e0y\u00a0\u0111\u00f2i h\u1ecfi b\u1ea1n ph\u1ea3i bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Macro trong VBA.<\/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-177.gif\" title=\"ex101_92019-nho-177\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: M\u1edf c\u1eeda s\u1ed5 Visual Basic (VBA) b\u1eb1ng ph\u00edm t\u1eaft <strong>Alt + F11<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 2<\/strong>: T\u1ea1o m\u1edbi 1 Module<\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: D\u00e1n c\u00e2u l\u1ec7nh sau\u00a0\u0111\u00e2y v\u00e0o trong Module v\u1eeba t\u1ea1o:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/2bc4feb9ab74e874dd8af7f698ffd826\">Gist<\/a>.<\/div>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: B\u1ea5m ph\u00edm t\u1eaft <strong>Alt + F8<\/strong>\u00a0\u0111\u1ec3 g\u1ecdi c\u1eeda s\u1ed5 ch\u1ea1y Macro, Ch\u1ecdn Macro\u00a0<strong>RebuildDefaultStyles<\/strong>\u00a0r\u1ed3i b\u1ea5m l\u1ec7nh <strong>Run<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24579\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/chay-macro-xoa-cell-style.png\" width=\"551\" height=\"470\" title=\"chay-macro-xoa-cell-style\"><\/p>\n<p>K\u1ebft qu\u1ea3 l\u00e0 file\u00a0Excel c\u1ee7a ch\u00fang ta\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf ho\u00e0n to\u00e0n c\u00e1c style r\u00e1c, tr\u1edf l\u1ea1i c\u00e1c style ban\u00a0\u0111\u1ea7u theo\u00a0\u0111\u00fang m\u1eb7c\u00a0\u0111\u1ecbnh c\u1ee7a\u00a0Excel.<\/p>\n<p>Th\u1eadt\u00a0\u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o.<\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Macro trong\u00a0Excel th\u00ec xem l\u1ea1i c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\">B\u1eaft \u0111\u1ea7u v\u1edbi Excel Macros v\u00e0 l\u1eadp tr\u00ecnh VBA<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-chay-file-macro-chay-file-vba-trong-excel.html\">C\u00e1ch ch\u1ea1y file Macro, ch\u1ea1y file VBA 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\/2024\/12\/ex101_92019-nho-177.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2309,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2308","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\/2308","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=2308"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2308\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2309"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}