{"id":1373,"date":"2025-11-30T03:12:34","date_gmt":"2025-11-30T03:12:34","guid":{"rendered":"https:\/\/growhome.vn\/?p=1373"},"modified":"2025-11-30T03:12:36","modified_gmt":"2025-11-30T03:12:36","slug":"chinh-toan-chu-dong-dau-tien-trong-bang-ve-in-dam","status":"publish","type":"post","link":"https:\/\/growhome.vn\/?p=1373","title":{"rendered":"Ch\u1ec9nh to\u00e0n ch\u1eef d\u00f2ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng v\u1ec1 in \u0111\u1eadm"},"content":{"rendered":"<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_button\">\n\t\t\t\t\t<a href=\"https:\/\/www.facebook.com\/\" target=\"_blank\">\n\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/growhome.vn\/wp-content\/plugins\/facebook-button-plugin\/images\/standard-facebook-ico.png\" alt=\"Fb-Button\" \/>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/growhome.vn\/?p=1373\" action=\"like\" colorscheme=\"light\" layout=\"standard\"  width=\"225px\" size=\"small\"><\/fb:like><\/div><\/div>\n<p class=\"wp-block-paragraph\">H\u1ecfi: Trong file c\u1ee7a t\u00f4i c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea3ng, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung trong d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00e1c b\u1ea3ng l\u00e0 ch\u1eef in \u0111\u1eadm<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">tr\u1ea3 l\u1eddi:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Model<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ch\u00e0o b\u1ea1n,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u1ec3 chuy\u1ec3n n\u1ed9i dung trong d\u00f2ng \u0111\u1ea7u ti\u00ean (th\u01b0\u1eddng l\u00e0 d\u00f2ng ti\u00eau \u0111\u1ec1\/Header Row) c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng trong t\u00e0i li\u1ec7u Word th\u00e0nh ch\u1eef in \u0111\u1eadm m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p th\u1ee7 c\u00f4ng b\u1eb1ng c\u00e1ch ch\u1ecdn nhi\u1ec1u b\u1ea3ng ho\u1eb7c s\u1eed d\u1ee5ng Macro (VBA) \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a ho\u00e0n to\u00e0n.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">C\u00e1ch 1: Ch\u1ecdn h\u00e0ng lo\u1ea1t c\u00e1c b\u1ea3ng v\u00e0 \u0111\u1ecbnh d\u1ea1ng l\u1ea1i (Th\u1ee7 c\u00f4ng nhanh)<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u00e2y l\u00e0 c\u00e1ch nhanh nh\u1ea5t n\u1ebfu s\u1ed1 l\u01b0\u1ee3ng b\u1ea3ng kh\u00f4ng qu\u00e1 nhi\u1ec1u:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Ch\u1ecdn d\u00f2ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng th\u1ee9 nh\u1ea5t:<\/strong>\u00a0Di chuy\u1ec3n chu\u1ed9t \u0111\u1ebfn s\u00e1t b\u00ean tr\u00e1i c\u1ee7a d\u00f2ng \u0111\u1ea7u ti\u00ean (d\u00f2ng ti\u00eau \u0111\u1ec1) trong b\u1ea3ng th\u1ee9 nh\u1ea5t cho \u0111\u1ebfn khi con tr\u1ecf chu\u1ed9t bi\u1ebfn th\u00e0nh m\u1ed9t\u00a0<strong>m\u0169i t\u00ean m\u00e0u tr\u1eafng ch\u1ec9 sang ph\u1ea3i<\/strong>. Nh\u1ea5p chu\u1ed9t \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 d\u00f2ng \u0111\u00f3.<\/li>\n\n\n\n<li><strong>Ch\u1ecdn d\u00f2ng ti\u00eau \u0111\u1ec1 c\u1ee7a c\u00e1c b\u1ea3ng ti\u1ebfp theo:<\/strong>\u00a0<strong>Gi\u1eef ph\u00edm Ctrl<\/strong>\u00a0v\u00e0 ti\u1ebfp t\u1ee5c nh\u1ea5p chu\u1ed9t v\u00e0o b\u00ean tr\u00e1i d\u00f2ng \u0111\u1ea7u ti\u00ean (d\u00f2ng ti\u00eau \u0111\u1ec1) c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng kh\u00e1c m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng.<\/li>\n\n\n\n<li><strong>\u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng In \u0111\u1eadm:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Th\u1ea3 ph\u00edm Ctrl.<\/li>\n\n\n\n<li>Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<strong>Ctrl + B<\/strong>\u00a0ho\u1eb7c chuy\u1ec3n \u0111\u1ebfn tab\u00a0<strong>Home<\/strong>\u00a0(Trang ch\u1ee7) v\u00e0 nh\u1ea5p v\u00e0o n\u00fat\u00a0<strong>B (Bold &#8211; In \u0111\u1eadm)<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">T\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng ti\u00eau \u0111\u1ec1 b\u1ea1n \u0111\u00e3 ch\u1ecdn c\u00f9ng l\u00fac s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh ch\u1eef in \u0111\u1eadm.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">C\u00e1ch 2: S\u1eed d\u1ee5ng Macro (VBA) \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a cho T\u1ea4T C\u1ea2 c\u00e1c b\u1ea3ng<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p hi\u1ec7u qu\u1ea3 nh\u1ea5t n\u1ebfu b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea3ng. Macro n\u00e0y s\u1ebd ch\u1ea1y qua t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng v\u00e0 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng in \u0111\u1eadm cho d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed7i b\u1ea3ng.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">B\u01b0\u1edbc 1: M\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm:\u00a0<strong>Alt + F11<\/strong>\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">B\u01b0\u1edbc 2: Ch\u00e8n m\u1ed9t Module m\u1edbi<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Trong c\u1eeda s\u1ed5 VBA, v\u00e0o menu\u00a0<strong>Insert<\/strong>\u00a0(Ch\u00e8n).<\/li>\n\n\n\n<li>Ch\u1ecdn\u00a0<strong>Module<\/strong>. M\u1ed9t c\u1eeda s\u1ed5 so\u1ea1n th\u1ea3o tr\u1ed1ng s\u1ebd hi\u1ec7n ra.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\">B\u01b0\u1edbc 3: D\u00e1n \u0111o\u1ea1n m\u00e3 Macro<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Sao ch\u00e9p (Copy) \u0111o\u1ea1n m\u00e3 sau v\u00e0 d\u00e1n (Paste) v\u00e0o c\u1eeda s\u1ed5 Module v\u1eeba m\u1edf:<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">link t\u1ea3i code: <a href=\"https:\/\/drive.google.com\/file\/d\/1Qztc44MByAVNbxrtSmMWiS_3Ri3Fwjjv\/view?usp=sharing\" data-type=\"link\" data-id=\"https:\/\/drive.google.com\/file\/d\/1Qztc44MByAVNbxrtSmMWiS_3Ri3Fwjjv\/view?usp=sharing\">https:\/\/drive.google.com\/file\/d\/1Qztc44MByAVNbxrtSmMWiS_3Ri3Fwjjv\/view?usp=sharing<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">B\u01b0\u1edbc 4: Ch\u1ea1y Macro<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Quay tr\u1edf l\u1ea1i c\u1eeda s\u1ed5 Word c\u1ee7a b\u1ea1n.<\/li>\n\n\n\n<li>Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm:\u00a0<strong>Alt + F8<\/strong>\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Macro.<\/li>\n\n\n\n<li>Trong danh s\u00e1ch Macro, t\u00ecm v\u00e0 ch\u1ecdn Macro t\u00ean l\u00e0\u00a0<strong>InDamDongDauTienCuaTatCaCacBang<\/strong>.<\/li>\n\n\n\n<li>Nh\u1ea5n n\u00fat\u00a0<strong>Run (Ch\u1ea1y)<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Sau khi ch\u1ea1y xong, to\u00e0n b\u1ed9 d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng trong t\u00e0i li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh ch\u1eef in \u0111\u1eadm.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u1ecfi: Trong file c\u1ee7a t\u00f4i c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea3ng, l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung trong d\u00f2ng \u0111\u1ea7u ti\u00ean c\u1ee7a c\u00e1c b\u1ea3ng l\u00e0 ch\u1eef in \u0111\u1eadm tr\u1ea3 l\u1eddi: Model Ch\u00e0o b\u1ea1n, \u0110\u1ec3 chuy\u1ec3n n\u1ed9i dung trong d\u00f2ng \u0111\u1ea7u ti\u00ean (th\u01b0\u1eddng l\u00e0 d\u00f2ng ti\u00eau \u0111\u1ec1\/Header Row) c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng trong t\u00e0i&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-1373","post","type-post","status-publish","format-standard","hentry","category-meo-xu-ly-van-ban-word"],"_links":{"self":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1373"}],"version-history":[{"count":1,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1373\/revisions"}],"predecessor-version":[{"id":1374,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1373\/revisions\/1374"}],"wp:attachment":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}