{"id":6377,"date":"2024-12-21T15:13:16","date_gmt":"2024-12-21T15:13:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-nhanh-cot-trong-giua-cac-cot-trong-excel\/"},"modified":"2024-12-21T15:13:16","modified_gmt":"2024-12-21T15:13:16","slug":"cach-chen-nhanh-cot-trong-giua-cac-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-nhanh-cot-trong-giua-cac-cot-trong-excel\/","title":{"rendered":"C\u00e1ch ch\u00e8n nhanh c\u1ed9t tr\u1ed1ng gi\u1eefa c\u00e1c c\u1ed9t trong Excel"},"content":{"rendered":"
\n

Ch\u00e8n c\u1ed9t tr\u1ed1ng v\u1edbi m\u00e3 VBA<\/strong><\/h1>\n

H\u00e3y nh\u00ecn v\u00e0o h\u00ecnh d\u01b0\u1edbi, sau m\u1ed7i c\u1ed9t, t\u00f4i mu\u1ed1n ch\u00e8n m\u1ed9t c\u1ed9t tr\u1ed1ng, t\u00f4i c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t \u0111o\u1ea1n m\u00e3 VBA<\/a> \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y.<\/p>\n

<\/p>\n

1. Ch\u1ecdn d\u00e3y m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n c\u1ed9t tr\u1ed1ng.<\/p>\n

2. Ch\u1ecdn\u00a0Developer<\/strong> > Visual Basic<\/strong>, m\u1ed9t c\u1eeda s\u1ed5\u00a0Microsoft Visual Basic for applications\u00a0<\/strong>s\u1ebd hi\u1ec7n ra, nh\u1ea5p\u00a0Insert<\/strong> > Module,\u00a0<\/strong>v\u00e0 nh\u1eadp \u0111o\u1ea1n m\u00e3 sau:<\/p>\n

Sub insert_column_every_other()<\/em><\/strong>
\n\u00a0 For colx = 2 To 30 Step 2<\/em><\/strong>
\n\u00a0 \u00a0 Columns(colx).Insert Shift:=xlToRight<\/em><\/strong>
\n\u00a0 Next<\/em><\/strong>
\n End Sub<\/em><\/strong><\/p>\n

3. Nh\u1ea5p\u00a0\"doc-multiply-calculation-3\"\u00a0\u0111\u1ec3 ch\u1ea1y \u0111o\u1ea1n m\u00e3. V\u00e0 c\u00e1c c\u1ed9t tr\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n.<\/p>\n

L\u01b0u \u00fd: \u0110o\u1ea1n m\u00e3 VBA n\u00e0y ch\u1ec9 c\u00f3 th\u1ec3 ch\u00e8n 1 c\u1ed9t tr\u1ed1ng sau m\u1ed7i c\u1ed9t.<\/p>\n

N\u1ebfu b\u1ea1n mu\u1ed1n ch\u00e8n 1 c\u1ed9t tr\u1ed1ng v\u1edbi m\u1ed7i hai c\u1ed9t, \u0111o\u1ea1n m\u00e3 tr\u00ean s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n<\/div>\n
\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6378,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6377","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\/6377","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=6377"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6377\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6378"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}