{"id":4972,"date":"2025-11-20T15:44:30","date_gmt":"2025-11-20T08:44:30","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-tao-bang-trong-excel-va-huong-dan-chinh-sua-su-dung\/"},"modified":"2025-11-20T15:44:30","modified_gmt":"2025-11-20T08:44:30","slug":"cach-tao-bang-trong-excel-va-huong-dan-chinh-sua-su-dung","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-tao-bang-trong-excel-va-huong-dan-chinh-sua-su-dung\/","title":{"rendered":"C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel v\u00e0 h\u01b0\u1edbng d\u1eabn ch\u1ec9nh s\u1eeda, s\u1eed d\u1ee5ng"},"content":{"rendered":"<div class=\"content_article\" id=\"clicklinka\">\n<div id=\"bxindexknh\">\u00a0<\/div>\n<p>T\u1ea1o b\u1ea3ng trong Excel l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng \u0111\u1ec3 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 theo d\u00f5i. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch t\u1ea1o b\u1ea3ng b\u1eb1ng Insert Table, Format as Table v\u00e0 Border, k\u00e8m c\u00e1c thao t\u00e1c ch\u1ec9nh s\u1eeda, th\u00eam h\u00e0ng c\u1ed9t v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<p><img decoding=\"async\" alt=\"Giao di\u1ec7n Excel c\u00f9ng c\u00e1c m\u1eabu Format as Table nhi\u1ec1u ki\u1ec3u m\u00e0u kh\u00e1c nhau\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-1.jpg\" title=\"cach-tao-bang-trong-excel-1\"><em>C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel v\u00e0 ch\u1ec9nh s\u1eeda, s\u1eed d\u1ee5ng b\u1ea3ng<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1\">\n<h2>1. C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab1_1\">\n<h3>1.1. T\u1ea1o b\u1ea3ng b\u1eb1ng Insert Table<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea1i giao di\u1ec7n Excel, m\u1edf tab <strong>Insert<\/strong> v\u00e0 ch\u1ecdn <strong>Table<\/strong> \u0111\u1ec3 b\u1eaft \u0111\u1ea7u t\u1ea1o b\u1ea3ng.<\/p>\n<p><img decoding=\"async\" alt=\"Ch\u1ecdn Insert Table \u0111\u1ec3 t\u1ea1o b\u1ea3ng t\u1eeb v\u00f9ng d\u1eef li\u1ec7u trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-2.jpg\" title=\"cach-tao-bang-trong-excel-2\"><em>Ch\u1ecdn Insert Table \u0111\u1ec3 b\u1eaft \u0111\u1ea7u t\u1ea1o b\u1ea3ng trong Excel<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>H\u1ed9p tho\u1ea1i <strong>Create Table<\/strong> hi\u1ec7n l\u00ean. B\u1ea1n qu\u00e9t ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n chuy\u1ec3n th\u00e0nh b\u1ea3ng, sau \u0111\u00f3 nh\u1ea5n <strong>OK<\/strong>.<\/p>\n<p><strong>G\u1ee3i \u00fd: <\/strong>N\u1ebfu d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 h\u00e0ng ti\u00eau \u0111\u1ec1, h\u00e3y \u0111\u00e1nh d\u1ea5u v\u00e0o t\u00f9y ch\u1ecdn <strong>My table has headers<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"H\u1ed9p tho\u1ea1i Create Table hi\u1ec3n th\u1ecb v\u00f9ng d\u1eef li\u1ec7u v\u00e0 t\u00f9y ch\u1ecdn My table has headers\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-3.jpg\" title=\"cach-tao-bang-trong-excel-3\"><em>Thi\u1ebft l\u1eadp v\u00f9ng d\u1eef li\u1ec7u trong h\u1ed9p tho\u1ea1i Create Table<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1ecbnh d\u1ea1ng v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh m\u1ed9t b\u1ea3ng ho\u00e0n ch\u1ec9nh nh\u01b0 minh h\u1ecda b\u00ean d\u01b0\u1edbi.<\/p>\n<p><img decoding=\"async\" alt=\"D\u1eef li\u1ec7u \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh b\u1ea3ng v\u1edbi \u0111\u1ecbnh d\u1ea1ng Table trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-4.jpg\" title=\"cach-tao-bang-trong-excel-4\"><em>B\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea1o t\u1ef1 \u0111\u1ed9ng t\u1eeb v\u00f9ng \u0111\u00e3 ch\u1ecdn<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1_2\">\n<h3>1.2. T\u1ea1o b\u1ea3ng b\u1eb1ng Format as Table<\/h3>\n<\/div>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n b\u1ea3ng tr\u00f4ng n\u1ed5i b\u1eadt h\u01a1n, Excel c\u00f2n cung c\u1ea5p c\u00f4ng c\u1ee5 Format as Table v\u1edbi nhi\u1ec1u m\u1eabu \u0111\u1ecbnh d\u1ea1ng s\u1eb5n.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Truy c\u1eadp tab <strong>Home<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Format as Table<\/strong> trong nh\u00f3m <strong>Styles<\/strong>.<\/p>\n<p><img decoding=\"async\" alt=\"Ch\u1ecdn Format as Table t\u1eeb th\u1ebb Home\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-5.jpg\" title=\"cach-tao-bang-trong-excel-5\"><em>M\u1edf Format as Table trong tab Home<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Excel s\u1ebd hi\u1ec3n th\u1ecb h\u00e0ng lo\u1ea1t m\u1eabu b\u1ea3ng v\u1edbi tone m\u00e0u v\u00e0 b\u1ed1 c\u1ee5c kh\u00e1c nhau. H\u00e3y ch\u1ecdn m\u1ed9t ki\u1ec3u m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng.<\/p>\n<p><img decoding=\"async\" alt=\"Ch\u1ecdn m\u1eabu b\u1ea3ng trong Format as Table\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-6.jpg\" title=\"cach-tao-bang-trong-excel-6\"><em>L\u1ef1a ch\u1ecdn m\u1eabu b\u1ea3ng trong Format as Table<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>H\u1ed9p tho\u1ea1i <strong>Create Table<\/strong> hi\u1ec7n ra. B\u1ea1n qu\u00e9t v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0a v\u00e0o b\u1ea3ng r\u1ed3i nh\u1ea5n <strong>OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t.<\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong>N\u1ebfu d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 ti\u00eau \u0111\u1ec1, h\u00e3y tick v\u00e0o <strong>My table has headers<\/strong> \u0111\u1ec3 Excel nh\u1eadn di\u1ec7n \u0111\u00fang c\u1ea5u tr\u00fac b\u1ea3ng.<\/p>\n<p><img decoding=\"async\" alt=\"H\u1ed9p tho\u1ea1i Format As Table x\u00e1c nh\u1eadn ph\u1ea1m vi d\u1eef li\u1ec7u v\u00e0 d\u00f2ng ti\u00eau \u0111\u1ec1\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-7.jpg\" title=\"cach-tao-bang-trong-excel-7\"><em>X\u00e1c nh\u1eadn v\u00f9ng d\u1eef li\u1ec7u khi \u00e1p d\u1ee5ng Format as Table<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1_3\">\n<h3>1.3. T\u1ea1o b\u1ea3ng b\u1eb1ng Border<\/h3>\n<\/div>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 t\u1ea1o c\u00e1c \u0111\u01b0\u1eddng vi\u1ec1n gi\u00fap d\u1eef li\u1ec7u t\u00e1ch bi\u1ec7t v\u00e0 d\u1ec5 quan s\u00e1t, d\u00f9 kh\u00f4ng t\u1ea1o b\u1ea3ng theo c\u1ea5u tr\u00fac t\u1ef1 \u0111\u1ed9ng nh\u01b0 Table.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> B\u00f4i \u0111en v\u00f9ng \u00f4 b\u1ea1n mu\u1ed1n k\u1ebb b\u1ea3ng.<\/p>\n<p><img decoding=\"async\" alt=\"V\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c b\u00f4i ch\u1ecdn\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-8.jpg\" title=\"cach-tao-bang-trong-excel-8\"><em>B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u tr\u01b0\u1edbc khi k\u1ebb b\u1ea3ng b\u1eb1ng Border<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>V\u00e0o tab <strong>Home<\/strong>, ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng <strong>Borders<\/strong>, sau \u0111\u00f3 nh\u1ea5n <strong>All Borders <\/strong>\u0111\u1ec3 \u00e1p d\u1ee5ng vi\u1ec1n cho to\u00e0n b\u1ed9 v\u00f9ng \u0111\u00e3 ch\u1ecdn.<\/p>\n<p><img decoding=\"async\" alt=\"Ch\u1ecdn All Borders trong th\u1ebb Home \u0111\u1ec3 t\u1ea1o \u0111\u01b0\u1eddng vi\u1ec1n cho b\u1ea3ng d\u1eef li\u1ec7u\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-9.jpg\" title=\"cach-tao-bang-trong-excel-9\"><em>\u00c1p d\u1ee5ng All Borders \u0111\u1ec3 t\u1ea1o \u0111\u01b0\u1eddng vi\u1ec1n cho b\u1ea3ng<\/em><\/p>\n<p>Sau khi th\u1ef1c hi\u1ec7n, c\u00e1c \u00f4 s\u1ebd \u0111\u01b0\u1ee3c ph\u00e2n t\u00e1ch r\u00f5 r\u00e0ng b\u1eb1ng \u0111\u01b0\u1eddng vi\u1ec1n theo \u0111\u00fang ph\u1ea1m vi b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/p>\n<p><img decoding=\"async\" alt=\"B\u1ea3ng d\u1eef li\u1ec7u Excel sau khi th\u00eam \u0111\u01b0\u1eddng vi\u1ec1n \u0111\u1ea7y \u0111\u1ee7\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-10.jpg\" title=\"cach-tao-bang-trong-excel-10\"><em>K\u1ebft qu\u1ea3 sau khi \u00e1p d\u1ee5ng vi\u1ec1n All Borders cho v\u00f9ng d\u1eef li\u1ec7u<\/em><\/p>\n<div class=\"infobox\"><strong>Xem th\u00eam: <\/strong>T\u1ed5ng h\u1ee3p 9 Th\u00f4ng b\u00e1o m\u00e3 l\u1ed7i trong Excel v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i<\/div>\n<div class=\"titletab\" id=\"titletab2\">\n<h2>2. C\u00e1ch ch\u1ec9nh s\u1eeda \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng trong Excel<\/h2>\n<\/div>\n<p>Sau khi t\u1ea1o b\u1ea3ng, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh l\u1ea1i giao di\u1ec7n v\u00e0 c\u00e1ch hi\u1ec3n th\u1ecb th\u00f4ng tin th\u00f4ng qua c\u00f4ng c\u1ee5 Table Tools.<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng d\u1eef li\u1ec7u. Khi \u0111\u00f3, Excel s\u1ebd k\u00edch ho\u1ea1t nh\u00f3m <strong>Table Tools<\/strong>. Nh\u1ea5n v\u00e0o tab <strong>Design<\/strong> \u0111\u1ec3 m\u1edf c\u00e1c t\u00f9y ch\u1ecdn ch\u1ec9nh s\u1eeda.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Trong ph\u1ea7n <strong>Table Style Options<\/strong>, b\u1ea1n s\u1ebd th\u1ea5y c\u00e1c l\u1ef1a ch\u1ecdn sau:<\/p>\n<ul>\n<li><strong>Header Row: <\/strong>B\u1eadt\/t\u1eaft h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng.<\/li>\n<li><strong>Total Row:<\/strong> Th\u00eam h\u00e0ng t\u1ed5ng \u1edf cu\u1ed1i b\u1ea3ng \u0111\u1ec3 t\u00ednh to\u00e1n nhanh (nh\u01b0 Sum, Average\u2026).<\/li>\n<li><strong>Banded Rows:<\/strong> T\u1ea1o hi\u1ec7u \u1ee9ng xen k\u1ebd m\u00e0u gi\u1eefa c\u00e1c d\u00f2ng.<\/li>\n<li><strong>First Column:<\/strong> \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng n\u1ed5i b\u1eadt cho c\u1ed9t \u0111\u1ea7u.<\/li>\n<li><strong>Last Column: <\/strong>L\u00e0m n\u1ed5i b\u1eadt c\u1ed9t cu\u1ed1i.<\/li>\n<li><strong>Banded Columns: <\/strong>T\u00f4 m\u00e0u xen k\u1ebd gi\u1eefa c\u00e1c c\u1ed9t.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"T\u00f9y ch\u1ecdn Table Tools trong th\u1ebb Design hi\u1ec3n th\u1ecb c\u00e1c thi\u1ebft l\u1eadp\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-11.jpg\" title=\"cach-tao-bang-trong-excel-11\"><em>Ch\u1ecdn ki\u1ec3u hi\u1ec3n th\u1ecb b\u1ea3ng t\u1ea1i m\u1ee5c Table Style Options<\/em><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 tick ho\u1eb7c b\u1ecf tick \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh c\u00e1c t\u00f9y ch\u1ecdn n\u00e0y t\u00f9y theo nhu c\u1ea7u.<\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>T\u00f9y ch\u1ec9nh b\u1ea3ng theo mong mu\u1ed1n. Ch\u1eb3ng h\u1ea1n, n\u1ebfu c\u1ea7n hi\u1ec3n th\u1ecb d\u00f2ng t\u1ed5ng c\u1ed9ng, ch\u1ec9 c\u1ea7n k\u00edch ho\u1ea1t <strong>Total Row<\/strong> l\u00e0 Excel s\u1ebd t\u1ef1 th\u00eam h\u00e0ng t\u00ednh to\u00e1n \u1edf cu\u1ed1i b\u1ea3ng.<\/p>\n<p><img decoding=\"async\" alt=\"B\u1ea3ng Excel \u0111\u01b0\u1ee3c b\u1eadt Total Row \u0111\u1ec3 t\u00ednh t\u1ed5ng t\u1ef1 \u0111\u1ed9ng \u1edf cu\u1ed1i b\u1ea3ng\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-12.jpg\" title=\"cach-tao-bang-trong-excel-12\"><em>B\u1eadt Total Row \u0111\u1ec3 th\u00eam d\u00f2ng t\u00ednh t\u1ed5ng trong b\u1ea3ng Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab3\">\n<h2>3. C\u00e1ch x\u00f3a b\u1ea3ng trong Excel<\/h2>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng b\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n x\u00f3a.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n ph\u00edm <strong>Delete<\/strong> \u0111\u1ec3 x\u00f3a nhanh, ho\u1eb7c v\u00e0o tab <strong>Home<\/strong>, ch\u1ecdn <strong>Clear<\/strong> \u2192 <strong>Clear All<\/strong> \u0111\u1ec3 x\u00f3a s\u1ea1ch n\u1ed9i dung l\u1eabn \u0111\u1ecbnh d\u1ea1ng.<\/p>\n<p><img decoding=\"async\" alt=\"X\u00f3a to\u00e0n b\u1ed9 \u0111\u1ecbnh d\u1ea1ng b\u1ea3ng b\u1eb1ng Clear All trong th\u1ebb Home c\u1ee7a Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-13.jpg\" title=\"cach-tao-bang-trong-excel-13\"><em>X\u00f3a to\u00e0n b\u1ed9 b\u1ea3ng b\u1eb1ng Delete ho\u1eb7c l\u1ec7nh Clear All trong Excel<\/em><\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong>Khi x\u00f3a b\u1ea3ng, to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong v\u00f9ng \u0111\u00f3 s\u1ebd bi\u1ebfn m\u1ea5t, v\u00ec v\u1eady b\u1ea1n n\u00ean sao l\u01b0u tr\u01b0\u1edbc n\u1ebfu c\u1ea7n gi\u1eef l\u1ea1i th\u00f4ng tin.<\/p>\n<div class=\"titletab\" id=\"titletab4\">\n<h2>4. C\u00e1ch s\u1eed d\u1ee5ng b\u1ea3ng trong Excel<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab4_1\">\n<h3>4.1. Th\u00eam h\u00e0ng, c\u1ed9t trong b\u1ea3ng<\/h3>\n<\/div>\n<p>N\u1ebfu b\u1ea1n c\u1ea7n m\u1edf r\u1ed9ng b\u1ea3ng sau khi t\u1ea1o, Excel cho ph\u00e9p ch\u00e8n th\u00eam h\u00e0ng v\u00e0 c\u1ed9t r\u1ea5t d\u1ec5 d\u00e0ng.<\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n ch\u00e8n h\u00e0ng ho\u1eb7c c\u1ed9t m\u1edbi.<\/p>\n<p><strong>B\u01b0\u1edbc 2: B\u00f4i \u0111en<\/strong> h\u00e0ng ho\u1eb7c c\u1ed9t li\u00ean quan r\u1ed3i <strong>nh\u1ea5p chu\u1ed9t ph\u1ea3i<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3: <\/strong>Ch\u1ecdn <strong>Insert<\/strong>, sau \u0111\u00f3 ch\u1ecdn ki\u1ec3u ch\u00e8n t\u01b0\u01a1ng \u1ee9ng (h\u00e0ng ho\u1eb7c c\u1ed9t).<\/p>\n<p><img decoding=\"async\" alt=\"Ch\u00e8n th\u00eam c\u1ed9t m\u1edbi trong Excel b\u1eb1ng l\u1ec7nh Insert t\u1eeb menu chu\u1ed9t ph\u1ea3i\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-14.jpg\" title=\"cach-tao-bang-trong-excel-14\"><em>Ch\u00e8n th\u00eam h\u00e0ng ho\u1eb7c c\u1ed9t m\u1edbi v\u00e0o b\u1ea3ng Excel<\/em><\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong> H\u00e0ng m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c th\u00eam ph\u00eda tr\u00ean h\u00e0ng \u0111\u00e3 ch\u1ecdn, v\u00e0 c\u1ed9t m\u1edbi s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf b\u00ean tr\u00e1i c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<div class=\"titletab\" id=\"titletab4_2\">\n<h3>4.2. G\u1ed9p h\u00e0ng, c\u1ed9t<\/h3>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn nh\u00f3m \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n g\u1ed9p l\u1ea1i th\u00e0nh m\u1ed9t \u00f4 duy nh\u1ea5t.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> V\u00e0o tab <strong>Home<\/strong> v\u00e0 nh\u1ea5n <strong>Merge &amp; Center<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n g\u1ed9p \u00f4.<\/p>\n<p><img decoding=\"async\" alt=\"G\u1ed9p v\u00e0 c\u0103n gi\u1eefa c\u00e1c \u00f4 b\u1eb1ng c\u00f4ng c\u1ee5 Merge &amp; Center trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-15.jpg\" title=\"cach-tao-bang-trong-excel-15\"><em>G\u1ed9p c\u00e1c \u00f4 trong b\u1ea3ng b\u1eb1ng Merge &amp; Center<\/em><\/p>\n<p><strong>L\u01b0u \u00fd: <\/strong>T\u00ednh n\u0103ng n\u00e0y ch\u1ec9 ph\u00f9 h\u1ee3p khi b\u1ea1n \u0111ang s\u1eed d\u1ee5ng b\u1ea3ng \u0111\u01b0\u1ee3c k\u1ebb b\u1eb1ng Border, kh\u00f4ng \u00e1p d\u1ee5ng cho b\u1ea3ng \u0111\u01b0\u1ee3c t\u1ea1o b\u1eb1ng c\u00f4ng c\u1ee5 Table.<\/p>\n<div class=\"titletab\" id=\"titletab4_3\">\n<h3>4.3. Di chuy\u1ec3n h\u00e0ng, c\u1ed9t<\/h3>\n<\/div>\n<p>N\u1ebfu c\u1ea7n thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t h\u00e0ng ho\u1eb7c c\u1ed9t m\u00e0 kh\u00f4ng mu\u1ed1n sao ch\u00e9p hay nh\u1eadp l\u1ea1i d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn to\u00e0n b\u1ed9 h\u00e0ng ho\u1eb7c c\u1ed9t c\u1ea7n di chuy\u1ec3n.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>\u0110\u01b0a chu\u1ed9t \u0111\u1ebfn c\u1ea1nh v\u00f9ng ch\u1ecdn cho \u0111\u1ebfn khi con tr\u1ecf \u0111\u1ed5i sang bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean b\u1ed1n chi\u1ec1u. Gi\u1eef chu\u1ed9t v\u00e0 k\u00e9o \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1eb7t.<\/p>\n<p><img decoding=\"async\" alt=\"So s\u00e1nh tr\u01b0\u1edbc v\u00e0 sau khi di chuy\u1ec3n c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-16.jpg\" title=\"cach-tao-bang-trong-excel-16\"><em>Di chuy\u1ec3n h\u00e0ng ho\u1eb7c c\u1ed9t sang v\u1ecb tr\u00ed m\u1edbi trong Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab4_4\">\n<h3>4.4. Thi\u1ebft k\u1ebf l\u1ea1i b\u1ea3ng<\/h3>\n<\/div>\n<p>\u0110\u1ec3 ch\u1ec9nh l\u1ea1i ki\u1ec3u hi\u1ec3n th\u1ecb c\u1ee7a b\u1ea3ng, h\u00e3y ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng. Sau \u0111\u00f3 v\u00e0o tab <strong>Table Tools<\/strong> \u2192 <strong>Design<\/strong> v\u00e0 ch\u1ecdn m\u1ed9t m\u1eabu <strong>Table Style<\/strong> ph\u00f9 h\u1ee3p v\u1edbi nhu c\u1ea7u c\u1ee7a b\u1ea1n.<\/p>\n<p><img decoding=\"async\" alt=\"\u00c1p d\u1ee5ng ki\u1ec3u b\u1ea3ng trong Table Tools Design b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1eabu Format as Table\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-tao-bang-trong-excel-17.jpg\" title=\"cach-tao-bang-trong-excel-17\"><em>\u0110\u1ed5i m\u1eabu thi\u1ebft k\u1ebf b\u1ea3ng b\u1eb1ng Table Style trong tab Design<\/em><\/p>\n<div class=\"titletab\" id=\"titletab5\">\n<h2>5. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n<\/div>\n<div class=\"titletab\" id=\"titletab5_1\">\n<h3>5.1. T\u1ea1o b\u1ea3ng b\u1eb1ng Insert Table c\u00f3 kh\u00e1c Format as Table kh\u00f4ng?<\/h3>\n<\/div>\n<p>Hai c\u00e1ch th\u1ef1c hi\u1ec7n kh\u00e1c nhau v\u1ec1 v\u1ecb tr\u00ed thao t\u00e1c nh\u01b0ng k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng l\u00e0 gi\u1ed1ng nhau: Excel \u0111\u1ec1u t\u1ea1o ra m\u1ed9t b\u1ea3ng (Table) v\u1edbi \u0111\u1ea7y \u0111\u1ee7 t\u00ednh n\u0103ng nh\u01b0 l\u1ecdc d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng t\u1ef1 \u0111\u1ed9ng, t\u00f9y ch\u1ecdn Total Row, \u0111\u1ed5i ki\u1ec3u b\u1ea3ng\u2026<\/p>\n<ul>\n<li><strong>Insert<\/strong> \u2192 <strong>Table<\/strong>: T\u1ea1o b\u1ea3ng theo c\u00e1ch tr\u1ef1c ti\u1ebfp v\u00e0 \u0111\u01a1n gi\u1ea3n, kh\u00f4ng c\u00f3 nhi\u1ec1u ki\u1ec3u b\u1ea3ng hi\u1ec3n th\u1ecb tr\u01b0\u1edbc khi ch\u1ecdn.<\/li>\n<li><strong>Format as Table<\/strong>: Cho ph\u00e9p b\u1ea1n ch\u1ecdn ki\u1ec3u b\u1ea3ng (m\u00e0u s\u1eafc, b\u1ed1 c\u1ee5c) ngay t\u1eeb \u0111\u1ea7u, tr\u1ef1c quan h\u01a1n v\u1ec1 m\u1eb7t thi\u1ebft k\u1ebf.<\/li>\n<\/ul>\n<div class=\"titletab\" id=\"titletab5_2\">\n<h3>5.2. C\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1c c\u00e1ch t\u1ea1o b\u1ea3ng trong Excel tr\u00ean phi\u00ean b\u1ea3n n\u00e0o?<\/h3>\n<\/div>\n<p>C\u00e1c c\u00e1ch t\u1ea1o b\u1ea3ng \u0111\u1ec1u d\u00f9ng \u0111\u01b0\u1ee3c tr\u00ean h\u1ea7u h\u1ebft phi\u00ean b\u1ea3n Excel t\u1eeb 2007 tr\u1edf l\u00ean, bao g\u1ed3m Excel 2010, 2013, 2016, 2019, 2021 v\u00e0 Microsoft 365.<\/p>\n<p>Vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c c\u00e1ch t\u1ea1o v\u00e0 ch\u1ec9nh s\u1eeda b\u1ea3ng gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel nhanh h\u01a1n v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam nhi\u1ec1u m\u1eb9o hay cho c\u00f4ng vi\u1ec7c h\u1eb1ng ng\u00e0y.<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang c\u1ea7n n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb cho c\u00f4ng vi\u1ec7c hay h\u1ecdc t\u1eadp, h\u00e3y tham kh\u1ea3o c\u00e1c m\u1eabu \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh b\u1ea3ng m\u1edbi t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn \u0111\u01b0\u1ee3c s\u1ea3n ph\u1ea9m ph\u00f9 h\u1ee3p.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 T\u1ea1o b\u1ea3ng trong Excel l\u00e0 b\u01b0\u1edbc quan tr\u1ecdng \u0111\u1ec3 tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 theo d\u00f5i. Trong b\u00e0i vi\u1ebft n\u00e0y, b\u1ea1n s\u1ebd h\u1ecdc c\u00e1ch t\u1ea1o b\u1ea3ng b\u1eb1ng Insert Table, Format as Table v\u00e0 Border, k\u00e8m c\u00e1c thao t\u00e1c ch\u1ec9nh s\u1eeda, th\u00eam h\u00e0ng c\u1ed9t v\u00e0 t\u1ed1i \u01b0u b\u1ea3ng \u0111\u1ec3 l\u00e0m vi\u1ec7c hi\u1ec7u [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4973,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4972","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19393.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=4972"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4972\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4973"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}