{"id":4947,"date":"2025-11-20T15:41:53","date_gmt":"2025-11-20T08:41:53","guid":{"rendered":"https:\/\/autofillform.com\/blog\/6-cach-them-dong-trong-excel-cuc-nhanh-va-de\/"},"modified":"2025-11-20T15:41:53","modified_gmt":"2025-11-20T08:41:53","slug":"6-cach-them-dong-trong-excel-cuc-nhanh-va-de","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/6-cach-them-dong-trong-excel-cuc-nhanh-va-de\/","title":{"rendered":"6 C\u00e1ch th\u00eam d\u00f2ng trong Excel c\u1ef1c nhanh v\u00e0 d\u1ec5"},"content":{"rendered":"<div class=\"content_article\" id=\"clicklinka\">\n<div id=\"bxindexknh\">\u00a0<\/div>\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh, vi\u1ec7c th\u00eam d\u00f2ng m\u1edbi l\u00e0 thao t\u00e1c c\u01a1 b\u1ea3n gi\u00fap b\u1ea1n m\u1edf r\u1ed9ng v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft 6 c\u00e1ch th\u00eam d\u00f2ng trong Excel, t\u1eeb thao t\u00e1c b\u1eb1ng chu\u1ed9t, thanh Ribbon, ph\u00edm t\u1eaft cho \u0111\u1ebfn ch\u00e8n nhi\u1ec1u d\u00f2ng v\u00e0 trong b\u1ea3ng d\u1eef li\u1ec7u, gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n<p><img decoding=\"async\" alt=\"C\u00e1ch th\u00eam d\u00f2ng trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-1.jpg\" title=\"cach-them-dong-trong-excel-1\"><em>H\u01b0\u1edbng d\u1eabn 6 c\u00e1ch th\u00eam d\u00f2ng trong Excel c\u1ef1c nhanh<\/em><\/p>\n<div class=\"titletab\" id=\"titletab1\">\n<h2>1. C\u00e1ch th\u00eam d\u00f2ng trong Excel b\u1eb1ng c\u00f4ng c\u1ee5 Insert<\/h2>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>M\u1edf b\u1ea3ng d\u1eef li\u1ec7u trong Excel v\u00e0 di chuy\u1ec3n \u0111\u1ebfn v\u1ecb tr\u00ed mu\u1ed1n ch\u00e8n d\u00f2ng m\u1edbi. Nh\u1ea5p chu\u1ed9t v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a d\u00f2ng \u0111\u1ec3 ch\u1ecdn d\u00f2ng \u0111\u00f3.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o d\u00f2ng v\u1eeba ch\u1ecdn v\u00e0 ch\u1ecdn <strong>Insert<\/strong> trong danh s\u00e1ch hi\u1ec3n th\u1ecb.<\/p>\n<p>Ngay l\u1eadp t\u1ee9c, Excel s\u1ebd th\u00eam m\u1ed9t d\u00f2ng m\u1edbi \u1edf ph\u00eda tr\u00ean d\u00f2ng \u0111\u00e3 ch\u1ecdn.<\/p>\n<p><img decoding=\"async\" alt=\"Chu\u1ed9t ph\u1ea3i v\u00e0o s\u1ed1 d\u00f2ng v\u00e0 ch\u1ecdn Insert\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-2.jpg\" title=\"cach-them-dong-trong-excel-2\"><em>Ch\u1ecdn d\u00f2ng mu\u1ed1n ch\u00e8n v\u00e0 nh\u1ea5p chu\u1ed9t ph\u1ea3i \u0111\u1ec3 m\u1edf menu Insert<\/em><\/p>\n<p>Ngo\u00e0i ra, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u00e8n d\u00f2ng ch\u1ec9 b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1ed9t \u00f4 trong b\u1ea3ng, kh\u00f4ng c\u1ea7n ch\u1ecdn to\u00e0n b\u1ed9 d\u00f2ng.<\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 thu\u1ed9c v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n th\u00eam d\u00f2ng.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Ch\u1ecdn <strong>Insert<\/strong> t\u1eeb menu chu\u1ed9t ph\u1ea3i.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Trong h\u1ed9p tho\u1ea1i <strong>Insert<\/strong>, ch\u1ecdn t\u00f9y ch\u1ecdn <strong>Entire row (Ch\u00e8n th\u00eam h\u00e0ng)<\/strong> r\u1ed3i nh\u1ea5n <strong>OK<\/strong>. C\u00e1c l\u1ef1a ch\u1ecdn kh\u00e1c g\u1ed3m:<\/p>\n<ul>\n<li><strong>Shift cells right: <\/strong>D\u1ecbch c\u00e1c \u00f4 sang ph\u1ea3i.<\/li>\n<li><strong>Shift cells down: <\/strong>D\u1ecbch c\u00e1c \u00f4 xu\u1ed1ng d\u01b0\u1edbi.<\/li>\n<li><strong>Entire column: <\/strong>Th\u00eam c\u1ed9t m\u1edbi.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"H\u1ed9p tho\u1ea1i Insert ch\u1ecdn Entire row \u0111\u1ec3 th\u00eam d\u00f2ng m\u1edbi\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-3.jpg\" title=\"cach-them-dong-trong-excel-3\"><em>Ch\u1ecdn Entire row \u0111\u1ec3 th\u00eam h\u00e0ng m\u1edbi<\/em><\/p>\n<p>D\u00f2ng m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n ngay ph\u00eda tr\u00ean v\u1ecb tr\u00ed \u00f4 b\u1ea1n v\u1eeba ch\u1ecdn trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<div class=\"titletab\" id=\"titletab2\">\n<h2>2. C\u00e1ch ch\u00e8n d\u00f2ng trong Excel t\u1eeb thanh ribbon<\/h2>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5p v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a d\u00f2ng n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n th\u00eam d\u00f2ng m\u1edbi.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Tr\u00ean thanh c\u00f4ng c\u1ee5 <strong>Ribbon<\/strong>, m\u1edf th\u1ebb <strong>Home<\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong>Insert <\/strong>trong nh\u00f3m c\u00f4ng c\u1ee5 <strong>Cells<\/strong> (n\u1eb1m \u1edf g\u00f3c ph\u1ea3i c\u1ee7a thanh).<\/p>\n<p><img decoding=\"async\" alt=\"Th\u00eam d\u00f2ng trong Excel b\u1eb1ng th\u1ebb Home v\u1edbi l\u1ec7nh Insert trong nh\u00f3m Cells\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-5.jpg\" title=\"cach-them-dong-trong-excel-5\"><em>Th\u00eam d\u00f2ng m\u1edbi b\u1eb1ng c\u00f4ng c\u1ee5 Insert tr\u00ean thanh Ribbon<\/em><\/p>\n<p>Ngay sau thao t\u00e1c n\u00e0y, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam m\u1ed9t d\u00f2ng m\u1edbi ph\u00eda tr\u00ean d\u00f2ng b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/p>\n<div class=\"infobox\"><strong>Xem th\u00eam: <\/strong>C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel v\u00e0 h\u01b0\u1edbng d\u1eabn ch\u1ec9nh s\u1eeda, s\u1eed d\u1ee5ng<\/div>\n<div class=\"titletab\" id=\"titletab3\">\n<h2>3. C\u00e1ch ch\u00e8n d\u00f2ng trong Excel b\u1eb1ng ph\u00edm t\u1eaft<\/h2>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn d\u00f2ng c\u1ea7n ch\u00e8n b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a d\u00f2ng \u0111\u00f3 trong b\u1ea3ng Excel.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>S\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c t\u1ed5 h\u1ee3p ph\u00edm sau \u0111\u1ec3 th\u00eam d\u00f2ng m\u1edbi:<\/p>\n<ul>\n<li><strong>Ctrl + Shift + \u201c+\u201d: <\/strong>Ch\u00e8n d\u00f2ng m\u1edbi ph\u00eda tr\u00ean d\u00f2ng \u0111\u00e3 ch\u1ecdn (\u00e1p d\u1ee5ng cho h\u1ea7u h\u1ebft b\u00e0n ph\u00edm).<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"T\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + =\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-6.jpg\" title=\"cach-them-dong-trong-excel-6\"><em>S\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + \u201c+\u201d \u0111\u1ec3 ch\u00e8n d\u00f2ng trong Excel<\/em><\/p>\n<ul>\n<li><strong>Ctrl + \u201c+\u201d<\/strong> (ph\u00edm c\u1ed9ng tr\u00ean b\u00e0n ph\u00edm s\u1ed1): T\u00e1c d\u1ee5ng t\u01b0\u01a1ng t\u1ef1, d\u00e0nh cho m\u00e1y c\u00f3 b\u00e0n ph\u00edm s\u1ed1 ri\u00eang.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"Ph\u00edm t\u1eaft Ctrl + d\u1ea5u c\u1ed9ng tr\u00ean b\u00e0n ph\u00edm s\u1ed1\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-7.jpg\" title=\"cach-them-dong-trong-excel-7\"><em>D\u00f9ng ph\u00edm t\u1eaft Ctrl + \u201c+\u201d tr\u00ean b\u00e0n ph\u00edm s\u1ed1<\/em><\/p>\n<ul>\n<li><strong>Alt + I, r\u1ed3i nh\u1ea5n R:<\/strong> Gi\u1eef ph\u00edm Alt, sau \u0111\u00f3 nh\u1ea5n I (Insert) v\u00e0 ti\u1ebfp t\u1ee5c nh\u1ea5n R (Row) \u0111\u1ec3 th\u00eam d\u00f2ng m\u1edbi ngay ph\u00eda tr\u00ean d\u00f2ng \u0111ang ch\u1ecdn.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"T\u1ed5 h\u1ee3p Alt + I r\u1ed3i nh\u1ea5n R\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-8.jpg\" title=\"cach-them-dong-trong-excel-8\"><em>D\u00f9ng t\u1ed5 h\u1ee3p Alt + I, R \u0111\u1ec3 ch\u00e8n d\u00f2ng ngay ph\u00eda tr\u00ean d\u00f2ng \u0111ang ch\u1ecdn<\/em><\/p>\n<p>Sau khi thao t\u00e1c, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u00e8n th\u00eam m\u1ed9t ho\u1eb7c nhi\u1ec1u d\u00f2ng m\u1edbi t\u00f9y theo s\u1ed1 d\u00f2ng b\u1ea1n \u0111\u00e3 ch\u1ecdn tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p><img decoding=\"async\" alt=\"D\u00f2ng tr\u1ed1ng \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o gi\u1eefa b\u1ea3ng d\u1eef li\u1ec7u trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-9.jpg\" title=\"cach-them-dong-trong-excel-9\"><em>K\u1ebft qu\u1ea3 sau khi th\u00eam d\u00f2ng m\u1edbi trong b\u1ea3ng d\u1eef li\u1ec7u Excel<\/em><\/p>\n<div class=\"titletab\" id=\"titletab4\">\n<h2>4. C\u00e1ch th\u00eam nhi\u1ec1u d\u00f2ng c\u00f9ng m\u1ed9t l\u00fac trong Excel<\/h2>\n<\/div>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed v\u00e0 s\u1ed1 l\u01b0\u1ee3ng d\u00f2ng c\u1ea7n th\u00eam.<\/p>\n<ul>\n<li><strong>N\u1ebfu c\u00e1c d\u00f2ng n\u1eb1m li\u1ec1n nhau:<\/strong> K\u00e9o ch\u1ecdn to\u00e0n b\u1ed9 v\u00f9ng c\u1ea7n th\u00eam ho\u1eb7c nh\u1ea5n v\u00e0o d\u00f2ng \u0111\u1ea7u ti\u00ean, sau \u0111\u00f3 gi\u1eef <strong>Shift <\/strong>v\u00e0 ch\u1ecdn d\u00f2ng cu\u1ed1i c\u00f9ng.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"Ch\u1ecdn nhi\u1ec1u d\u00f2ng li\u00ean ti\u1ebfp trong Exce;\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-10.jpg\" title=\"cach-them-dong-trong-excel-10\"><em>Ch\u1ecdn nhi\u1ec1u d\u00f2ng li\u1ec1n nhau \u0111\u1ec3 ch\u00e8n \u0111\u1ed3ng th\u1eddi trong Excel<\/em><\/p>\n<ul>\n<li><strong>N\u1ebfu c\u00e1c d\u00f2ng kh\u00f4ng li\u1ec1n nhau:<\/strong> Gi\u1eef <strong>Ctrl<\/strong> r\u1ed3i l\u1ea7n l\u01b0\u1ee3t nh\u1ea5p v\u00e0o s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c d\u00f2ng mu\u1ed1n ch\u1ecdn.<\/li>\n<\/ul>\n<p><img decoding=\"async\" alt=\"Ch\u1ecdn c\u00e1c d\u00f2ng t\u00e1ch bi\u1ec7t trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-11.jpg\" title=\"cach-them-dong-trong-excel-11\"><em>Ch\u1ecdn c\u00e1c d\u00f2ng kh\u00f4ng li\u1ec1n nhau b\u1eb1ng ph\u00edm Ctrl tr\u01b0\u1edbc khi ch\u00e8n<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Sau khi ch\u1ecdn xong, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam nhi\u1ec1u d\u00f2ng b\u1eb1ng m\u1ed9t trong ba c\u00e1ch \u0111\u00e3 n\u00eau \u1edf ph\u1ea7n tr\u01b0\u1edbc:<\/p>\n<ul>\n<li>Ch\u00e8n d\u00f2ng b\u1eb1ng <strong>chu\u1ed9t ph\u1ea3i<\/strong> \u2192 <strong>Insert<\/strong><\/li>\n<li>Ch\u00e8n d\u00f2ng b\u1eb1ng thanh <strong>Ribbon<\/strong> (<strong>Home<\/strong> \u2192 <strong>Insert<\/strong>)<\/li>\n<li>Ch\u00e8n d\u00f2ng b\u1eb1ng ph\u00edm t\u1eaft (<strong>Ctrl + Shift + \u201c+\u201d<\/strong> ho\u1eb7c <strong>Alt + I <\/strong>\u2192 <strong>R<\/strong>)<\/li>\n<\/ul>\n<p>Excel s\u1ebd ngay l\u1eadp t\u1ee9c th\u00eam s\u1ed1 d\u00f2ng m\u1edbi t\u01b0\u01a1ng \u1ee9ng \u1edf ph\u00eda tr\u00ean v\u00f9ng b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/p>\n<p><img decoding=\"async\" alt=\"D\u00f2ng tr\u1ed1ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ph\u00eda tr\u00ean v\u1ecb tr\u00ed \u0111\u00e3 ch\u1ecdn trong b\u1ea3ng Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-12.jpg\" title=\"cach-them-dong-trong-excel-12\"><em>Th\u00eam nhi\u1ec1u d\u00f2ng c\u00f9ng l\u00fac b\u1eb1ng chu\u1ed9t ph\u1ea3i, Ribbon ho\u1eb7c ph\u00edm t\u1eaft<\/em><\/p>\n<div class=\"titletab\" id=\"titletab5\">\n<h2>5. Th\u00eam d\u00f2ng Excel v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u<\/h2>\n<\/div>\n<p>Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng (Table) trong Excel, \u0111\u00f4i khi b\u1ea1n c\u1ea7n th\u00eam d\u00f2ng m\u1edbi ch\u1ec9 trong ph\u1ea1m vi b\u1ea3ng, m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c v\u00f9ng d\u1eef li\u1ec7u kh\u00e1c tr\u00ean trang t\u00ednh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn d\u00f2ng ho\u1eb7c nh\u00f3m d\u00f2ng trong b\u1ea3ng n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n th\u00eam d\u00f2ng m\u1edbi.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn <strong>Insert<\/strong> \u2192 <strong>Table Rows Above<\/strong> t\u1eeb menu hi\u1ec3n th\u1ecb.<\/p>\n<p><img decoding=\"async\" alt=\"Ch\u00e8n d\u00f2ng trong b\u1ea3ng Excel b\u1eb1ng chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Table Rows Above\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-13.jpg\" title=\"cach-them-dong-trong-excel-13\"><em>Th\u00eam d\u00f2ng m\u1edbi trong ph\u1ea1m vi b\u1ea3ng b\u1eb1ng t\u00f9y ch\u1ecdn Table Rows Above<\/em><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Excel s\u1ebd th\u00eam c\u00e1c d\u00f2ng m\u1edbi ngay trong ph\u1ea1m vi b\u1ea3ng d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i m\u00e0 kh\u00f4ng l\u00e0m thay \u0111\u1ed5i c\u1ea5u tr\u00fac ho\u1eb7c s\u1ed1 d\u00f2ng, s\u1ed1 c\u1ed9t b\u00ean ngo\u00e0i b\u1ea3ng.<\/p>\n<div class=\"titletab\" id=\"titletab6\">\n<h2>6. Th\u00eam d\u00f2ng Excel d\u01b0\u1edbi d\u00f2ng \u0111\u00e3 ch\u1ecdn<\/h2>\n<\/div>\n<p><strong>C\u00e1ch 1: Ch\u1ecdn d\u00f2ng k\u1ebf ti\u1ebfp r\u1ed3i ch\u00e8n (Insert)<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>X\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed mu\u1ed1n th\u00eam d\u00f2ng m\u1edbi, sau \u0111\u00f3 ch\u1ecdn d\u00f2ng ngay b\u00ean d\u01b0\u1edbi v\u1ecb tr\u00ed \u0111\u00f3.<\/p>\n<p><strong>B\u01b0\u1edbc 2: <\/strong>Th\u1ef1c hi\u1ec7n thao t\u00e1c Insert b\u1eb1ng m\u1ed9t trong c\u00e1c c\u00e1ch:<\/p>\n<ul>\n<li>Nh\u1ea5p <strong>chu\u1ed9t ph\u1ea3i<\/strong> v\u00e0 ch\u1ecdn <strong>Insert<\/strong><\/li>\n<li>V\u00e0o <strong>Home<\/strong> \u2192 <strong>Insert<\/strong> \u2192 <strong>Insert Sheet Rows<\/strong><\/li>\n<li>Nh\u1ea5n <strong>Ctrl + Shift + \u201c+\u201d <\/strong>ho\u1eb7c <strong>Alt + I <\/strong>\u2192 <strong>R<\/strong><\/li>\n<\/ul>\n<p><strong>K\u1ebft qu\u1ea3: <\/strong>Excel s\u1ebd th\u00eam m\u1ed9t d\u00f2ng m\u1edbi ngay b\u00ean d\u01b0\u1edbi d\u00f2ng mong mu\u1ed1n ban \u0111\u1ea7u.<\/p>\n<p><strong>V\u00ed d\u1ee5: <\/strong>N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam d\u00f2ng d\u01b0\u1edbi d\u00f2ng 5, h\u00e3y ch\u1ecdn d\u00f2ng 6 r\u1ed3i ch\u1ecdn <strong>Insert<\/strong> \u2192 <strong>Excel<\/strong> s\u1ebd ch\u00e8n th\u00eam m\u1ed9t d\u00f2ng m\u1edbi gi\u1eefa d\u00f2ng 5 v\u00e0 d\u00f2ng 6.<\/p>\n<p><img decoding=\"async\" alt=\"D\u00f2ng tr\u1ed1ng \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o gi\u1eefa hai d\u00f2ng d\u1eef li\u1ec7u trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-14.jpg\" title=\"cach-them-dong-trong-excel-14\"><em>Ch\u00e8n th\u00eam d\u00f2ng m\u1edbi gi\u1eefa d\u00f2ng 5 v\u00e0 d\u00f2ng 6 trong Excel<\/em><\/p>\n<p><strong>C\u00e1ch 2: Th\u00eam d\u00f2ng b\u00ean d\u01b0\u1edbi b\u1eb1ng thao t\u00e1c chu\u1ed9t<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn d\u00f2ng m\u00e0 b\u1ea1n mu\u1ed1n th\u00eam d\u00f2ng m\u1edbi \u1edf b\u00ean d\u01b0\u1edbi.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn \u00f4 vu\u00f4ng nh\u1ecf m\u00e0u xanh l\u00e1 \u1edf g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a s\u1ed1 th\u1ee9 t\u1ef1 d\u00f2ng (\u0111i\u1ec3m ch\u1ed1t c\u1ee7a v\u00f9ng ch\u1ecdn) cho \u0111\u1ebfn khi con tr\u1ecf chu\u1ed9t chuy\u1ec3n th\u00e0nh d\u1ea5u c\u1ed9ng (<strong>+<\/strong>).<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> Nh\u1ea5n gi\u1eef ph\u00edm <strong>Shift<\/strong> r\u1ed3i k\u00e9o chu\u1ed9t xu\u1ed1ng \u0111\u1ec3 t\u1ea1o th\u00eam s\u1ed1 d\u00f2ng mong mu\u1ed1n.<\/p>\n<p><img decoding=\"async\" alt=\"K\u00e9o \u0111i\u1ec3m \u0111i\u1ec1u khi\u1ec3n \u1edf g\u00f3c \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng th\u00eam d\u00f2ng trong Excel\" src=\"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/cach-them-dong-trong-excel-15.jpg\" title=\"cach-them-dong-trong-excel-15\"><em>Th\u00eam d\u00f2ng b\u00ean d\u01b0\u1edbi b\u1eb1ng c\u00e1ch gi\u1eef ph\u00edm Shift v\u00e0 k\u00e9o chu\u1ed9t xu\u1ed1ng<\/em><\/p>\n<p>Th\u00eam d\u00f2ng trong Excel kh\u00f4ng h\u1ec1 kh\u00f3 n\u1ebfu b\u1ea1n \u00e1p d\u1ee5ng \u0111\u00fang thao t\u00e1c, t\u1eeb ch\u00e8n b\u1eb1ng chu\u1ed9t ph\u1ea3i, thanh Ribbon cho \u0111\u1ebfn ph\u00edm t\u1eaft nhanh. 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 s\u1eed d\u1ee5ng Excel hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang mu\u1ed1n n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb \u0111\u1ec3 l\u00e0m vi\u1ec7c ti\u1ec7n l\u1ee3i v\u00e0 linh ho\u1ea1t h\u01a1n, \u0111\u1eebng b\u1ecf l\u1ee1 c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7n \u0111\u1ea1i \u0111ang \u0111\u01b0\u1ee3c \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y &#8211; N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh, vi\u1ec7c th\u00eam d\u00f2ng m\u1edbi l\u00e0 thao t\u00e1c c\u01a1 b\u1ea3n gi\u00fap b\u1ea1n m\u1edf r\u1ed9ng v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn chi ti\u1ebft 6 c\u00e1ch th\u00eam d\u00f2ng trong Excel, t\u1eeb thao t\u00e1c b\u1eb1ng chu\u1ed9t, thanh Ribbon, ph\u00edm t\u1eaft cho \u0111\u1ebfn ch\u00e8n nhi\u1ec1u [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4948,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4947","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\/19395.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4947","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=4947"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4947\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4948"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}