{"id":705,"date":"2024-12-02T02:43:10","date_gmt":"2024-12-02T02:43:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la\/"},"modified":"2024-12-02T02:43:10","modified_gmt":"2024-12-02T02:43:10","slug":"cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la\/","title":{"rendered":"C\u00e1c th\u1ee7 thu\u1eadt th\u00eam b\u1edbt nhanh c\u1ed9t trong Excel, hay v\u00e0 l\u1ea1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"th\u00eam-c\u1ed9t-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la.html?them-cot-trong-excel\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"http:\/\/hocexcel.online\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n <strong>c\u00e1ch th\u00eam c\u1ed9t m\u1edbi v\u00e0o Excel 2010<\/strong> \u2013 2013, 2016. \u0110\u1ecdc \u0111\u1ec3 t\u00ecm hi\u1ec3u c\u00e1c ph\u00edm t\u1eaft \u0111\u1ec3 ch\u00e8n m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t, k\u1ec3 c\u1ea3 c\u00e1c c\u1ed9t kh\u00f4ng li\u1ec1n k\u1ec1.<\/p>\n<\/blockquote>\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-674d1ebe08825\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la.html#Cach_nhanh_nhat_de_them_mot_cot_trong_Excel\" title=\"C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 th\u00eam m\u1ed9t c\u1ed9t trong Excel\">C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 th\u00eam m\u1ed9t c\u1ed9t trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la.html#Chen_nhieu_cot_moi_trong_Excel\" title=\"Ch\u00e8n nhi\u1ec1u c\u1ed9t m\u1edbi trong Excel\">Ch\u00e8n nhi\u1ec1u c\u1ed9t m\u1edbi trong Excel<\/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\/cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la.html#Chen_nhieu_cot_moi_khong_lien_tiep_trong_Excel\" title=\"Ch\u00e8n nhi\u1ec1u c\u1ed9t m\u1edbi kh\u00f4ng li\u00ean ti\u1ebfp trong Excel\">Ch\u00e8n nhi\u1ec1u c\u1ed9t m\u1edbi kh\u00f4ng li\u00ean ti\u1ebfp trong Excel<\/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\/cac-thu-thuat-them-bot-nhanh-cot-trong-excel-hay-va-la.html#Them_mot_cot_moi_vao_Excel_Table\" title=\"Th\u00eam m\u1ed9t c\u1ed9t m\u1edbi v\u00e0o Excel Table\">Th\u00eam m\u1ed9t c\u1ed9t m\u1edbi v\u00e0o Excel Table<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_nhanh_nhat_de_them_mot_cot_trong_Excel\"><\/span><strong>C\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 th\u00eam m\u1ed9t c\u1ed9t trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">1. Nh\u1ea5p v\u00e0o n\u00fat ch\u1eef c\u00e1i c\u1ee7a c\u1ed9t b\u00ean ph\u1ea3i n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n c\u1ed9t m\u1edbi.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-column-letter-button.png\" alt=\"Click on the letter button to select the entire column\" title=\"excel-column-letter-button\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:\u00a0<\/strong>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o \u00f4 t\u00ednh b\u1ea5t k\u1ef3 sau \u0111\u00f3 nh\u1ea5n <strong>Ctrl + Space<\/strong>.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5n <strong>Ctrl + Shift + + <\/strong>(d\u1ea5u c\u1ed9ng tr\u00ean m\u00e0n h\u00ecnh)<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:\u00a0<\/strong>N\u1ebfu b\u1ea1n kh\u00f4ng nh\u1edb ph\u00edm t\u1eaft, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5p ph\u1ea3i chu\u1ed9t v\u00e0o c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 b\u1ea5m <strong><em>Insert <\/em><\/strong>t\u1eeb danh s\u00e1ch l\u1ef1a ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\">\u0110\u00f3 l\u00e0 hai b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 ch\u00e8n th\u00eam c\u1ed9t m\u1edbi. H\u00e3y ti\u1ebfp t\u1ee5c \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 xem l\u00e0m th\u1ebf n\u00e0o ch\u00fang ta c\u00f3 th\u1ec3 ch\u00e8n nhi\u1ec1u c\u1ed9t tr\u1ed1ng v\u00e0o danh s\u00e1ch c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-insert-option.png\" alt=\"Right-click on the selected column and pick the Insert option\" title=\"excel-insert-option\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-13.gif\" title=\"vba101_92019-nho-13\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-38.gif\" title=\"ex101_92019-nho-38\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_nhieu_cot_moi_trong_Excel\"><\/span><strong>Ch\u00e8n nhi\u1ec1u c\u1ed9t m\u1edbi trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">1. T\u00f4 ch\u1ecdn s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t b\u1ea1n mu\u1ed1n th\u00eam v\u00e0o trang t\u00ednh. Nh\u1eefng c\u1ed9t m\u1edbi s\u1ebd xu\u1ea5t hi\u1ec7n ngay b\u00ean tr\u00e1i s\u1ed1 c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-select-columns-buttons.png\" alt=\"Highlight several columns by selecting the column buttons\" title=\"excel-select-columns-buttons\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:\u00a0<\/strong>B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m t\u01b0\u01a1ng t\u1ef1 n\u1ebfu b\u1ea1n ch\u1ecdn nhi\u1ec1u \u00f4 t\u00ednh li\u00ean ti\u1ebfp trong m\u1ed9t c\u1ed9t ho\u1eb7c nh\u1ea5n <strong>Ctrl + Space<\/strong>.<\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5n <strong>Ctrl + Shift +<\/strong>\u00a0<strong>+<\/strong><strong>\u00a0<\/strong>\u0111\u1ec3 ch\u00e8n th\u00eam nhi\u1ec1u c\u1ed9t m\u1edbi.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd:\u00a0<\/strong>Nh\u1ea5n<strong> F4 <\/strong>\u0111\u1ec3 l\u1eb7p l\u1ea1i thao t\u00e1c ho\u1eb7c <strong>Ctrl + Y <\/strong>\u0111\u1ec3 ch\u00e8n th\u00eam nhi\u1ec1u c\u1ed9t m\u1edbi.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Chen_nhieu_cot_moi_khong_lien_tiep_trong_Excel\"><\/span><strong>Ch\u00e8n nhi\u1ec1u c\u1ed9t m\u1edbi kh\u00f4ng li\u00ean ti\u1ebfp trong Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">1. Ch\u1ecdn nhi\u1ec1u c\u1ed9t m\u1edbi kh\u00f4ng li\u00ean ti\u1ebfp b\u1eb1ng c\u00e1ch nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat ch\u1eef c\u00e1i \u1edf m\u1ed7i c\u1ed9t v\u00e0 nh\u1ea5n gi\u1eef ph\u00edm <strong>Ctrl<\/strong>. Nh\u1eefng c\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c ch\u00e8n th\u00eam s\u1ebd xu\u1ea5t hi\u1ec7n ph\u00eda b\u00ean tr\u00e1i ch\u00fang.<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-select-nonadjacent-columns.png\" alt=\"Select nonadjacent columns by clicking on their letters and keeping Ctrl pressed\" title=\"excel-select-nonadjacent-columns\"><\/p>\n<p style=\"text-align: justify\">2. Nh\u1ea5n <strong>Ctrl + Shift + + <\/strong>\u0111\u1ec3 ti\u1ebfn h\u00e0nh thao t\u00e1c ch\u00e8n m\u1edbi.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Them_mot_cot_moi_vao_Excel_Table\"><\/span><strong>Th\u00eam m\u1ed9t c\u1ed9t m\u1edbi v\u00e0o Excel Table<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu trang t\u00ednh \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng d\u1ea1ng b\u1ea3ng, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn <strong><em>Insert Table Columns to the Right <\/em><\/strong>n\u1ebfu \u0111\u00f3 l\u00e0 c\u1ed9t cu\u1ed1i c\u00f9ng. B\u1ea1n cheap medications <a href=\"http:\/\/www.slaterpharmacy.com\/prednisolone\/\">http:\/\/www.slaterpharmacy.com<\/a> c\u0169ng c\u00f3 th\u1ec3 ch\u1ecdn <strong><em>Insert Table Columns to the Left<\/em><\/strong> \u0111\u1ec3 th\u00eam c\u1ed9t v\u00e0o b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o kh\u00e1c trong b\u1ea3ng c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">1. \u0110\u1ec3 ch\u00e8n m\u1ed9t c\u1ed9t, b\u1ea1n c\u1ea7n ch\u1ecdn c\u1ed9t \u1edf v\u1ecb tr\u00ed c\u1ea7n ch\u00e8n v\u00e0 nh\u1ea5p ph\u1ea3i v\u00e0o n\u00f3.<\/p>\n<p style=\"text-align: justify\">2. Ch\u1ecdn <strong><em>Insert <\/em><\/strong><em>&gt; <strong>Table Columns to the Right <\/strong><\/em>\u0111\u1ed1i v\u1edbi c\u1ed9t cu\u1ed1i c\u00f9ng trong b\u1ea3ng ho\u1eb7c<strong><em> Table Columns to the Left<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-insert-column-table.png\" alt=\"Click Insert and pick Table Columns to the Right or Table Columns to the Left\" title=\"excel-insert-column-table\"><\/p>\n<p style=\"text-align: justify\">C\u1ed9t m\u1edbi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean \u201cColumn1\u201d theo m\u1eb7c \u0111\u1ecbnh.<\/p>\n<p>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\" rel=\"noopener\">HocExcel.Online<\/a><\/p>\n<p style=\"text-align: justify\">\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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-13.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":706,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-705","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/705","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=705"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/705\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/706"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}