{"id":11148,"date":"2025-01-15T01:51:35","date_gmt":"2025-01-15T01:51:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/5-cach-de-su-dung-lenh-go-to-special-hieu-qua-trong-excel\/"},"modified":"2025-01-15T01:51:35","modified_gmt":"2025-01-15T01:51:35","slug":"5-cach-de-su-dung-lenh-go-to-special-hieu-qua-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/5-cach-de-su-dung-lenh-go-to-special-hieu-qua-trong-excel\/","title":{"rendered":"5 c\u00e1ch \u0111\u1ec3 s\u1eed d\u1ee5ng l\u1ec7nh \u201cGo to Special\u201d hi\u1ec7u qu\u1ea3 trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, Blog H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n 5 c\u00e1ch s\u1eed d\u1ee5ng l\u1ec7nh \u201cGo to Special\u201d hi\u1ec7u qu\u1ea3 trong Excel. Gi\u1ed1ng nh\u01b0 t\u00ean g\u1ecdi c\u1ee7a n\u00f3, l\u1ec7nh n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng t\u00ecm \u0111\u01b0\u1ee3c \u00f4 t\u00ednh ho\u1eb7c d\u1ea3i \u00f4 t\u00ednh \u0111\u00e1p \u1ee9ng \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u \u0111\u1ec1 ra. Ch\u1eb3ng h\u1ea1n, n\u1ebfu b\u1ea1n c\u1ea7n truy c\u1eadp t\u1ea5t c\u1ea3 c\u00e1c \u00f4 t\u00ednh ch\u1ee9a c\u00f4ng th\u1ee9c trong b\u1ea3ng th\u00ec l\u1ef1a ch\u1ecdn Go to Special kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1ed3i ch\u00fat n\u00e0o.<\/p>\n

Kh\u00f4ng ch\u1ec9 ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c, l\u1ec7nh n\u00e0y c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm c\u00e1c kho\u1ea3ng tr\u1eafng, t\u1ea1o nh\u1eadn x\u00e9t, t\u00ecm l\u1ed7i, \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, Data Validation, v.v.<\/p>\n

<\/p>\n

\n

Ki\u1ebfn th\u1ee9c c\u0103n b\u1ea3n v\u1ec1 l\u1ec7nh Go to Special<\/strong><\/a><\/p>\n<\/blockquote>\n

\u0110\u1ec3 m\u1edf l\u1ec7nh n\u00e0y trong Excel 2010, b\u1ea1n click v\u00e0o ph\u1ea7n thanh t\u00e1c v\u1ee5 Home -> Find&Select -> Trong c\u1eeda s\u1ed5 x\u1ed5 xu\u1ed1ng b\u1ea1n ch\u1ecdn Go to Special<\/p>\n

B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + G -> Click v\u00e0o ph\u00edm Special<\/p>\n

    \n
  1. T\u00ecm ki\u1ebfm nh\u1eadn x\u00e9t<\/strong><\/li>\n<\/ol>\n

    Ch\u1ee9c n\u0103ng n\u00e0y t\u1ecf ra v\u00f4 c\u00f9ng h\u1eefu hi\u1ec7u khi b\u1ea1n c\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn v\u00e0 l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 nh\u1eefng nh\u1eadn x\u00e9t \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o trong worksheet. \u0110i\u1ec1u nay thu\u1eadn ti\u1ec7n h\u01a1n so v\u1edbi vi\u1ec7c m\u1ed7i l\u1eddi nh\u1eadn x\u00e9t ch\u1ec9 \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u \u0111\u1ecf m\u1eb7c \u0111\u1ecbnh \u1edf \u0111\u1ea7u c\u00e2u v\u00e0 b\u1ea1n ph\u1ea3i click v\u00e0o t\u1eebng comment \u0111\u1ec3 c\u00f3 th\u1ec3 x\u00f3a \u0111i \u0111\u01b0\u1ee3c.<\/p>\n

    Ch\u1ecdn Go to Special -> Ch\u1ecdn Comments -> B\u1ea5m OK l\u00e0 xong<\/p>\n

      \n
    1. T\u00ecm c\u00f4ng th\u1ee9c<\/strong><\/li>\n<\/ol>\n

      T\u1ed5ng th\u1ec3 th\u00ec m\u1ed9t b\u1ea3ng t\u00ednh workbook s\u1ebd l\u00e0 t\u1eadp h\u1ee3p c\u00e1c k\u00fd t\u1ef1 ch\u1eef, s\u1ed1, c\u00f4ng th\u1ee9c, bi\u1ec3u \u0111\u1ed3 v\u00e0 c\u00e1c ph\u00e9p to\u00e1n logic. Tuy nhi\u00ean khi ph\u00e2n t\u00edch th\u00ec ta ch\u1ec9 t\u00e1ch ch\u00fang th\u00e0nh 2 nh\u00f3m d\u1eef li\u1ec7u ch\u00ednh, \u0111\u00f3 l\u00e0 d\u1eef li\u1ec7u \u00f4 t\u00ednh d\u1ea1ng k\u00fd t\u1ef1 v\u00e0 d\u1eef li\u1ec7u \u00f4 t\u00ednh d\u1ea1ng c\u00f4ng th\u1ee9c.<\/p>\n

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

      <\/p>\n

      \u0110\u1ec3 l\u1ef1a ch\u1ecdn t\u00ecm ki\u1ebfm k\u00fd t\u1ef1 s\u1ed1, b\u1ea1n l\u1ef1a ch\u1ecdn Go to Special -> Formulas -> Click v\u00e0o \u00f4 Numbers<\/p>\n

      \u0110\u1ec3 l\u1ef1a ch\u1ecdn t\u00ecm ki\u1ebfm l\u1ed7i, b\u1ea1n l\u1ef1a ch\u1ecdn Go to Special -> Formulas -> Click v\u00e0o \u00f4 Errors<\/p>\n

      T\u01b0\u01a1ng t\u1ef1 b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 l\u00e0m \u0111\u1ed1i v\u1edbi k\u00fd t\u1ef1 ch\u1eef v\u00e0 c\u00e1c ph\u00e9p to\u00e1n logic.<\/p>\n

        \n
      1. \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/strong><\/li>\n<\/ol>\n

        \u0110\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n l\u00e0 m\u1ed9t c\u00e1ch tr\u00ecnh b\u00e0y s\u1ed1 li\u1ec7u v\u00f4 c\u00f9ng hi\u1ec7u qu\u1ea3. Tuy nhi\u00ean tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y th\u00ec ta c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c nh\u1eefng \u00f4 t\u00ednh c\u1ea7n ch\u1ec9nh s\u1eeda ho\u1eb7c thi\u1ebft l\u1eadp l\u1ea1i ph\u00e9p to\u00e1n logic \u0111\u00e3.<\/p>\n

        \u0110\u1ec3 t\u00ecm c\u00e1c \u00f4 t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, b\u1ea1n ch\u1ecdn Go to Special -> Ch\u1ecdn Conditional Formats<\/p>\n

          \n
        1. Data Validation<\/strong><\/li>\n<\/ol>\n

          Ch\u1ee9c n\u0103ng ki\u1ec3m duy\u1ec7t d\u1eef li\u1ec7u (Data Validation) c\u00f3 t\u00e1c d\u1ee5ng h\u1ea1n ch\u1ebf ng\u01b0\u1eddi d\u00f9ng truy c\u1eadp nh\u1eefng d\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p. Ch\u1eb3ng h\u1ea1n, n\u1ebfu trong c\u1ed9t d\u1eef li\u1ec7u th\u00f4ng b\u00e1o n\u1ed9i dung c\u00f3 t\u00ean l\u00e0 \u201ctelephone number\u201d th\u00ec ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 c\u00f3 th\u1ec3 \u0111i\u1ec1n k\u00fd t\u1ef1 s\u1ed1 v\u00e0o m\u00e0 th\u00f4i. S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng n\u00e0y, ta c\u0169ng c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t h\u00f4p tho\u1ea1i x\u1ed5 xu\u1ed1ng ch\u1ee9a c\u00e1c l\u1ef1a ch\u1ecdn \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng t\u00f9y ch\u1ecdn theo y\u00eau c\u1ea7u.<\/p>\n

          Tuy c\u00f3 nhi\u1ec1u \u00edch l\u1ee3i nh\u01b0 v\u1eady, m\u1ed9t v\u1ea5n \u0111\u1ec3 n\u1ed5i l\u00ean \u0111\u00f3 l\u00e0 l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c \u0111\u00e2u l\u00e0 \u00f4 t\u00ednh b\u1ecb ki\u1ec3m so\u00e1t n\u1ed9i dung v\u00e0 \u0111\u00e2y kh\u00f4ng ph\u1ea3i. \u0110\u1ec3 tr\u00e1nh g\u1eb7p ph\u1ea3i nh\u1eefng l\u1ed7i ki\u1ec3m duy\u1ec7t d\u1eef li\u1ec7u th\u00ec ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u1ec7nh Go to Special \u0111\u1ec3 t\u00ecm ki\u1ebfm nh\u1eefng \u00f4 t\u00ednh n\u00e0o ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n ki\u1ec3m duy\u1ec7t.<\/p>\n

          B\u1ea1n h\u00e3y ch\u1ecdn l\u1ec7nh Go to Special -> Ch\u1ecdn Data Validation -> Click OK<\/p>\n

            \n
          1. \u00d4 tr\u1ed1ng<\/strong><\/li>\n<\/ol>\n

            N\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng b\u1ea3ng Pivot, v\u1eady th\u00ec ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 t\u1eebng th\u1eed s\u1eed d\u00f9ng l\u1ec7nh \u201dBlanks\u201d \u00edt nh\u1ea5t 1 v\u00e0i l\u1ea7n. V\u00ed d\u1ee5 ta c\u00f3 m\u1ed9t b\u1ea3ng Pivot th\u1ec3 hi\u1ec7n doanh s\u1ed1 b\u00e1n h\u00e0ng, trong \u0111\u00f3 \u0111\u01b0\u1ee3c ph\u00e2n lo\u1ea1i theo ph\u00e2n kh\u00fac kh\u00e1ch h\u00e0ng c\u0169ng nh\u01b0 lo\u1ea1i m\u1eb7t h\u00e0ng. B\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i b\u1ea3ng n\u00e0y tr\u1edf th\u00e0nh 1 b\u1ea3ng d\u1eef li\u1ec7u th\u00f4ng th\u01b0\u1eddng, ch\u1ec9 b\u1eb1ng l\u1ec7nh Paste Special. Tuy nhi\u00ean, v\u1ea5n \u0111\u1ec1 n\u1eb1m \u1edf ch\u1ed7 trong c\u00e1c c\u1ed9t thu\u1ed9c danh m\u1ee5c Ph\u00e2n kh\u00fac kh\u00e1ch h\u00e0ng kh\u00f4ng \u0111\u01b0\u1ee3c ch\u1ee9a c\u00e1c \u00f4\u00a0tr\u1ed1ng.<\/p>\n

            <\/p>\n

            \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3, b\u1ea1n c\u1ea7n sao ch\u00e9p to\u00e0n b\u1ed9 b\u1ea3ng Pivot tr\u00ean v\u00e0 s\u1eed d\u1ee5ng Paste Special cho t\u1eebng gi\u00e1 tr\u1ecb m\u1ed9t.<\/p>\n

            Ch\u1ecdn to\u00e0n b\u1ed9 b\u1ea3ng -> B\u1ea5m v\u00e0o Go to Special -> Ch\u1ecdn \u201cBlanks\u201d -> Click OK -> sau \u0111\u00f3 click v\u00e0o d\u1ea5u b\u1eb1ng (=) -> Click ch\u1ecdn Up Arrow -> B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm Ctrl + Enter<\/p>\n

            L\u01b0u \u00fd: B\u1ea1n c\u1ea7n ph\u1ea3i sao ch\u00e9p to\u00e0n b\u1ed9 b\u1ea3ng m\u1ed9t l\u1ea7n n\u1eefa v\u00e0 d\u00f9ng l\u1ec7nh Paste Special \u0111\u1ec3 lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 c\u00f4ng th\u1ee9c c\u00f3 trong \u0111\u00f3.<\/p>\n

            K\u1ebft qu\u1ea3 c\u00f3 \u0111\u01b0\u1ee3c s\u1ebd gi\u1ed1ng v\u1edbi h\u00ecnh sau<\/p>\n

            <\/p>\n

            \n

            H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a><\/p>\n<\/blockquote>\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":11149,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11148","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11148","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=11148"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11149"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}