{"id":1381,"date":"2025-11-30T04:31:51","date_gmt":"2025-11-30T04:31:51","guid":{"rendered":"https:\/\/growhome.vn\/?p=1381"},"modified":"2025-11-30T04:31:52","modified_gmt":"2025-11-30T04:31:52","slug":"can-chinh-khoang-trang-hang-trong-bang-co-ve-0","status":"publish","type":"post","link":"https:\/\/growhome.vn\/?p=1381","title":{"rendered":"C\u0103n ch\u1ec9nh kho\u1ea3ng tr\u1eafng h\u00e0ng trong b\u1ea3ng, co v\u1ec1 “0”"},"content":{"rendered":"
\n\t\t\t\t\t\n\t\t\t\t\t\t\"Fb-Button\"\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>
<\/fb:like><\/div><\/div>\n

H\u1ecfi:
Trong b\u1ea3ng trong file c\u1ee7a t\u00f4i xu\u1ea5t hi\u1ec7n nhi\u1ec1u kho\u1ea3ng tr\u1eafng nh\u01b0 n\u00e0y, l\u00e0m sao \u0111\u1ec3 ch\u1ec9nh h\u00e0ng lo\u1ea1t th\u1ed1ng s\u1ed1 height v\u1ec1 kh\u00f4ng trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng<\/p>\n\n\n\n

Tr\u1ea3 l\u1eddi:<\/p>\n\n\n\n

Ch\u00e0o b\u1ea1n,<\/p>\n\n\n\n

Vi\u1ec7c c\u00f3 nhi\u1ec1u kho\u1ea3ng tr\u1eafng l\u1edbn b\u00ean trong c\u00e1c \u00f4 c\u1ee7a b\u1ea3ng (nh\u01b0 khu v\u1ef1c khoanh \u0111\u1ecf) cho th\u1ea5y c\u00e1c h\u00e0ng \u0111\u00f3 \u0111ang b\u1ecb c\u1ed1 \u0111\u1ecbnh chi\u1ec1u cao (Fixed Height) l\u1edbn h\u01a1n so v\u1edbi n\u1ed9i dung b\u00ean trong, ho\u1eb7c ch\u00fang \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1eb7t chi\u1ec1u cao t\u1ed1i thi\u1ec3u (At least) r\u1ea5t l\u1edbn.<\/p>\n\n\n\n

\u0110\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng n\u00e0y v\u00e0 cho ph\u00e9p chi\u1ec1u cao h\u00e0ng t\u1ef1 \u0111\u1ed9ng co l\u1ea1i theo n\u1ed9i dung, b\u1ea1n c\u1ea7n chuy\u1ec3n thi\u1ebft l\u1eadp chi\u1ec1u cao h\u00e0ng v\u1ec1 ch\u1ebf \u0111\u1ed9 t\u1ef1 \u0111\u1ed9ng (Auto)<\/strong> trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng.<\/p>\n\n\n\n

R\u1ea5t ti\u1ebfc, Word kh\u00f4ng c\u00f3 n\u00fat l\u1ec7nh tr\u1ef1c ti\u1ebfp \u0111\u1ec3 thay \u0111\u1ed5i thu\u1ed9c t\u00ednh n\u00e0y cho to\u00e0n b\u1ed9 c\u00e1c b\u1ea3ng c\u00f9ng l\u00fac, v\u00ec v\u1eady, Macro (VBA)<\/strong> l\u00e0 gi\u1ea3i ph\u00e1p nhanh nh\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n\n\n\n

Macro (VBA) \u0111\u1ec3 chuy\u1ec3n chi\u1ec1u cao h\u00e0ng v\u1ec1 ch\u1ebf \u0111\u1ed9 Auto<\/h3>\n\n\n\n

Macro n\u00e0y s\u1ebd duy\u1ec7t qua t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng v\u00e0 \u0111\u1eb7t Row Height Rule<\/strong> (Quy t\u1eafc chi\u1ec1u cao h\u00e0ng) v\u1ec1 ch\u1ebf \u0111\u1ed9 Auto<\/strong> (T\u1ef1 \u0111\u1ed9ng).<\/p>\n\n\n\n

B\u01b0\u1edbc 1, 2, 3: M\u1edf VBA, Ch\u00e8n Module v\u00e0 D\u00e1n Code<\/h4>\n\n\n\n
    \n
  1. Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm: Alt + F11<\/strong> \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Visual Basic Editor.<\/li>\n\n\n\n
  2. V\u00e0o menu Insert<\/strong> (Ch\u00e8n) v\u00e0 ch\u1ecdn Module<\/strong>.<\/li>\n\n\n\n
  3. Sao ch\u00e9p v\u00e0 d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o Module: <\/li>\n\n\n\n
  4. Link t\u1ea3i m\u00e3: https:\/\/drive.google.com\/file\/d\/1VO1VxmLGKRIpzBbT9X-AcMS4AxW2FJ8u\/view?usp=sharing<\/a><\/li>\n<\/ol>\n\n\n\n

    B\u01b0\u1edbc 4: Ch\u1ea1y Macro<\/h4>\n\n\n\n
      \n
    1. Quay tr\u1edf l\u1ea1i c\u1eeda s\u1ed5 Word.<\/li>\n\n\n\n
    2. Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm: Alt + F8<\/strong> \u0111\u1ec3 m\u1edf danh s\u00e1ch Macro.<\/li>\n\n\n\n
    3. Ch\u1ecdn Macro t\u00ean l\u00e0 ChuyenChieuCaoHangVeAuto<\/strong>.<\/li>\n\n\n\n
    4. Nh\u1ea5n n\u00fat Run (Ch\u1ea1y)<\/strong>.<\/li>\n<\/ol>\n\n\n\n

      Sau khi ch\u1ea1y xong, t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng trong m\u1ecdi b\u1ea3ng s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u1ea1i chi\u1ec1u cao t\u1ef1 \u0111\u1ed9ng theo n\u1ed9i dung, lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba.<\/p>\n\n\n\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      H\u1ecfi: Trong b\u1ea3ng trong file c\u1ee7a t\u00f4i xu\u1ea5t hi\u1ec7n nhi\u1ec1u kho\u1ea3ng tr\u1eafng nh\u01b0 n\u00e0y, l\u00e0m sao \u0111\u1ec3 ch\u1ec9nh h\u00e0ng lo\u1ea1t th\u1ed1ng s\u1ed1 height v\u1ec1 kh\u00f4ng trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng Tr\u1ea3 l\u1eddi: Ch\u00e0o b\u1ea1n, Vi\u1ec7c c\u00f3 nhi\u1ec1u kho\u1ea3ng tr\u1eafng l\u1edbn b\u00ean trong c\u00e1c \u00f4 c\u1ee7a b\u1ea3ng (nh\u01b0 khu v\u1ef1c khoanh \u0111\u1ecf) cho th\u1ea5y c\u00e1c h\u00e0ng…<\/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-1381","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\/1381","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=1381"}],"version-history":[{"count":1,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1381\/revisions"}],"predecessor-version":[{"id":1382,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1381\/revisions\/1382"}],"wp:attachment":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}