{"id":6250,"date":"2024-12-21T14:15:53","date_gmt":"2024-12-21T14:15:53","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-xoa-hang-dua-vao-gia-tri-cua-o-trong-excel\/"},"modified":"2024-12-21T14:15:53","modified_gmt":"2024-12-21T14:15:53","slug":"cach-xoa-hang-dua-vao-gia-tri-cua-o-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-xoa-hang-dua-vao-gia-tri-cua-o-trong-excel\/","title":{"rendered":"C\u00e1ch x\u00f3a h\u00e0ng d\u1ef1a v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 trong Excel"},"content":{"rendered":"
\n

\u0110\u1ec3 nhanh ch\u00f3ng x\u00f3a m\u1ed9t ho\u1eb7c nhi\u1ec1u h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb \u00f4 trong Excel, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ph\u1ea3i ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c h\u00e0ng c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb \u00f4 c\u1ee5 th\u1ec3 tr\u01b0\u1edbc v\u00e0 sau \u0111\u00f3 lo\u1ea1i b\u1ecf ch\u00fang. D\u01b0\u1eddng nh\u01b0 kh\u00f4ng c\u00f3 c\u00e1ch n\u00e0o nhanh ch\u00f3ng \u0111\u1ec3 x\u00f3a c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 b\u1eb1ng s\u1eed d\u1ee5ng m\u00e3 VBA<\/a>. \u0110\u00e2y l\u00e0 m\u1ed9t s\u1ed1 th\u1ee7 thu\u1eadt nhanh \u0111\u1ec3 gi\u00fap b\u1ea1n.<\/p>\n

X\u00f3a h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb \u00f4 b\u1eb1ng t\u00ednh n\u0103ng Find and Replace
\nTrong Excel, b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng t\u00ednh n\u0103ng Find and Replace<\/strong> \u0111\u1ec3 x\u00f3a h\u00e0ng d\u1ef1a tr\u00ean m\u1ed9t gi\u00e1 tr\u1ecb \u00f4 m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng. H\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

    \n
  1. Ch\u1ecdn ph\u1ea1m vi m\u00e0 b\u1ea1n s\u1ebd x\u00f3a c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh v\u00e0 m\u1edf h\u1ed9p tho\u1ea1i Find and Replace<\/strong> b\u1eb1ng c\u00e1ch nh\u1ea5n c\u00e1c ph\u00edm Ctrl + F<\/strong> c\u00f9ng m\u1ed9t l\u00fac.<\/li>\n
  2. Trong h\u1ed9p tho\u1ea1i Find and Replace<\/strong>, vui l\u00f2ng nh\u1eadp gi\u00e1 tr\u1ecb \u00f4 nh\u1ea5t \u0111\u1ecbnh (trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang t\u00f4i, nh\u1eadp Soe) v\u00e0o h\u1ed9p Find<\/strong> v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Find All<\/strong>. Xem h\u00ecnh \u0111\u1ea7u ti\u00ean b\u00ean d\u01b0\u1edbi:<\/li>\n<\/ol>\n

    <\/p>\n

    <\/p>\n

    3. Ch\u1ecdn t\u1ea5t c\u1ea3 k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm \u1edf cu\u1ed1i h\u1ed9p tho\u1ea1i Find and Replace<\/strong> v\u00e0 \u0111\u00f3ng h\u1ed9p tho\u1ea1i n\u00e0y.<\/p>\n

    L\u01b0u \u00fd: B\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t trong c\u00e1c k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm, sau \u0111\u00f3 nh\u1ea5n Ctrl + A \u0111\u1ec3 ch\u1ecdn t\u1ea5t c\u1ea3 k\u1ebft qu\u1ea3 t\u00ecm th\u1ea5y. Xem h\u00ecnh th\u1ee9 hai \u1edf tr\u00ean.<\/p>\n

    4. Ti\u1ebfp t\u1ee5c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c \u00f4 \u0111\u00e3 ch\u1ecdn v\u00e0 ch\u1ecdn Delete<\/strong>. V\u00e0 sau \u0111\u00f3 ch\u1ecdn t\u00f9y ch\u1ecdn Entire Row<\/strong> trong h\u1ed9p tho\u1ea1i Delete. H\u00e3y xem h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

    <\/p>\n

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

    Lo\u1ea1i b\u1ecf h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb \u00f4 b\u1eb1ng m\u00e3 VBA<\/h1>\n

    V\u1edbi m\u00e3 VBA sau, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng x\u00f3a c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb \u00f4 nh\u1ea5t \u0111\u1ecbnh, vui l\u00f2ng th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

      \n
    1. Nh\u1ea5n ph\u00edm Alt + F11<\/strong> c\u00f9ng l\u00fac \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Microsoft Visual Basic for applications<\/strong><\/li>\n
    2. Nh\u1ea5p v\u00e0o Insert> Module<\/strong>, v\u00e0 nh\u1eadp m\u00e3 sau v\u00e0o Module:<\/li>\n<\/ol>\n
      View the code on Gist<\/a>.<\/div>\n
      <\/div>\n
        \n
      1. Sau \u0111\u00f3 nh\u1ea5p v\u00e0o n\u00fat Run \u0111\u1ec3 ch\u1ea1y m\u00e3.<\/li>\n
      2. Trong h\u1ed9p tho\u1ea1i b\u1eadt l\u00ean, vui l\u00f2ng ch\u1ecdn d\u1ea3i n\u01a1i b\u1ea1n s\u1ebd x\u00f3a h\u00e0ng d\u1ef1a tr\u00ean gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh v\u00e0 nh\u1ea5p v\u00e0o n\u00fat OK.<\/li>\n<\/ol>\n

        5. Trong m\u1ed9t h\u1ed9p tho\u1ea1i kh\u00e1c, vui l\u00f2ng nh\u1eadp gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n s\u1ebd x\u00f3a c\u00e1c h\u00e0ng d\u1ef1a tr\u00ean n\u00f3, v\u00e0 nh\u1ea5p v\u00e0o n\u00fat OK. Xem h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/p>\n

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