{"id":3192,"date":"2024-12-03T01:23:00","date_gmt":"2024-12-03T01:23:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-hoan-doi-vi-tri-cac-cot-trong-excel\/"},"modified":"2024-12-03T01:23:00","modified_gmt":"2024-12-03T01:23:00","slug":"cach-hoan-doi-vi-tri-cac-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-hoan-doi-vi-tri-cac-cot-trong-excel\/","title":{"rendered":"C\u00e1ch ho\u00e1n \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c c\u1ed9t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>Trong b\u00e0i vi\u1ebft n\u00e0y, Blog <a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c ph\u01b0\u01a1ng ph\u00e1p ho\u00e1n \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u \u2013 \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t trong excel: di chuy\u1ec3n c\u1ed9t b\u1eb1ng c\u00e1ch k\u00e9o th\u1ea3 chu\u1ed9t, di chuy\u1ec3n nhi\u1ec1u c\u1ed9t kh\u00f4ng li\u1ec1n k\u1ec1 c\u00f9ng m\u1ed9t l\u00fac.<\/em><\/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-674e5d738e7ad\" 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\/cach-hoan-doi-vi-tri-cac-cot-trong-excel.html#Cach_di_chuyen_mot_cot_trong_bang_tinh_Excel\" title=\"C\u00e1ch di chuy\u1ec3n m\u1ed9t c\u1ed9t trong b\u1ea3ng t\u00ednh Excel:\">C\u00e1ch di chuy\u1ec3n m\u1ed9t c\u1ed9t trong b\u1ea3ng t\u00ednh Excel:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-hoan-doi-vi-tri-cac-cot-trong-excel.html#Cut_Paste\" title=\"Cut &amp; Paste:\">Cut &amp; Paste:<\/a><\/li>\n<\/ul>\n<\/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\/cach-hoan-doi-vi-tri-cac-cot-trong-excel.html#Cach_di_chuyen_nhieu_cot_trong_Excel\" title=\"C\u00e1ch di chuy\u1ec3n nhi\u1ec1u c\u1ed9t trong Excel:\">C\u00e1ch di chuy\u1ec3n nhi\u1ec1u c\u1ed9t trong Excel:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-hoan-doi-vi-tri-cac-cot-trong-excel.html#Cach_keo_tha_cot_trong_Excel\" title=\"C\u00e1ch k\u00e9o th\u1ea3 c\u1ed9t trong Excel:\">C\u00e1ch k\u00e9o th\u1ea3 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-5\" href=\"https:\/\/blog.hocexcel.online\/cach-hoan-doi-vi-tri-cac-cot-trong-excel.html#Copy_%3E_Paste_%3E_Delete\" title=\"Copy =&gt; Paste =&gt; Delete\">Copy =&gt; Paste =&gt; Delete<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-hoan-doi-vi-tri-cac-cot-trong-excel.html#Dung_VBA_Macro\" title=\"D\u00f9ng\u00a0VBA Macro:\">D\u00f9ng\u00a0VBA Macro:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_di_chuyen_mot_cot_trong_bang_tinh_Excel\"><\/span><strong>C\u00e1ch di chuy\u1ec3n m\u1ed9t c\u1ed9t trong b\u1ea3ng t\u00ednh Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cut_Paste\"><\/span><strong>Cut &amp; Paste:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n thao t\u00e1c tr\u00ean con tr\u1ecf chu\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i th\u1ee9 t\u1ef1 c\u00e1c c\u1ed9t b\u1eb1ng c\u00e1ch c\u1eaft d\u00e1n ch\u00fang. H\u00e3y nh\u1edb r\u1eb1ng c\u00f3 m\u1ed9t v\u00e0i \u0111\u1eb7c \u0111i\u1ec3m ph\u1ee5 thu\u1ed9c v\u00e0o vi\u1ec7c b\u1ea1n mu\u1ed1n di chuy\u1ec3n m\u1ed9t c\u1ed9t hay nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t.<\/li>\n<li>C\u1eaft c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn b\u1eb1ng c\u00e1ch nh\u1ea5n <strong><em>Ctrl + X<\/em><\/strong>, ho\u1eb7c nh\u1ea5p ph\u1ea3i v\u00e0o c\u1ed9t v\u00e0 ch\u1ecdn <strong><em>Cut <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn. B\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua b\u01b0\u1edbc 1 v\u00e0 \u0111\u01a1n gi\u1ea3n nh\u1ea5p ph\u1ea3i v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ec3 ch\u1ecdn <strong><em>Cut<\/em><\/strong>.<\/li>\n<li>Ch\u1ecdn c\u1ed9t n\u1eb1m tr\u01b0\u1edbc n\u01a1i b\u1ea1n mu\u1ed1n ch\u00e8n c\u1ed9t \u0111\u01b0\u1ee3c c\u1eaft, nh\u1ea5p ph\u1ea3i v\u00e0o n\u00f3 v\u00e0 ch\u1ecdn <strong><em>Insert Cut Cells <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-cut-cells.png\" alt=\"Select the column before which you want to insert the cut column and choose Insert Cut Cells from the pop-up menu.\" title=\"insert-cut-cells\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng ph\u00edm t\u1eaft, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo nh\u1eefng c\u00e1ch sau:<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong c\u1ed9t v\u00e0 nh\u1ea5n <strong><em>Ctrl + Space <\/em><\/strong>\u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5n <strong><em>Ctrl + X <\/em><\/strong>\u0111\u1ec3 c\u1eaft c\u1ed9t<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn c\u1ed9t n\u1eb1m tr\u01b0\u1edbc n\u01a1i b\u1ea1n mu\u1ed1n d\u00e1n c\u1ed9t v\u1eeba c\u1eaft<\/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-104.gif\" title=\"vba101_92019-nho-104\"><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-243.gif\" title=\"ex101_92019-nho-243\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Nh\u1ea5n <strong><em>Ctrl + + <\/em><\/strong>tr\u00ean ph\u00edm s\u1ed1 \u0111\u1ec3 ch\u00e8n c\u1ed9t<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_di_chuyen_nhieu_cot_trong_Excel\"><\/span><strong>C\u00e1ch di chuy\u1ec3n nhi\u1ec1u c\u1ed9t trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Ph\u01b0\u01a1ng ph\u00e1p c\u1eaft\/d\u00e1n s\u1ebd hi\u1ec7u qu\u1ea3 \u0111\u1ed1i v\u1edbi m\u1ed9t c\u1ed9t, nh\u01b0ng kh\u00f4ng cho ph\u00e9p b\u1ea1n thao t\u00e1c v\u1edbi nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac. N\u1ebfu b\u1ea1n c\u1ed1 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, th\u00f4ng b\u00e1o l\u1ed7i s\u1ebd hi\u1ec7n ra y\u00eau c\u1ea7u b\u1ea1n ch\u1ecdn d\u00e3y d\u1eef li\u1ec7u \u0111\u01a1n l\u1ebb: <strong><em>The command you chose cannot be performed with multiple selections. <\/em><\/strong>(L\u1ec7nh b\u1ea1n y\u00eau c\u1ea7u kh\u00f4ng th\u1ec3 th\u1ef1c hi\u1ec7n v\u1edbi nhi\u1ec1u c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn.)<\/p>\n<p style=\"text-align: justify\"><strong>N\u1ebfu b\u1ea1n c\u1ea7n \u0111\u1eb7t l\u1ea1i th\u1ee9 t\u1ef1 m\u1ed9t v\u00e0i c\u1ed9t trong trang t\u00ednh, b\u1ea1n c\u00f3 c\u00e1c l\u1ef1a ch\u1ecdn sau \u0111\u00e2y:<\/strong><\/p>\n<ul style=\"list-style-type: circle;text-align: justify\">\n<li>S\u1eed d\u1ee5ng chu\u1ed9t \u0111\u1ec3 k\u00e9o th\u1ea3 nhi\u1ec1u c\u1ed9t (\u0111\u00e2y l\u00e0 c\u00e1ch nhanh nh\u1ea5t)<\/li>\n<li>C\u1eaft\/d\u00e1n t\u1eebng c\u1ed9t (kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng di chuy\u1ec3n nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac)<\/li>\n<li>Sao ch\u00e9p, d\u00e1n v\u00e0 x\u00f3a (cho ph\u00e9p di chuy\u1ec3n nhi\u1ec1u c\u1ed9t li\u1ec1n k\u1ec1 c\u00f9ng m\u1ed9t l\u00fac)<\/li>\n<li>D\u00f9ng VBA MACRO<\/li>\n<\/ul>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_keo_tha_cot_trong_Excel\"><\/span><strong>C\u00e1ch k\u00e9o th\u1ea3 c\u1ed9t trong Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t trang t\u00ednh v\u1edbi c\u00e1c th\u00f4ng tin v\u1ec1 s\u1ea3n ph\u1ea9m c\u00f4ng ty b\u1ea1n v\u00e0 b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c c\u1ed9t. T\u00f4i s\u1ebd s\u1eed d\u1ee5ng b\u1ea3ng gi\u00e1 AbleBits cho v\u00ed d\u1ee5 n\u00e0y. Nh\u1eefng g\u00ec t\u00f4i mu\u1ed1n l\u00e0 ho\u00e1n v\u1ecb c\u1ed9t \u201cLicense type\u201d v\u00e0 \u201cProduct ID\u201d \u0111\u1ec3 ID s\u1ea3n ph\u1ea9m xu\u1ea5t hi\u1ec7n ngay sau t\u00ean s\u1ea3n ph\u1ea9m.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/original-data1.png\" alt=\"A worksheet where you need to swap a couple of columns.\" title=\"original-data1\"><\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn c\u1ed9t b\u1ea1n mu\u1ed1n di chuy\u1ec3n.<\/li>\n<li>Di chuy\u1ec3n con tr\u1ecf chu\u1ed9t t\u1edbi c\u1ea1nh c\u1ee7a ph\u1ea7n \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u1ebfn khi n\u00f3 thay \u0111\u1ed5i t\u1eeb d\u1ea5u th\u1eadp b\u00ecnh th\u01b0\u1eddng th\u00e0nh d\u1ea5u m\u0169i t\u00ean 4 chi\u1ec1u. B\u1ea1n kh\u00f4ng n\u00ean th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y \u1edf ph\u1ea7n ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00ec nhi\u1ec1u h\u00ecnh d\u1ea1ng kh\u00e1c nhau c\u1ee7a con tr\u1ecf chu\u1ed9t s\u1ebd khi\u1ebfn b\u1ea1n b\u1ecb r\u1ed1i. T\u1ed1t h\u01a1n l\u00e0 b\u1ea1n n\u00ean th\u1ef1c hi\u1ec7n \u1edf c\u1ea1nh tr\u00e1i ho\u1eb7c c\u1ea1nh ph\u1ea3i c\u1ee7a c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mouse-pointer-drag-column.png\" alt=\"Move the mouse pointer to the edge of the selection until it changes from a regular cross to a 4-sided arrow cursor.\" title=\"mouse-pointer-drag-column\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Nh\u1ea5n gi\u1eef ph\u00edm <strong><em>Shift <\/em><\/strong>sau \u0111\u00f3 k\u00e9o c\u1ed9t sang v\u1ecb tr\u00ed m\u1edbi. B\u1ea1n s\u1ebd th\u1ea5y m\u1ed9t thanh \u201ci\u201d m\u1edd d\u1ecdc theo chi\u1ec1u d\u00e0i c\u1ee7a c\u1ed9t v\u00e0 m\u1ed9t h\u1ed9p hi\u1ec3n th\u1ecb v\u1ecb tr\u00ed m\u1edbi c\u1ee7a c\u1ed9t.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-drag-column.png\" alt=\"Press and hold down the Shift key and drag the column to a new location.\" title=\"excel-drag-column\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u01b0 v\u1eady l\u00e0 xong. Th\u1ea3 n\u00fat chu\u1ed9t, sau \u0111\u00f3 th\u1ea3 ph\u00edm <strong><em>Shift <\/em><\/strong>v\u00e0 t\u00ecm c\u1ed9t v\u1eeba \u0111\u01b0\u1ee3c di chuy\u1ec3n qua v\u1ecb tr\u00ed m\u1edbi.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 k\u00e9o th\u1ea3 nhi\u1ec1u c\u1ed9t trong b\u1ea3ng t\u00ednh Excel. \u0110\u1ec3 ch\u1ecdn nhi\u1ec1u c\u1ed9t, nh\u1ea5p v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n di chuy\u1ec3n, nh\u1ea5n gi\u1eef ph\u00edm <strong><em>Shift <\/em><\/strong>v\u00e0 nh\u1ea5n ti\u00eau \u0111\u1ec1 c\u1ed9t cu\u1ed1i c\u00f9ng. Sau \u0111\u00f3 l\u00e0m theo b\u01b0\u1edbc 2 \u0111\u1ebfn b\u01b0\u1edbc 4 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf tr\u00ean \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drag-several-columns.png\" alt=\"Drag several columns in Excel using the mouse.\" title=\"drag-several-columns\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd<\/strong>. B\u1ea1n kh\u00f4ng th\u1ec3 k\u00e9o th\u1ea3 c\u00e1c c\u1ed9t ho\u1eb7c c\u00e1c h\u00e0ng kh\u00f4ng li\u1ec1n k\u1ec1 trong trang t\u00ednh Excel, th\u1eadm ch\u00ed trong Excel 2013.<\/p>\n<p style=\"text-align: justify\">Ph\u01b0\u01a1ng ph\u00e1p k\u00e9o th\u1ea3 ch\u1ec9 c\u00f3 t\u00e1c d\u1ee5ng trong Excel 2013, 2010, 2007 v\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho di chuy\u1ec3n c\u00e1c h\u00e0ng.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Copy_%3E_Paste_%3E_Delete\"><\/span>Copy =&gt; Paste =&gt; Delete<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu k\u00e9o th\u1ea3 c\u00e1c c\u1ed9t b\u1eb1ng chu\u1ed9t kh\u00f4ng hi\u1ec7u qu\u1ea3 \u0111\u1ed1i v\u1edbi b\u1ea1n, h\u00e3y th\u1eed s\u1eafp x\u1ebfp nhi\u1ec1u c\u1ed9t trong b\u1ea3ng t\u00ednh Excel theo c\u00e1ch sau:<\/p>\n<ol style=\"text-align: justify\">\n<li><strong>Ch\u1ecdn c\u00e1c c\u1ed9t b\u1ea1n mu\u1ed1n di chuy\u1ec3n<\/strong> (nh\u1ea5n v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ea7u ti\u00ean, nh\u1ea5n <strong><em>Shift <\/em><\/strong>sau \u0111\u00f3 nh\u1ea5p v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t cu\u1ed1i c\u00f9ng)<\/li>\n<\/ol>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c l\u00e0 ch\u1ec9 ch\u1ecdn ti\u00eau \u0111\u1ec1 c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c di chuy\u1ec3n, sau \u0111\u00f3 nh\u1ea5n <strong><em>Ctrl + Space. <\/em><\/strong>C\u00e1ch n\u00e0y ch\u1ec9 ch\u1ecdn nh\u1eefng \u00f4 t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u h\u01a1n l\u00e0 ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t, nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<figure style=\"width: 637px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-cells-with-data.png\" alt=\"Selecting only cells with data rather than entire columns\" width=\"637\" height=\"319\" title=\"select-cells-with-data\"><figcaption class=\"wp-caption-text\">c\u00e1ch \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t trong excel<\/figcaption><\/figure>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd. <\/strong>N\u1ebfu b\u1ea1n s\u1eafp x\u1ebfp l\u1ea1i c\u00e1c c\u1ed9t trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1ch n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c. N\u1ebfu b\u1ea1n mu\u1ed1n ho\u00e1n \u0111\u1ed5i v\u1ecb tr\u00ed m\u1ed9t v\u00e0i c\u1ed9t trong to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh Excel, h\u00e3y ch\u1ecdn c\u1ed9t b\u1eb1ng c\u00e1ch th\u1ee9 2 (ch\u1ec9 nh\u1eefng \u00f4 t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u). N\u1ebfu thao t\u00e1c theo c\u00e1ch 1, b\u1ea1n c\u00f3 th\u1ec3 m\u1eafc l\u1ed7i <strong><em>\u201cThe operation is not allowed. The operation is attempting to shift cells in a table of your worksheet\u201d <\/em><\/strong>(Thao t\u00e1c kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p. Ho\u1ea1t \u0111\u1ed9ng n\u00e0y \u0111ang c\u1ed1 g\u1eafng thay \u0111\u1ed5i c\u00e1c \u00f4 trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n.)<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li><strong>Sao ch\u00e9p c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn<\/strong> b\u1eb1ng c\u00e1ch nh\u1ea5n <strong><em>Ctrl + C<\/em><\/strong>, nh\u1ea5p ph\u1ea3i v\u00e0o c\u00e1c c\u1ed9t v\u00e0 ch\u1ecdn <strong><em>Copy<\/em><\/strong>.<\/li>\n<li><strong>Ch\u1ecdn c\u1ed9t n\u1eb1m tr\u01b0\u1edbc v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n ch\u00e8n c\u1ed9t v\u1eeba sao ch\u00e9p<\/strong>, nh\u1ea5p ph\u1ea3i v\u00e0o n\u00f3 v\u00e0 ch\u1ecdn <strong><em>Insert Copied Cells<\/em><\/strong> ho\u1eb7c nh\u1ea5n <strong><em>Ctrl + +<\/em><\/strong> tr\u00ean ph\u00edm s\u1ed1.<\/li>\n<\/ol>\n<figure style=\"width: 582px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-copied-columns.png\" alt=\"Select the column before which you want to insert the copied columns and choose Insert copies cells.\" width=\"582\" height=\"340\" title=\"insert-copied-columns\"><figcaption class=\"wp-caption-text\">\u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t trong excel<\/figcaption><\/figure>\n<ol style=\"text-align: justify\" start=\"4\">\n<li><strong>X\u00f3a c\u00e1c c\u1ed9t g\u1ed1c.<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">\u0110\u01b0\u01a1ng nhi\u00ean, qu\u00e1 tr\u00ecnh n\u00e0y d\u00e0i h\u01a1n vi\u1ec7c k\u00e9o th\u1ea3 c\u00e1c c\u1ed9t, nh\u01b0ng n\u00f3 h\u1eefu \u00edch cho nh\u1eefng ai th\u00edch d\u00f9ng ph\u00edm t\u1eaft h\u01a1n thao t\u00e1c v\u1edbi chu\u1ed9t. \u0110\u00e1ng ti\u1ebfc l\u00e0, n\u00f3 c\u0169ng kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng cho c\u00e1c c\u1ed9t kh\u00f4ng li\u1ec1n k\u1ec1.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dung_VBA_Macro\"><\/span><strong>D\u00f9ng\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/bat-dau-voi-excel-macros-va-lap-trinh-vba.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA Macro<\/a>:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t s\u1ed1 ki\u1ebfn \u200b\u200bth\u1ee9c v\u1ec1 VBA, b\u1ea1n c\u00f3 th\u1ec3 th\u1eed vi\u1ebft <strong><em>Macro<\/em><\/strong> \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng di chuy\u1ec3n c\u00e1c c\u1ed9t trong b\u1ea3ng Excel. \u0110\u00e2y l\u00e0 l\u00fd thuy\u1ebft. Trong th\u1ef1c t\u1ebf, vi\u1ec7c x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c c\u1ed9t c\u1ea7n ho\u00e1n \u0111\u1ed5i v\u00e0 v\u1ecb tr\u00ed m\u1edbi c\u1ee7a ch\u00fang s\u1ebd t\u1ed1n nhi\u1ec1u th\u1eddi gian h\u01a1n k\u00e9o th\u1ea3 ch\u00fang m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng. B\u00ean c\u1ea1nh \u0111\u00f3, kh\u00f4ng c\u00f3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng <strong><em>Macro<\/em><\/strong> s\u1ebd lu\u00f4n ho\u1ea1t \u0111\u1ed9ng theo k\u1ebft qu\u1ea3 b\u1ea1n mong mu\u1ed1n v\u00e0 v\u1edbi m\u1ed7i l\u1ea7n th\u1ef1c hi\u1ec7n, b\u1ea1n \u0111\u1ec1u ph\u1ea3i x\u00e1c minh l\u1ea1i k\u1ebft qu\u1ea3. Nh\u00ecn chung, <strong><em>Macro VBA<\/em><\/strong> d\u01b0\u1eddng nh\u01b0 kh\u00f4ng ph\u1ea3i m\u1ed9t c\u00f4ng c\u1ee5 ph\u00f9 h\u1ee3p cho nhi\u1ec7m v\u1ee5 n\u00e0y.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u00e2\u0323y v\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, mi\u0300nh \u0111a\u0303 gi\u01a1\u0301i thi\u00ea\u0323u \u0111\u00ea\u0301n ca\u0301c ba\u0323n c\u00e1ch ho\u00e1n \u0111\u1ed5i v\u1ecb tr\u00ed c\u00e1c c\u1ed9t trong Excel \u2013 \u0111\u1ed5i v\u1ecb tr\u00ed c\u1ed9t trong excel m\u00f4\u0323t ca\u0301ch \u0111\u01a1n gia\u0309n nh\u00e2\u0301t. \u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/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<\/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\/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-104.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3193,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3192","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\/3192","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=3192"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3192\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3193"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}