{"id":6413,"date":"2024-12-21T15:16:08","date_gmt":"2024-12-21T15:16:08","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-bo-chon-o-tu-mot-nhom-o-da-chon\/"},"modified":"2024-12-21T15:16:08","modified_gmt":"2024-12-21T15:16:08","slug":"cach-bo-chon-o-tu-mot-nhom-o-da-chon","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-bo-chon-o-tu-mot-nhom-o-da-chon\/","title":{"rendered":"C\u00e1ch b\u1ecf ch\u1ecdn \u00f4 t\u1eeb m\u1ed9t nh\u00f3m \u00f4 \u0111\u00e3 ch\u1ecdn"},"content":{"rendered":"
\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u1ea7n b\u1ecf ch\u1ecdn m\u1ed9t s\u1ed1 \u00f4 ho\u1eb7c d\u1ea3i t\u1eeb c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn, b\u1ea1n c\u00f3 th\u1ec3 ph\u1ea3i b\u1ecf ch\u1ecdn to\u00e0n b\u1ed9, v\u00e0 ch\u1ecdn l\u1ea1i m\u1ed9t l\u1ea7n n\u1eefa, b\u1edfi v\u00ec Excel kh\u00f4ng \u0111\u01b0a ra c\u00e1ch \u0111\u1ec3 b\u1ecf ch\u1ecdn m\u1ed9t s\u1ed1 \u00f4 trong nh\u00f3m \u00f4 \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 m\u1eb9o \u0111\u1ec3 b\u1ecf ch\u1ecdn m\u1ed9t s\u1ed1 \u00f4 ho\u1eb7c d\u00e3y t\u1eeb l\u1ef1a ch\u1ecdn hi\u1ec7n t\u1ea1i.<\/p>\n

B\u1ecf ch\u1ecdn m\u1ed9t s\u1ed1 \u00f4 ho\u1eb7c d\u00e3y t\u1eeb c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn b\u1eb1ng m\u00e3 VBA<\/a><\/strong><\/h1>\n

VBA<\/a> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c trong Excel.<\/p>\n

B\u01b0\u1edbc 1: Ch\u1ecdn v\u00f9ng l\u00e0m vi\u1ec7c.<\/p>\n

B\u01b0\u1edbc 2: Ch\u1ecdn 1 \u00f4 b\u1ea1n mu\u1ed1n b\u1ecf ch\u1ecdn trong v\u00f9ng \u0111\u00e3 ch\u1ecdn m\u00e0 v\u1eabn nh\u1ea5n gi\u1eef Ctrl.<\/p>\n

B\u01b0\u1edbc 3: Nh\u1ea5n ALT+F11, <\/strong>m\u1edf c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications<\/strong>.<\/p>\n

B\u01b0\u1edbc 4: Nh\u1ea5n Insert<\/strong> > Module<\/strong>, v\u00e0 d\u00e1n \u0111o\u1ea1n macro sau v\u00e0o c\u1eeda s\u1ed5 Module.<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
\n
<\/div>\n
B\u01b0\u1edbc 5: Nh\u1ea5n F5 <\/strong>\u0111\u1ec3 ch\u1ea1y m\u00e3. M\u1ed9t h\u1ed9p tho\u1ea1i s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u1ec3 b\u1ea1n ch\u1ecdn v\u00f9ng l\u00e0m vi\u1ec7c<\/div>\n
<\/div>\n
B\u01b0\u1edbc 6: Nh\u1ea5n OK. M\u1ed9t h\u1ed9p tho\u1ea1i kh\u00e1c s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u1ec3 b\u1ea1n ch\u1ecdn c\u00e1c \u00f4 mu\u1ed1n b\u1ecf ch\u1ecdn. N\u1ebfu b\u1ea1n mu\u1ed1n b\u1ecf ch\u1ecdn nhi\u1ec1u h\u01a1n m\u1ed9t \u00f4, h\u00e3y nh\u1edb gi\u1eef ph\u00edm Ctrl.<\/div>\n
<\/div>\n
B\u01b0\u1edbc 7: Nh\u1ea5n OK. V\u00e0 \u0111\u00e2y l\u00e0 k\u1ebft qu\u1ea3:<\/div>\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":6414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6413","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\/6413","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=6413"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6414"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}