{"id":4198,"date":"2024-12-04T13:50:23","date_gmt":"2024-12-04T13:50:23","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-cac-ky-thuat-xoa-dinh-dang-trong-excel\/"},"modified":"2024-12-04T13:50:23","modified_gmt":"2024-12-04T13:50:23","slug":"huong-dan-cac-ky-thuat-xoa-dinh-dang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-cac-ky-thuat-xoa-dinh-dang-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1c k\u1ef9 thu\u1eadt xo\u00e1 \u0111\u1ecbnh d\u1ea1ng trong Excel"},"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\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 ba\u0309n Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch xo\u00e1 \u0111\u1ecbnh d\u1ea1ng trong Excel m\u00f4\u0323t ca\u0301ch \u0111\u01a1n gia\u0309n nh\u00e2\u0301t.<\/p>\n<p style=\"text-align: justify\">Khi l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng b\u1ea3ng t\u00ednh l\u1edbn, ch\u00fang ta th\u01b0\u1eddng s\u1eed d\u1ee5ng nh\u1eefng \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt d\u1eef li\u1ec7u ho\u1eb7c 1 th\u00f4ng tin n\u00e0o \u0111\u00f3. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u d\u1eef li\u1ec7u, b\u1ea1n c\u1ea7n xo\u00e1 \u0111\u1ecbnh d\u1ea1ng s\u1eb5n c\u1ee7a d\u1eef li\u1ec7u \u0111\u00f3 tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed5i m\u00e0u c\u00e1c \u00f4, thay font ch\u1eef, \u0111\u01b0\u1eddng vi\u1ec1n, ch\u1ec9nh l\u1ec1 v\u00e0 l\u00e0m c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng s\u1ebd t\u1ed1n nhi\u1ec1u c\u00f4ng s\u1ee9c v\u00e0 th\u1eddi gian. R\u1ea5t may l\u00e0 Excel cung c\u1ea5p cho ch\u00fang ta nh\u1eefng c\u00e1ch \u0111\u01a1n gi\u1ea3n, nh\u1eb9 nh\u00e0ng \u0111\u1ec3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng trong b\u1ea3ng t\u00ednh.<\/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-67505e1e71684\" 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-cac-ky-thuat-xoa-dinh-dang-trong-excel.html#Cac_buoc_xoa_dinh_dang_co_ban\" title=\"C\u00e1c b\u01b0\u1edbc x\u00f3a \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n\">C\u00e1c b\u01b0\u1edbc x\u00f3a \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n<\/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-cac-ky-thuat-xoa-dinh-dang-trong-excel.html#LUA_CHON_XOA_DINH_DANG_BANG_1_CLICK_CHUOT\" title=\"L\u1ef0A CH\u1eccN XO\u00c1 \u0110\u1ecaNH D\u1ea0NG B\u1eb0NG 1 CLICK CHU\u1ed8T:\">L\u1ef0A CH\u1eccN XO\u00c1 \u0110\u1ecaNH D\u1ea0NG B\u1eb0NG 1 CLICK CHU\u1ed8T:<\/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-cac-ky-thuat-xoa-dinh-dang-trong-excel.html#THEM_CLEAR_FORMAT_VAO_QUICK_ACCESS_TOOLBAR\" title=\"TH\u00caM CLEAR FORMAT V\u00c0O QUICK ACCESS TOOLBAR:\">TH\u00caM CLEAR FORMAT V\u00c0O QUICK ACCESS TOOLBAR:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cac-ky-thuat-xoa-dinh-dang-trong-excel.html#THEM_NUT_CLEAR_FORMATS_VAO_RIBBON\" title=\"TH\u00caM N\u00daT CLEAR FORMATS V\u00c0O RIBBON:\">TH\u00caM N\u00daT CLEAR FORMATS V\u00c0O RIBBON:<\/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-cac-ky-thuat-xoa-dinh-dang-trong-excel.html#XOA_DINH_DANG_DUNG_FORMAT_PAINTER\" title=\"XO\u00c1 \u0110\u1ecaNH D\u1ea0NG D\u00d9NG FORMAT PAINTER:\">XO\u00c1 \u0110\u1ecaNH D\u1ea0NG D\u00d9NG FORMAT PAINTER:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cac_buoc_xoa_dinh_dang_co_ban\"><\/span><strong>C\u00e1c b\u01b0\u1edbc x\u00f3a \u0111\u1ecbnh d\u1ea1ng c\u01a1 b\u1ea3n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ch\u1eafc ch\u1eafn, \u0111\u1ec3 khi\u1ebfn 1 th\u00f4ng tin n\u1ed5i b\u1eadt, ch\u00fang ta thay \u0111\u1ed5i c\u00e1ch th\u00f4ng tin \u0111\u00f3 hi\u1ec3n th\u1ecb. Tuy nhi\u00ean thay \u0111\u1ed5i qu\u00e1 nhi\u1ec1u v\u00e0 kh\u00f4ng h\u1ee3p l\u00fd s\u1ebd c\u00f3 t\u00e1c d\u1ee5ng ng\u01b0\u1ee3c l\u1ea1i, l\u00e0m b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n kh\u00f3 \u0111\u1ecdc h\u01a1n. C\u00e1ch ch\u1eefa d\u1ec5 nh\u1ea5t \u0111\u00f3 l\u00e0 xo\u00e1 to\u00e0n b\u1ed9 \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n v\u00e0 l\u00e0m l\u1ea1i t\u1eeb \u0111\u1ea7u.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xo\u00e1 to\u00e0n b\u1ed9 \u0111\u1ecbnh d\u1ea1ng trong Excel, ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 ho\u1eb7c d\u00e3y \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n xo\u00e1 \u0111\u1ecbnh d\u1ea1ng<\/li>\n<li>Trong tab <strong>Home<\/strong>, ch\u1ecdn <strong>Editting<\/strong>, nh\u1ea5n v\u00e0o m\u0169i t\u00ean c\u1ea1nh n\u00fat <strong>Clear<\/strong>.<\/li>\n<li>Ch\u1ecdn <strong>Clear Formats.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5002 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/clear-formats-excel.png\" width=\"160\" height=\"223\" title=\"clear-formats-excel\"><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">M\u1ecdi \u0111\u1ecbnh d\u1ea1ng trong \u00f4 (\u0111\u1ecbnh s\u1ed1, font ch\u1eef, m\u00e0u s\u1eafc, \u0111\u01b0\u1eddng vi\u1ec1n) s\u1ebd b\u1ecb xo\u00e1, gi\u1eef l\u1ea1i n\u1ed9i dung trong \u00f4.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o nh\u1ecf: \u00a0<\/strong><\/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-335.gif\" title=\"ex101_92019-nho-335\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u1edbi t\u00ednh n\u0103ng xo\u00e1 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a Excel, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng xo\u00e1 \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng ch\u1ec9 trong 1 \u00f4, m\u00e0 c\u00f2n xo\u00e1 \u0111\u1ecbnh d\u1ea1ng c\u1ea3 h\u00e0ng, c\u1ed9t, b\u1ea3ng t\u00ednh.<\/p>\n<ul style=\"text-align: justify\">\n<li>\u0110\u1ec3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong b\u1ea3ng t\u00ednh, ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh b\u1eb1ng <strong>Ctrl + A <\/strong>ho\u1eb7c nh\u1ea5n n\u00fat <strong>Select All <\/strong>\u1edf g\u00f3c tr\u00e1i c\u1ee7a b\u1ea3ng t\u00ednh, v\u00e0 nh\u1ea5n <strong>Clear Formats.<\/strong><\/li>\n<li>\u0110\u1ec3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c h\u00e0ng, nh\u1ea5n v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t ho\u1eb7c h\u00e0ng v\u00e0 ch\u1ecdn.<\/li>\n<li>\u0110\u1ec3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng trong c\u00e1c \u00f4 ho\u1eb7c d\u00e3y kh\u00f4ng li\u1ec1n nhau, ch\u1ecdn \u00f4 ho\u1eb7c d\u00e3y \u00f4 \u0111\u1ea7u ti\u00ean, nh\u1ea5n v\u00e0 gi\u1eef <strong>Ctrl <\/strong>khi ch\u1ecdn th\u00eam c\u00e1c \u00f4 ho\u1eb7c d\u00e3y \u00f4 kh\u00e1c.<\/li>\n<\/ul>\n<blockquote>\n<p>Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u excel c\u01a1 b\u1ea3n<\/a> hay nh\u00e2\u0301t 2018<\/p>\n<\/blockquote>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"LUA_CHON_XOA_DINH_DANG_BANG_1_CLICK_CHUOT\"><\/span><strong>L\u1ef0A CH\u1eccN XO\u00c1 \u0110\u1ecaNH D\u1ea0NG B\u1eb0NG 1 CLICK CHU\u1ed8T:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng trong Excel ch\u1ec9 b\u1eb1ng 1 click chu\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam <em>Clear Formats<\/em> v\u00e0o <em>Quick Access Toolbar<\/em> ho\u1eb7c <em>Excel Ribbon<\/em>. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c c\u00e1c file Excel t\u1eeb \u0111\u1ed3ng nghi\u1ec7p, b\u1ea1n b\u00e8 v\u00e0 \u0111\u1ecbnh d\u1ea1ng file c\u1ee7a h\u1ecd khi\u1ebfn b\u1ea1n g\u1eb7p kh\u00f3 kh\u0103n khi t\u1ed5ng h\u1ee3p.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"THEM_CLEAR_FORMAT_VAO_QUICK_ACCESS_TOOLBAR\"><\/span><strong>TH\u00caM CLEAR FORMAT V\u00c0O QUICK ACCESS TOOLBAR:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu <em>Clear Formats<\/em> l\u00e0 t\u00ednh n\u0103ng b\u1ea1n s\u1eed d\u1ee5ng nhi\u1ec1u nh\u1ea5t trong Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam n\u00f3 v\u00e0o <em>Quick Access toolbar<\/em> \u1edf g\u00f3c tr\u00e1i c\u1eeda s\u1ed5 Excel:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5003 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/clear-formats-quick-access-toolbar.png\" width=\"220\" height=\"50\" title=\"clear-formats-quick-access-toolbar\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u1ef1c hi\u1ec7n, l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong b\u1ea3ng t\u00ednh Excel, ch\u1ecdn <strong>File &gt; Options &gt; Quick Access Toolbar<\/strong> (\u1edf thanh b\u00ean tr\u00e1i).<\/li>\n<li>Trong <strong>Choose commands<\/strong>, ch\u1ecdn <strong>All Commands<\/strong>.<\/li>\n<li>Trong danh s\u00e1ch c\u00e1c l\u1ec7nh, ch\u1ecdn <strong>Clear Formats<\/strong>, nh\u1ea5n n\u00fat <strong>Add<\/strong> \u0111\u1ec3 \u0111\u01b0a l\u1ec7nh sang ph\u1ea7n b\u00ean ph\u1ea3i.<\/li>\n<li>Nh\u1ea5n <strong>OK<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5004 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-clear-formats-quick-access.png\" width=\"610\" height=\"491\" title=\"add-clear-formats-quick-access\"><\/li>\n<\/ol>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"THEM_NUT_CLEAR_FORMATS_VAO_RIBBON\"><\/span><strong>TH\u00caM N\u00daT CLEAR FORMATS V\u00c0O RIBBON:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n ph\u1ea7n <em>Quick Access Toolbar<\/em> c\u1ee7a m\u00ecnh c\u00f3 qu\u00e1 nhi\u1ec1u n\u00fat, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o nh\u00f3m tr\u00ean <em>Excel ribbon<\/em> v\u00e0 \u0111\u1ec3 <em>Clear Formats<\/em> t\u1ea1i \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 th\u00eam <em>Clear Formats<\/em> v\u00e0o Excel Ribbon, l\u00e0m c\u00e1c b\u01b0\u1edbc:<\/p>\n<ol style=\"text-align: justify\">\n<li>Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o ribbon, ch\u1ecdn <strong>Customize the Ribbon\u2026<\/strong><\/li>\n<li>Nh\u1ea5n n\u00fat <strong>New Group<\/strong>:<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5005 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-new-group.png\" width=\"610\" height=\"491\" title=\"add-new-group\"><\/li>\n<li>Khi <strong>New Group<\/strong> \u0111\u01b0\u1ee3c ch\u1ecdn, nh\u1ea5n n\u00fat <strong>Rename<\/strong>, \u0111\u00e1nh t\u00ean b\u1ea1n mu\u1ed1n v\u00e0 nh\u1ea5n <strong>OK<\/strong>.<\/li>\n<li>D\u01b0\u1edbi ph\u1ea7n <strong>Choose commands from<\/strong>, ch\u1ecdn <strong>All Commands<\/strong><\/li>\n<li>Trong danh s\u00e1ch c\u00e2u l\u1ec7nh, cu\u1ed9n xu\u1ed1ng ch\u1ecdn <strong>Clear Formats<\/strong>.<\/li>\n<li>Ch\u1ecdn nh\u00f3m m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o v\u00e0 nh\u1ea5n <strong>Add<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5006 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-clear-formats-ribbon.png\" width=\"610\" height=\"491\" title=\"add-clear-formats-ribbon\"><\/li>\n<li>Cu\u1ed1i c\u00f9ng, nh\u1ea5n <strong>OK<\/strong> \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i <em>Excel Options<\/em> v\u00e0 \u00e1p d\u1ee5ng thay \u0111\u1ed5i.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5007 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/clear-formats-button.png\" width=\"245\" height=\"94\" title=\"clear-formats-button\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 gi\u1edd, v\u1edbi n\u00fat <em>Clear Formats<\/em>, b\u1ea1n c\u00f3 th\u1ec3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng ch\u1ec9 trong 1 click chu\u1ed9t.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"XOA_DINH_DANG_DUNG_FORMAT_PAINTER\"><\/span><strong>XO\u00c1 \u0110\u1ecaNH D\u1ea0NG D\u00d9NG FORMAT PAINTER:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-format-painter-va-cac-cach-de-sao-chep-dinh-dang.html\" target=\"_blank\" rel=\"noopener noreferrer\"><em>Format Painter<\/em><\/a> th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng, nh\u01b0ng n\u00f3 c\u0169ng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn \u00f4 ch\u01b0a \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng g\u1ea7n v\u1edbi \u00f4 b\u1ea1n mu\u1ed1n xo\u00e1 \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<li>Nh\u1ea5n n\u00fat <strong>Format Painter<\/strong> tr\u00ean tab <strong>Home<\/strong>, nh\u00f3m <strong>Clipboard<\/strong>.<\/li>\n<li>Ch\u1ecdn \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n xo\u00e1 \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-5008 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-painter-clear-formatting.png\" width=\"408\" height=\"287\" title=\"format-painter-clear-formatting\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>: C\u1ea3 <em>Clear Formats<\/em> v\u00e0 <em>Format Painter<\/em> \u0111\u1ec1u kh\u00f4ng xo\u00e1 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u00e1p d\u1ee5ng v\u1edbi 1 ph\u1ea7n n\u1ed9i dung trong \u00f4. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n \u0111\u00e1nh d\u1ea5u 1 t\u1eeb trong 1 \u00f4 v\u1edbi m\u00e0u kh\u00e1c, nh\u01b0 h\u00ecnh d\u01b0\u1edbi, th\u00ec \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3 s\u1ebd kh\u00f4ng xo\u00e1 \u0111\u01b0\u1ee3c.<\/p>\n<p><span style=\"font-family: georgia, palatino, serif\">\u2014\u2014\u2014<\/span><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel.<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2Mu1LGN\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/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-335.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4199,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4198","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\/4198","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=4198"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4198\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4199"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}