{"id":5077,"date":"2025-11-21T14:16:18","date_gmt":"2025-11-21T07:16:18","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-chen-them-cot-vao-excel-de-hieu-de-thuc-hien\/"},"modified":"2025-11-21T14:16:18","modified_gmt":"2025-11-21T07:16:18","slug":"cach-chen-them-cot-vao-excel-de-hieu-de-thuc-hien","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-chen-them-cot-vao-excel-de-hieu-de-thuc-hien\/","title":{"rendered":"C\u00e1ch ch\u00e8n th\u00eam c\u1ed9t v\u00e0o Excel d\u1ec5 hi\u1ec3u, d\u1ec5 th\u1ef1c hi\u1ec7n"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Ch\u00e8n th\u00eam c\u1ed9t trong Excel gi\u00fap b\u1ea1n m\u1edf r\u1ed9ng b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 b\u1ed5 sung th\u00f4ng tin m\u1ed9t c\u00e1ch linh ho\u1ea1t. Excel h\u1ed7 tr\u1ee3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 th\u00eam c\u1ed9t, t\u1eeb thao t\u00e1c chu\u1ed9t \u0111\u1ebfn ph\u00edm t\u1eaft, ph\u00f9 h\u1ee3p cho c\u1ea3 ng\u01b0\u1eddi m\u1edbi l\u1eabn ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng xuy\u00ean. N\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n ch\u00e8n m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t v\u00e0o \u0111\u00fang v\u1ecb tr\u00ed nhanh v\u00e0 ch\u00ednh x\u00e1c.<\/p>\n

\"GiaoCh\u00e8n th\u00eam c\u1ed9t v\u00e0o Excel b\u1eb1ng nhi\u1ec1u c\u00e1ch<\/em><\/p>\n

\n

1. C\u00e1ch ch\u00e8n th\u00eam c\u1ed9t v\u00e0o Excel b\u1eb1ng ph\u00edm t\u1eaft<\/h2>\n<\/div>\n

B\u01b0\u1edbc 1: <\/strong>Tr\u00ean thanh ti\u00eau \u0111\u1ec1 c\u1ed9t (h\u00e0ng ch\u1eef c\u00e1i A, B, C\u2026 \u1edf \u0111\u1ea7u m\u1ed7i c\u1ed9t), h\u00e3y nh\u1ea5p v\u00e0o ch\u1eef c\u00e1i c\u1ee7a c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n th\u00eam c\u1ed9t m\u1edbi. Ti\u1ebfp theo s\u1eed d\u1ee5ng ph\u00edm t\u1eaft Ctrl + Space<\/strong> \u0111\u1ec3 ch\u1ecdn nhanh c\u1ea3 c\u1ed9t.<\/p>\n

\"Ch\u1ecdnCh\u1ecdn ti\u00eau \u0111\u1ec1 c\u1ed9t B<\/em><\/p>\n

B\u01b0\u1edbc 2: <\/strong>Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Shift + \u201c+\u201d<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n l\u1ec7nh ch\u00e8n c\u1ed9t. Khi \u0111\u00f3, Excel s\u1ebd t\u1ea1o ngay m\u1ed9t c\u1ed9t m\u1edbi \u1edf ph\u00eda b\u00ean tr\u00e1i v\u1ecb tr\u00ed b\u1ea1n \u0111\u00e3 ch\u1ecdn.<\/p>\n

\"C\u1ed9tC\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o<\/em><\/p>\n

\n

2. C\u00e1ch ch\u00e8n th\u00eam c\u1ed9t v\u00e0o Excel b\u1eb1ng Insert<\/h2>\n<\/div>\n
\n

2.1 Ch\u00e8n t\u1ea1i 1 \u00f4 b\u1ea5t k\u1ef3<\/h3>\n<\/div>\n

B\u01b0\u1edbc 1:<\/strong> Tr\u00ean h\u00e0ng ch\u1eef c\u00e1i ti\u00eau \u0111\u1ec1 c\u1ee7a Excel (A, B, C, \u2026), h\u00e3y nh\u1ea5p v\u00e0o ch\u1eef c\u00e1i c\u1ee7a c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n th\u00eam c\u1ed9t.<\/p>\n

\"X\u00e1cB\u00f4i \u0111en c\u1ed9t c\u1ea7n ch\u00e8n<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 \u00f4 trong c\u1ed9t \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn \u1edf b\u01b0\u1edbc 1, sau \u0111\u00f3 nh\u1ea5n Insert<\/strong> \u0111\u1ec3 th\u00eam c\u1ed9t m\u1edbi.<\/p>\n

\"M\u1edfNh\u1ea5p chu\u1ed9t ph\u1ea3i ch\u1ecdn Insert<\/em><\/p>\n

\n

2.2 Ch\u00e8n nhi\u1ec1u c\u1ed9t m\u1ed9t l\u00fac<\/h3>\n<\/div>\n

B\u01b0\u1edbc 1: <\/strong>Qu\u00e9t b\u00f4i \u0111en c\u00e1c c\u1ed9t t\u1ea1i v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n th\u00eam c\u1ed9t m\u1edbi. S\u1ed1 c\u1ed9t \u0111\u01b0\u1ee3c b\u00f4i \u0111\u1eadm s\u1ebd t\u01b0\u01a1ng \u1ee9ng v\u1edbi s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t Excel th\u00eam v\u00e0o. V\u00ed d\u1ee5: b\u00f4i \u0111en 2 c\u1ed9t \u0111\u1ec3 ch\u00e8n 2 c\u1ed9t m\u1edbi, b\u00f4i \u0111en 4 c\u1ed9t \u0111\u1ec3 ch\u00e8n 4 c\u1ed9t m\u1edbi.<\/p>\n

\"Ch\u1ecdnB\u00f4i \u0111en c\u00e1c c\u1ed9t c\u1ea7n ch\u00e8n th\u00eam c\u1ed9t m\u1edbi<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o v\u00f9ng c\u1ed9t \u0111ang \u0111\u01b0\u1ee3c b\u00f4i \u0111en v\u00e0 nh\u1ea5n Insert.<\/strong> Excel s\u1ebd th\u00eam c\u00e1c c\u1ed9t m\u1edbi v\u00e0o ngay v\u1ecb tr\u00ed \u0111\u00f3.<\/p>\n

Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp tab Home<\/strong>, v\u00e0o nh\u00f3m Cells<\/strong>, sau \u0111\u00f3 nh\u1ea5n Insert<\/strong> \u2192 Insert Columns<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c.<\/p>\n

\"Nh\u1ea5pCh\u00e8n c\u1ed9t b\u1eb1ng menu Insert<\/em><\/p>\n

\n

2.3 Ch\u00e8n th\u00eam c\u1ed9t \u1edf 2 v\u1ecb tr\u00ed kh\u00e1c nhau<\/h3>\n<\/div>\n

B\u01b0\u1edbc 1: <\/strong>X\u00e1c \u0111\u1ecbnh c\u00e1c v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n th\u00eam c\u1ed9t trong Excel b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o c\u1ed9t \u0111\u1ea7u ti\u00ean c\u1ea7n ch\u00e8n, sau \u0111\u00f3 gi\u1eef ph\u00edm Ctrl<\/strong> v\u00e0 ti\u1ebfp t\u1ee5c nh\u1ea5p v\u00e0o nh\u1eefng c\u1ed9t kh\u00e1c m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n th\u00eam \u1edf c\u00e1c v\u1ecb tr\u00ed ti\u1ebfp theo.<\/p>\n

\"B\u00f4iB\u00f4i \u0111en hai c\u1ed9t \u1edf hai v\u1ecb tr\u00ed kh\u00e1c nhau<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Sau khi \u0111\u00e3 x\u00e1c \u0111\u1ecbnh xong c\u00e1c c\u1ed9t c\u1ea7n thao t\u00e1c, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong v\u00f9ng c\u1ed9t \u0111ang \u0111\u01b0\u1ee3c b\u00f4i \u0111en, r\u1ed3i ch\u1ecdn Insert<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n ch\u00e8n c\u1ed9t. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c tr\u00ean thanh c\u00f4ng c\u1ee5 theo Home<\/strong> \u2192 Insert<\/strong> \u2192 Insert Column<\/strong>.<\/p>\n

\"Ch\u1ecdnCh\u1ecdn Insert \u0111\u1ec3 th\u00eam c\u1ed9t<\/em><\/p>\n

Xem th\u00eam: <\/strong>Nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda l\u1ed7i kh\u00f4ng nh\u1ea3y c\u00f4ng th\u1ee9c trong Excel<\/div>\n
\n

2.4 Ch\u00e8n C\u1ed9t t\u1ea1i Table Excel<\/h3>\n<\/div>\n

Tr\u01b0\u1eddng h\u1ee3p 1: Th\u00eam m\u1ed9t c\u1ed9t v\u00e0o v\u1ecb tr\u00ed gi\u1eefa b\u1ea3ng<\/strong><\/p>\n

B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t c\u1ea7n ch\u00e8n, sau \u0111\u00f3 ch\u1ecdn Insert<\/strong> \u2192 Table Columns to the Left<\/strong> \u0111\u1ec3 th\u00eam m\u1ed9t c\u1ed9t m\u1edbi \u1edf b\u00ean tr\u00e1i.<\/p>\n

\"T\u00f9yCh\u1ecdn Table Columns to the Left<\/em><\/p>\n

B\u01b0\u1edbc 2:<\/strong> Excel s\u1ebd t\u1ea1o th\u00eam m\u1ed9t c\u1ed9t v\u1edbi t\u00ean m\u1eb7c \u0111\u1ecbnh Column1<\/strong>.<\/p>\n

\"C\u1ed9tC\u1ed9t m\u1edbi Column1 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1ea3ng<\/em><\/p>\n

Tr\u01b0\u1eddng h\u1ee3p 2: Th\u00eam m\u1ed9t c\u1ed9t t\u1ea1i v\u1ecb tr\u00ed cu\u1ed1i b\u1ea3ng<\/strong><\/p>\n

B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t cu\u1ed1i c\u00f9ng, ti\u1ebfp theo ch\u1ecdn Insert. L\u00fac n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn:<\/p>\n

    \n
  • Table Columns to the Right<\/strong> \u0111\u1ec3 th\u00eam c\u1ed9t m\u1edbi \u1edf b\u00ean ph\u1ea3i c\u1ed9t cu\u1ed1i.<\/li>\n
  • Table Columns to the Left<\/strong> n\u1ebfu mu\u1ed1n ch\u00e8n c\u1ed9t m\u1edbi v\u00e0o b\u00ean tr\u00e1i.<\/li>\n<\/ul>\n

    \"Ch\u1ecdnCh\u1ecdn Table Column to the Right<\/em><\/p>\n

    B\u01b0\u1edbc 2: <\/strong>C\u1ed9t m\u1edbi s\u1ebd xu\u1ea5t hi\u1ec7n t\u1ea1i v\u1ecb tr\u00ed \u0111\u00e3 ch\u1ecdn, v\u1edbi t\u00ean m\u1eb7c \u0111\u1ecbnh Column1<\/strong>.<\/p>\n

    \"C\u1ed9tC\u1ed9t m\u1edbi Column1 \u0111\u01b0\u1ee3c th\u00eam b\u1ea3ng<\/em><\/p>\n

    \n

    3. X\u00f3a c\u1ed9t trong Excel nh\u01b0 th\u1ebf n\u00e0o?<\/h2>\n<\/div>\n

    B\u01b0\u1edbc 1: <\/strong>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o ch\u1eef c\u00e1i \u1edf ph\u1ea7n \u0111\u1ea7u c\u1ed9t \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf.<\/p>\n

    \"Ch\u1ecdnB\u00f4i \u0111en c\u1ed9t B c\u1ea7n x\u00f3a<\/em><\/p>\n

    B\u01b0\u1edbc 2: Ch\u1ecdn Delete<\/strong> \u0111\u1ec3 x\u00f3a nhanh n\u1ed9i dung trong c\u1ed9t. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 v\u00e0o tab Home<\/strong>, t\u00ecm nh\u00f3m Editing<\/strong> \u2192 Clear<\/strong> \u2192 Clear All<\/strong> \u0111\u1ec3 l\u00e0m tr\u1ed1ng to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong c\u1ed9t.<\/p>\n

    \"T\u00f9yClear All \u0111\u1ec3 x\u00f3a to\u00e0n b\u1ed9 d\u1eef li\u1ec7u c\u1ed9t<\/em><\/p>\n

    Khi b\u1ea1n quen v\u1edbi c\u00e1c c\u00e1ch ch\u00e8n v\u00e0 x\u00f3a c\u1ed9t, vi\u1ec7c ch\u1ec9nh s\u1eeda b\u1ed1 c\u1ee5c b\u1ea3ng t\u00ednh s\u1ebd tr\u1edf n\u00ean nh\u1eb9 nh\u00e0ng h\u01a1n. B\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i d\u1eef li\u1ec7u theo \u00fd mu\u1ed1n m\u00e0 kh\u00f4ng m\u1ea5t nhi\u1ec1u th\u1eddi gian cho thao t\u00e1c. \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – 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

    B\u1ea1n c\u00f3 th\u1ec3 c\u00e2n nh\u1eafc n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb \u0111\u1ec3 vi\u1ec7c h\u1ecdc t\u1eadp v\u00e0 x\u1eed l\u00fd c\u00f4ng vi\u1ec7c thu\u1eadn ti\u1ec7n h\u01a1n. C\u00e1c m\u1eabu \u0111i\u1ec7n tho\u1ea1i v\u00e0 m\u00e1y t\u00ednh b\u1ea3ng \u0111ang c\u00f3 t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng ch\u1ecdn \u0111\u01b0\u1ee3c s\u1ea3n ph\u1ea9m ph\u00f9 h\u1ee3p nhu c\u1ea7u.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    \u00a0 Ch\u00e8n th\u00eam c\u1ed9t trong Excel gi\u00fap b\u1ea1n m\u1edf r\u1ed9ng b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 b\u1ed5 sung th\u00f4ng tin m\u1ed9t c\u00e1ch linh ho\u1ea1t. Excel h\u1ed7 tr\u1ee3 nhi\u1ec1u c\u00e1ch \u0111\u1ec3 th\u00eam c\u1ed9t, t\u1eeb thao t\u00e1c chu\u1ed9t \u0111\u1ebfn ph\u00edm t\u1eaft, ph\u00f9 h\u1ee3p cho c\u1ea3 ng\u01b0\u1eddi m\u1edbi l\u1eabn ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng xuy\u00ean. N\u1ed9i dung d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn […]<\/p>\n","protected":false},"author":1,"featured_media":5078,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5077","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\/19411.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5077","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=5077"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5077\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5078"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}