{"id":11973,"date":"2025-01-15T06:26:43","date_gmt":"2025-01-15T06:26:43","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel\/"},"modified":"2025-01-15T06:26:43","modified_gmt":"2025-01-15T06:26:43","slug":"huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o v\u00e0 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng bi\u1ec3u 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, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn cho c\u00e1c b\u1ea1n c\u00e1ch \u00e1p d\u1ee5ng v\u00e0 thay \u0111\u1ed5i c\u00e1c ki\u1ec3u b\u1ea3ng, xo\u00e1 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng nh\u01b0ng v\u1eabn gi\u1eef c\u00e1c ch\u1ee9c n\u0103ng c\u1ee7a 1 b\u1ea3ng Excel.<\/p>\n<p style=\"text-align: justify\">Sau khi b\u1ea1n \u0111\u00e3 t\u1ea1o \u0111\u01b0\u1ee3c 1 b\u1ea3ng trong Excel, \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n mu\u1ed1n l\u00e0m l\u00e0 g\u00ec? Thay \u0111\u1ed5i m\u1eabu b\u1ea3ng!<\/p>\n<p style=\"text-align: justify\">Th\u1eadt may l\u00e0 Microsoft Excel cung c\u1ea5p cho ch\u00fang ta r\u1ea5t nhi\u1ec1u m\u1eabu b\u1ea3ng c\u00f3 s\u1eb5n v\u00e0 b\u1ea1n thay \u0111\u1ed5i m\u1eabu ch\u1ec9 trong 1 c\u00e1i click chu\u1ed9t. Nh\u01b0ng n\u1ebfu c\u00e1c m\u1eabu c\u00f3 s\u1eb5n kh\u00f4ng \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u1ea1o m\u1eabu b\u1ea3ng ri\u00eang c\u1ee7a m\u00ecnh. Th\u00eam v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n c\u00e1c ph\u1ea7n ch\u00ednh c\u1ee7a b\u1ea3ng, v\u00ed d\u1ee5 nh\u01b0 <em>header row<\/em>, <em>banded row<\/em>, <em>total row<\/em>\u2026B\u00e0i vi\u1ebft s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng c\u01a1 b\u1ea3n c\u0169ng nh\u01b0 n\u00e2ng cao c\u1ee7a c\u00e1c t\u00ednh n\u0103ng n\u00e0y.<\/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-6787551f9c49d\" 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-tao-va-dinh-dang-bang-bieu-trong-excel.html#CAC_MAU_BANG_TRONG_EXCEL\" title=\"C\u00c1C M\u1eaaU B\u1ea2NG TRONG EXCEL\">C\u00c1C M\u1eaaU B\u1ea2NG TRONG EXCEL<\/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-tao-va-dinh-dang-bang-bieu-trong-excel.html#THAY_DOI_MAU_BANG_TRONG_EXCEL\" title=\"THAY \u0110\u1ed4I M\u1eaaU B\u1ea2NG TRONG EXCEL\">THAY \u0110\u1ed4I M\u1eaaU B\u1ea2NG TRONG EXCEL<\/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-tao-va-dinh-dang-bang-bieu-trong-excel.html#THAY_DOI_MAU_BANG_MAC_DINH_TRONG_EXCEL\" title=\"THAY\u00a0 \u0110\u1ed4I M\u1eaaU B\u1ea2NG M\u1eb6C \u0110\u1ecaNH TRONG EXCEL\">THAY\u00a0 \u0110\u1ed4I M\u1eaaU B\u1ea2NG M\u1eb6C \u0110\u1ecaNH TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel.html#TAO_MAU_BANG_THEO_Y_MUON\" title=\"T\u1ea0O M\u1eaaU B\u1ea2NG THEO \u00dd MU\u1ed0N\">T\u1ea0O M\u1eaaU B\u1ea2NG THEO \u00dd MU\u1ed0N<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel.html#AP_DUNG_MAU_BANG_MA_KHONG_PHAI_TAO_BANG\" title=\"\u00c1P D\u1ee4NG M\u1eaaU B\u1ea2NG M\u00c0 KH\u00d4NG PH\u1ea2I T\u1ea0O B\u1ea2NG\">\u00c1P D\u1ee4NG M\u1eaaU B\u1ea2NG M\u00c0 KH\u00d4NG PH\u1ea2I T\u1ea0O B\u1ea2NG<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel.html#CACH_XOA_DINH_DANG_BANG\" title=\"C\u00c1CH XO\u00c1 \u0110\u1ecaNH D\u1ea0NG B\u1ea2NG\">C\u00c1CH XO\u00c1 \u0110\u1ecaNH D\u1ea0NG B\u1ea2NG<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel.html#Ung_dung_cua_bang_trong_Pivot_Table\" title=\"\u1ee8ng d\u1ee5ng c\u1ee7a b\u1ea3ng trong Pivot Table\">\u1ee8ng d\u1ee5ng c\u1ee7a b\u1ea3ng trong Pivot Table<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-va-dinh-dang-bang-bieu-trong-excel.html#Su_dung_Slicer_de_loc_bang_du_lieu_trong_Excel\" title=\"S\u1eed d\u1ee5ng Slicer \u0111\u1ec3 l\u1ecdc b\u1ea3ng d\u1eef li\u1ec7u trong Excel\">S\u1eed d\u1ee5ng Slicer \u0111\u1ec3 l\u1ecdc b\u1ea3ng d\u1eef li\u1ec7u trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CAC_MAU_BANG_TRONG_EXCEL\"><\/span><strong>C\u00c1C M\u1eaaU B\u1ea2NG TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">B\u1ea3ng Excel gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng xem x\u00e9t v\u00e0 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u th\u00f4ng qua c\u00e1c t\u00ednh n\u0103ng h\u1eefu \u00edch nh\u01b0 l\u1ef1a ch\u1ecdn l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp, t\u00ednh to\u00e1n c\u00e1c c\u1ed9t,\u2026<\/p>\n<p style=\"text-align: justify\">Khi chuy\u1ec3n d\u1eef li\u1ec7u sang b\u1ea3ng Excel, b\u1ea1n n\u00ean b\u1eaft \u0111\u1ea7u t\u1eeb \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng. B\u1ea3ng m\u1edbi l\u1eadp s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng s\u1eb5n v\u1edbi font ch\u1eef v\u00e0 m\u00e0u n\u1ec1n, m\u00e0u vi\u1ec1n, m\u00e0u \u0111\u1ed1i l\u1eadp\u2026N\u1ebfu b\u1ea1n kh\u00f4ng th\u00edch \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng m\u1eb7c \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1eabu c\u00f3 s\u1eb5n trong <strong>Table Styles<\/strong> \u1edf tab <strong>Design<\/strong>.<\/p>\n<p style=\"text-align: justify\">Tab <strong>Design<\/strong> l\u00e0 n\u01a1i ch\u00fang ta b\u1eaft \u0111\u1ea7u l\u00e0m vi\u1ec7c v\u1edbi m\u1eabu b\u1ea3ng Excel, n\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi tab <strong>Table Tools<\/strong>, ngay khi nh\u1ea5n v\u00e0o 1 \u00f4 b\u1ea5t k\u00ec trong b\u1ea3ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4988 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-table-styles.png\" width=\"486\" height=\"668\" title=\"excel-table-styles\"><\/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-340.gif\" title=\"ex101_92019-nho-340\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y \u1edf h\u00ecnh tr\u00ean, th\u01b0 vi\u1ec7n <strong>Table Styles<\/strong> cung c\u1ea5p cho ng\u01b0\u1eddi d\u00f9ng h\u01a1n 50 m\u1eabu b\u1ea3ng c\u00f3 s\u1eb5n kh\u00e1c nhau \u0111\u01b0\u1ee3c chia th\u00e0nh c\u00e1c nh\u00f3m Light, Medium, v\u00e0 Dark.<\/p>\n<p style=\"text-align: justify\">Khi nh\u1ea5n v\u00e0o 1 m\u1eabu b\u1ea3ng Excel, \u0111\u1ecbnh d\u1ea1ng h\u00e0ng, c\u1ed9t, h\u00e0ng ti\u00eau \u0111\u1ec1, h\u00e0ng t\u1ed5ng s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i.<\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng c\u00f3 s\u1eb5n, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng <strong>Table Style Options<\/strong> \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng m\u1edbi nh\u1eefng y\u1ebfu t\u1ed1 c\u1ee7a b\u1ea3ng nh\u01b0:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Header row<\/strong> \u2013 \u1ea8n ho\u1eb7c hi\u1ec7n h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng<\/li>\n<li><strong>Total row<\/strong> \u2013 th\u00eam h\u00e0ng t\u1ed5ng v\u00e0o cu\u1ed1i b\u1ea3ng v\u1edbi danh s\u00e1ch c\u00e1c ch\u1ee9c n\u0103ng cho m\u1ed7i \u00f4 trong h\u00e0ng t\u1ed5ng<\/li>\n<li><strong>Banded row<\/strong> v\u00e0 <strong>Banded columns<\/strong> \u2013 thay \u0111\u1ed5i \u0111\u1ed9 \u0111\u1eadm nh\u1ea1t c\u1ee7a c\u00e1c h\u00e0ng, c\u1ed9t xen k\u1ebd.<\/li>\n<li><strong>First column<\/strong> v\u00e0 <strong>last column<\/strong> \u2013 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ed9t \u0111\u1ea7u ti\u00ean v\u00e0 cu\u1ed1i c\u00f9ng c\u1ee7a b\u1ea3ng.<\/li>\n<li><strong>Filter button<\/strong> \u2013 \u1ea9n ho\u1eb7c hi\u1ec7n m\u0169i t\u00ean \u1edf h\u00e0ng ti\u00eau \u0111\u1ec1<\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00ecnh d\u01b0\u1edbi minh ho\u1ea1 c\u00e1c l\u1ef1a ch\u1ecdn Table Style<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4989 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/table-style-options.png\" width=\"325\" height=\"143\" title=\"table-style-options\"><\/p>\n<p style=\"text-align: justify\">C\u00e1ch ch\u1ecdn 1 m\u1eabu b\u1ea3ng khi t\u1ea1o b\u1ea3ng<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o 1 b\u1ea3ng c\u00f3 \u0111\u1ecbnh d\u1ea1ng theo 1 m\u1eabu c\u1ee5 th\u1ec3, b\u1ea1n l\u00e0m nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn d\u00e3y \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n th\u00e0nh b\u1ea3ng<\/li>\n<li>Trong tab<strong> Home<\/strong>, v\u00e0o <strong>Styles<\/strong>, ch\u1ecdn <strong>Format as Table.<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4990 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/choose-table-style-excel.png\" width=\"558\" height=\"94\" title=\"choose-table-style-excel\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Trong th\u01b0 vi\u1ec7n <strong>Table Styles<\/strong>, ch\u1ecdn m\u1eabu b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n.<\/li>\n<\/ol>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"THAY_DOI_MAU_BANG_TRONG_EXCEL\"><\/span><strong>THAY \u0110\u1ed4I M\u1eaaU B\u1ea2NG TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 thay \u0111\u1ed5i m\u1eabu b\u1ea3ng cho 1 b\u1ea3ng c\u00f3 s\u1eb5n, th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn 1 \u00f4 b\u1ea5t k\u00ec trong b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i.<\/li>\n<li>Trong tab <strong>Design<\/strong>, v\u00e0o <strong>Table Styles<\/strong>, nh\u1ea5n n\u00fat <strong>More<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c m\u1eabu b\u1ea3ng c\u00f3 s\u1eb5n.<\/li>\n<li>Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn m\u1eabu b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n d\u00f9ng, Excel s\u1ebd cho b\u1ea1n xem tr\u01b0\u1edbc. \u0110\u1ec3 ch\u1ecdn m\u1eabu b\u1ea3ng \u0111\u00f3, b\u1ea1n nh\u1ea5n chu\u1ed9t.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">M\u1eb9o nh\u1ecf:<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111\u00e3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng b\u1eb1ng c\u00e1ch th\u1ee7 c\u00f4ng (v\u00ed d\u1ee5: \u0111\u00e1nh d\u1ea5u nh\u1ea5n m\u1ea1nh c\u00e1c \u00f4 v\u1edbi m\u00e0u s\u1eafc \u0111\u1eadm h\u01a1n ho\u1eb7c d\u00f9ng m\u00e0u kh\u00e1c), l\u1ef1a ch\u1ecdn m\u1eabu b\u1ea3ng Excel kh\u00e1c s\u1ebd v\u1eabn gi\u1eef \u0111\u1ecbnh d\u1ea1ng \u0111\u00f3. \u0110\u1ec3 d\u00f9ng m\u1eabu b\u1ea3ng m\u1edbi v\u00e0 lo\u1ea1i b\u1ecf \u0111\u1ecbnh d\u1ea1ng \u0111ang \u0111\u01b0\u1ee3c d\u00f9ng, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o m\u1eabu, v\u00e0 ch\u1ecdn <strong>Apply and Clear Formatting.<\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4991 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/apply-clear-formatting.png\" width=\"504\" height=\"294\" title=\"apply-clear-formatting\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"THAY_DOI_MAU_BANG_MAC_DINH_TRONG_EXCEL\"><\/span><strong>THAY\u00a0 \u0110\u1ed4I M\u1eaaU B\u1ea2NG M\u1eb6C \u0110\u1ecaNH TRONG EXCEL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u1eb7t m\u1eabu b\u1ea3ng m\u1eb7c \u0111\u1ecbnh, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o m\u1eabu b\u1ea3ng trong th\u01b0 vi\u1ec7n <strong>Table Styles<\/strong> v\u00e0 ch\u1ecdn <strong>Set As Default<\/strong>:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4992 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/change-default-table-style.png\" width=\"578\" height=\"272\" title=\"change-default-table-style\"><\/p>\n<p style=\"text-align: justify\">V\u00e0 gi\u1edd, khi b\u1ea1n ch\u1ecdn <strong>Table<\/strong> trong tab <strong>Insert <\/strong>ho\u1eb7c nh\u1ea5n ph\u00edm <strong>Ctrl + T<\/strong>, b\u1ea3ng m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c th\u00eam v\u1edbi \u0111\u1ecbnh d\u1ea1ng m\u1edbi m\u00e0 b\u1ea1n \u0111\u00e3 \u0111\u1eb7t.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"TAO_MAU_BANG_THEO_Y_MUON\"><\/span><strong>T\u1ea0O M\u1eaaU B\u1ea2NG THEO \u00dd MU\u1ed0N<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1edbi c\u00e1c m\u1eabu b\u1ea3ng c\u00f3 s\u1eb5n, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1eabu ri\u00eang c\u1ee7a m\u00ecnh nh\u01b0 sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong tab <strong>Home<\/strong>, v\u00e0o <strong>Styles<\/strong>, ch\u1ecdn <strong>Format as Table<\/strong>. Ho\u1eb7c ch\u1ecdn b\u1ea3ng c\u00f3 s\u1eb5n \u0111\u1ec3 hi\u1ec3n th\u1ecb tab <strong>Design<\/strong>, v\u00e0 nh\u1ea5n n\u00fat<\/li>\n<li>\u1ede ph\u00eda d\u01b0\u1edbi c\u00e1c b\u1ea3ng \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf s\u1eb5n, ch\u1ecdn <strong>New Table Style.<\/strong><\/li>\n<li>Trong c\u1eeda s\u1ed5 <strong>New Table Style<\/strong>, \u0111\u00e1nh t\u00ean cho m\u1eabu b\u1ea3ng ri\u00eang c\u1ee7a b\u1ea1n trong \u00f4 <strong>Name<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4993 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-table-style-name.png\" width=\"610\" height=\"388\" title=\"custom-table-style-name\"><\/li>\n<li>\u1ede ph\u1ea7n <strong>Table Elements<\/strong>, ch\u1ecdn y\u1ebfu t\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng v\u00e0 ch\u1ecdn <strong>Format<\/strong>. H\u1ed9p <strong>Format Cells<\/strong> s\u1ebd m\u1edf ra, v\u00e0 b\u1ea1n ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n \u1edf ph\u1ea7n <strong>Font<\/strong>, <strong>Border<\/strong> v\u00e0 <strong>Fill<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4994 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/format-table-elements.png\" width=\"610\" height=\"388\" title=\"format-table-elements\"><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u1ec3 xo\u00e1 \u0111\u1ecbnh d\u1ea1ng c\u00f3 s\u1eb5n c\u1ee7a 1 y\u1ebfu t\u1ed1, b\u1ea1n nh\u1ea5n n\u00fat <strong>Clear<\/strong>.<\/p>\n<p style=\"text-align: justify\">M\u1eb9o nh\u1ecf:<\/p>\n<ul style=\"text-align: justify\">\n<li>Y\u1ebfu t\u1ed1 c\u1ee7a b\u1ea3ng \u0111ang \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng s\u1eb5n s\u1ebd in \u0111\u1eadm trong h\u1ed9p <strong>Table Element<\/strong>.<\/li>\n<li>Nh\u1eefng thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng s\u1ebd xem \u0111\u01b0\u1ee3c xem tr\u01b0\u1edbc trong ph\u1ea7n <strong>Preview <\/strong>ph\u00eda b\u00ean ph\u1ea3i.<\/li>\n<li>\u0110\u1ec3 \u0111\u1eb7t m\u1eb7c \u0111\u1ecbnh m\u1eabu b\u1ea3ng m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o cho b\u1ea3ng hi\u1ec7n t\u1ea1i, ch\u1ecdn <strong>Set as default table quick style for this document.<\/strong><\/li>\n<\/ul>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Nh\u1ea5n OK \u0111\u1ec3 l\u01b0u m\u1eabu b\u1ea3ng ri\u00eang c\u1ee7a b\u1ea1n.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Ngay khi m\u1eabu b\u1ea3ng c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c t\u1ea1o, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam v\u00e0o th\u01b0 vi\u1ec7n Table Styles.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4995 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-style-added-gallery.png\" width=\"486\" height=\"318\" title=\"custom-style-added-gallery\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 thay \u0111\u1ed5i m\u1eabu b\u1ea3ng c\u1ee7a b\u1ea1n, v\u00e0o th\u01b0 vi\u1ec7n <strong>Table Styles<\/strong>, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o m\u1eabu, ch\u1ecdn <strong>Modify<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xo\u00e1 m\u1eabu b\u1ea3ng c\u1ee7a b\u1ea1n, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o m\u1eabu v\u00e0 ch\u1ecdn <strong>Delete<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4996 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/custom-table-style-modify-delete.png\" width=\"291\" height=\"273\" title=\"custom-table-style-modify-delete\"><\/p>\n<p style=\"text-align: justify\">S\u1ebd kh\u00f4ng thay \u0111\u1ed5i ho\u1eb7c xo\u00e1 \u0111\u01b0\u1ee3c c\u00e1c m\u1eabu b\u1ea3ng c\u00f3 s\u1eb5n trong Excel.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o nh\u1ecf:\u00a0<\/strong>M\u1eabu b\u1ea3ng c\u1ee7a b\u1ea1n ch\u1ec9 c\u00f3 trong workbook hi\u1ec7n t\u1ea1i, n\u01a1i t\u1ea1o ra m\u1eabu b\u1ea3ng. N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng m\u1eabu \u0111\u00f3 cho c\u00e1c workbook kh\u00e1c, c\u00e1ch nhanh nh\u1ea5t l\u00e0 sao ch\u00e9p b\u1ea3ng c\u00f3 m\u1eabu c\u1ee7a b\u1ea1n sang workbook \u0111\u00f3. Sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 xo\u00e1 b\u1ea3ng \u0111\u00f3 nh\u01b0ng m\u1eabu b\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u trong th\u01b0 vi\u1ec7n Table Styles.<\/p>\n<blockquote>\n<p style=\"text-align: justify\">T\u1ed5ng h\u1ee3p <a href=\"http:\/\/blog.ezworkapp.com\/thu-thuat-excel\">th\u1ee7 thu\u1eadt Excel hay<\/a> nh\u1ea5t m\u1ecdi th\u1eddi \u0111\u1ea1i<\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"AP_DUNG_MAU_BANG_MA_KHONG_PHAI_TAO_BANG\"><\/span><strong>\u00c1P D\u1ee4NG M\u1eaaU B\u1ea2NG M\u00c0 KH\u00d4NG PH\u1ea2I T\u1ea0O B\u1ea2NG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n nhanh ch\u00f3ng \u0111\u1ecbnh d\u1ea1ng d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh v\u1edbi m\u1eabu b\u1ea3ng c\u00f3 s\u1eb5n trong Excel, nh\u01b0ng b\u1ea1n kh\u00f4ng mu\u1ed1n chuy\u1ec3n 1 d\u00e3y \u00f4 sang b\u1ea3ng Excel, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn d\u00e3y \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n th\u00eam m\u1eabu b\u1ea3ng.<\/li>\n<li>Trong tab <strong>Home<\/strong>, v\u00e0o <strong>Styles<\/strong>, ch\u1ecdn <strong>Format as Table<\/strong>, v\u00e0 ch\u1ecdn m\u1eabu b\u1ea3ng b\u1ea1n th\u00edch.<\/li>\n<li>Ch\u1ecdn \u00f4 b\u1ea5t k\u00ec trong b\u1ea3ng m\u1edbi t\u1ea1o, v\u00e0o tab <strong>Design &gt; Tools<\/strong>, v\u00e0 nh\u1ea5n <strong>Convert to Range<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4997 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/convert-excel-table-range.png\" width=\"332\" height=\"143\" title=\"convert-excel-table-range\">Ho\u1eb7c nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea3ng, ch\u1ecdn <strong>Table &gt; Convert to Range.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4998\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/convert-table-range-300x146-1.png\" width=\"600\" height=\"292\" title=\"convert-table-range-300x146-1\"><\/strong><\/li>\n<\/ol>\n<blockquote>\n<p>T\u00ecm hi\u1ec3u th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">T\u00e0i li\u1ec7u Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_XOA_DINH_DANG_BANG\"><\/span><strong>C\u00c1CH XO\u00c1 \u0110\u1ecaNH D\u1ea0NG B\u1ea2NG<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n gi\u1eef nh\u1eefng t\u00ednh n\u0103ng c\u1ee7a 1 b\u1ea3ng Excel nh\u01b0ng xo\u00e1 c\u00e1c \u0111\u1ecbnh d\u1ea1ng nh\u01b0 c\u00e1c h\u00e0ng m\u00e0u xen k\u1ebd, \u0111\u01b0\u1eddng vi\u1ec1n, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc:<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn 1 \u00f4 trong b\u1ea3ng.<\/li>\n<li>Trong tab <strong>Design<\/strong>, v\u00e0o <strong>Table Styles<\/strong>, ch\u1ecdn n\u00fat <strong>More<\/strong>.<\/li>\n<li>\u1ede ph\u00eda d\u01b0\u1edbi c\u00e1c m\u1eabu b\u1ea3ng, ch\u1ecdn <strong>Clear<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4999 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/remove-table-formatting.png\" width=\"580\" height=\"222\" title=\"remove-table-formatting\"><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>M\u1eb9o nh\u1ecf:<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 xo\u00e1 b\u1ea3ng nh\u01b0ng gi\u1eef s\u1ed1 li\u1ec7u v\u00e0 \u0111\u1ecbnh d\u1ea1ng, ch\u1ecdn tab <strong>Design &gt; Tools &gt; Convert to Range<\/strong>. Ho\u1eb7c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea3ng, <strong>Table &gt; Convert to Range<\/strong>.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ung_dung_cua_bang_trong_Pivot_Table\"><\/span>\u1ee8ng d\u1ee5ng c\u1ee7a b\u1ea3ng trong Pivot Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/3m8Ob2jqjMs\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_Slicer_de_loc_bang_du_lieu_trong_Excel\"><\/span>S\u1eed d\u1ee5ng Slicer \u0111\u1ec3 l\u1ecdc b\u1ea3ng d\u1eef li\u1ec7u trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Nwe0j_odO7E\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\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\/2w6YAe8\">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=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/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-340.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11974,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11973","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\/11973","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=11973"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11973\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11974"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}