{"id":5107,"date":"2025-11-21T14:20:56","date_gmt":"2025-11-21T07:20:56","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-sao-chep-cong-thuc-excel-khong-bi-loi-dinh-dang\/"},"modified":"2025-11-21T14:20:56","modified_gmt":"2025-11-21T07:20:56","slug":"cach-sao-chep-cong-thuc-excel-khong-bi-loi-dinh-dang","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-sao-chep-cong-thuc-excel-khong-bi-loi-dinh-dang\/","title":{"rendered":"C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c Excel kh\u00f4ng b\u1ecb l\u1ed7i \u0111\u1ecbnh d\u1ea1ng"},"content":{"rendered":"
\n
\u00a0<\/div>\n

Sao ch\u00e9p c\u00f4ng th\u1ee9c l\u00e0 thao t\u00e1c quan tr\u1ecdng gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u Excel nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 c\u00e1c c\u00e1ch copy c\u00f4ng th\u1ee9c nh\u01b0 k\u00e9o Fill Handle, nh\u1ea5p \u0111\u00fap chu\u1ed9t, d\u00f9ng ph\u00edm t\u1eaft, sao ch\u00e9p gi\u1eef nguy\u00ean \u0111\u1ecbnh d\u1ea1ng v\u00e0 copy \u1edf c\u00e1c \u00f4 kh\u00f4ng li\u1ec1n nhau.<\/p>\n

\"SaoH\u01b0\u1edbng d\u1eabn sao ch\u00e9p c\u00f4ng th\u1ee9c Excel kh\u00f4ng b\u1ecb l\u1ed7i \u0111\u1ecbnh d\u1ea1ng<\/em><\/p>\n

\n

1. Sao ch\u00e9p c\u00f4ng th\u1ee9c Excel b\u1eb1ng c\u00e1ch k\u00e9o h\u00e0m t\u1ef1 \u0111\u1ed9ng<\/h2>\n<\/div>\n

Excel h\u1ed7 tr\u1ee3 sao ch\u00e9p c\u00f4ng th\u1ee9c r\u1ea5t nhanh b\u1eb1ng thao t\u00e1c k\u00e9o d\u1ecdc c\u00e1c \u00f4.<\/p>\n

B\u01b0\u1edbc 1: <\/strong>Ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c, \u0111\u01b0a chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4 cho \u0111\u1ebfn khi xu\u1ea5t hi\u1ec7n bi\u1ec3u t\u01b0\u1ee3ng d\u1ea5u c\u1ed9ng m\u00e0u \u0111en<\/strong> (\u0111\u00e2y l\u00e0 Fill Handle).<\/p>\n

\"SaoK\u00e9o Fill Handle \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c \u00f4 b\u00ean d\u01b0\u1edbi<\/em><\/p>\n

B\u01b0\u1edbc 2: Khi bi\u1ec3u t\u01b0\u1ee3ng hi\u1ec7n ra, nh\u1ea5n gi\u1eef chu\u1ed9t<\/strong> v\u00e0 k\u00e9o Fill Handle<\/strong> xu\u1ed1ng d\u01b0\u1edbi \u0111\u1ebfn nh\u1eefng \u00f4 c\u1ea7n \u00e1p d\u1ee5ng c\u00f9ng c\u00f4ng th\u1ee9c.<\/p>\n

\"C\u00e1cK\u1ebft qu\u1ea3 sau khi k\u00e9o Fill Handle \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t<\/em><\/p>\n

T\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 k\u00e9o sang tr\u00e1i, sang ph\u1ea3i ho\u1eb7c l\u00ean tr\u00ean \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c sang c\u00e1c v\u1ecb tr\u00ed li\u1ec1n k\u1ec1 kh\u00e1c.<\/p>\n

\n

2. C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c Excel b\u1eb1ng 2 l\u1ea7n nh\u1ea5n chu\u1ed9t<\/h2>\n<\/div>\n

\u0110\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c cho to\u00e0n b\u1ed9 c\u1ed9t m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, h\u00e3y ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 \u0111\u01b0a chu\u1ed9t \u0111\u1ebfn g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i c\u1ee7a \u00f4. Khi con tr\u1ecf chuy\u1ec3n th\u00e0nh d\u1ea5u c\u1ed9ng nh\u1ecf, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p \u0111\u00fap chu\u1ed9t.<\/p>\n

Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c h\u00e0ng b\u00ean d\u01b0\u1edbi d\u1ef1a tr\u00ean ph\u1ea1m vi d\u1eef li\u1ec7u c\u00f3 s\u1eb5n.<\/p>\n

\"Nh\u1ea5pNh\u1ea5p \u0111\u00fap chu\u1ed9t v\u00e0o Fill Handle \u0111\u1ec3 Excel t\u1ef1 sao ch\u00e9p c\u00f4ng th\u1ee9c<\/em><\/p>\n

L\u01b0u \u00fd: <\/strong>C\u00f4ng th\u1ee9c ch\u1ec9 \u0111\u01b0\u1ee3c sao ch\u00e9p li\u00ean t\u1ee5c cho \u0111\u1ebfn khi Excel g\u1eb7p m\u1ed9t h\u00e0ng tr\u1ed1ng \u1edf c\u00e1c c\u1ed9t b\u00ean tr\u00e1i. Ngay khi c\u00f3 d\u00f2ng kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u, qu\u00e1 tr\u00ecnh \u0111i\u1ec1n t\u1ef1 \u0111\u1ed9ng s\u1ebd d\u1eebng l\u1ea1i.<\/p>\n

Xem th\u00eam: <\/strong>C\u00e1ch s\u1eeda l\u1ed7i \u0111\u1ecbnh d\u1ea1ng s\u1ed1 trong Excel c\u1ef1c \u0111\u01a1n gi\u1ea3n<\/div>\n
\n

3. C\u00e1ch sao ch\u00e9p c\u00f4ng th\u1ee9c Excel b\u1eb1ng ph\u00edm t\u1eaft<\/h2>\n<\/div>\n
\n

3.1. Sao ch\u00e9p \u0111\u1ebfn \u00f4 b\u00ean d\u01b0\u1edbi<\/h3>\n<\/div>\n

\u0110\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb \u00f4 ph\u00eda tr\u00ean xu\u1ed1ng \u00f4 ngay b\u00ean d\u01b0\u1edbi, b\u1ea1n ch\u1ec9 c\u1ea7n:<\/p>\n

    \n
  • Ch\u1ecdn \u00f4 n\u1eb1m d\u01b0\u1edbi \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c.<\/li>\n
  • Nh\u1ea5n Ctrl + D<\/strong> \u0111\u1ec3 \u0111i\u1ec1n l\u1ea1i c\u00f4ng th\u1ee9c.<\/li>\n<\/ul>\n

    Khi d\u00f9ng Ctrl + D, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1u ch\u1ec9nh tham chi\u1ebfu n\u1ebfu c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i.<\/p>\n

    \"S\u1eedD\u00f9ng Ctrl + D \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng \u00f4 ngay b\u00ean d\u01b0\u1edbi<\/em><\/p>\n

    \n

    3.2. Sao ch\u00e9p \u0111\u1ebfn \u00f4 b\u00ean ph\u1ea3i<\/h3>\n<\/div>\n

    \u0110\u1ec3 copy c\u00f4ng th\u1ee9c t\u1eeb \u00f4 hi\u1ec7n t\u1ea1i sang \u00f4 k\u1ebf b\u00ean \u1edf ph\u00eda ph\u1ea3i, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ph\u00edm t\u1eaft sau:<\/p>\n

      \n
    • Ch\u1ecdn \u00f4 n\u1eb1m b\u00ean ph\u1ea3i \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c.<\/li>\n
    • Nh\u1ea5n t\u1ed5 h\u1ee3p Ctrl + R <\/strong>\u0111\u1ec3 Excel sao ch\u00e9p v\u00e0 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c sang v\u1ecb tr\u00ed m\u1edbi.<\/li>\n<\/ul>\n

      \"D\u00f9ngD\u00f9ng Ctrl + R \u0111\u1ec3 sao ch\u00e9p c\u00f4ng th\u1ee9c sang \u00f4 b\u00ean ph\u1ea3i<\/em><\/p>\n

      \n

      3.3. Sao ch\u00e9p \u0111\u1ebfn \u00f4 b\u00ean d\u01b0\u1edbi v\u00e0 gi\u1eef nguy\u00ean \u0111\u1ecbnh d\u1ea1ng<\/h3>\n<\/div>\n

      Khi c\u1ea7n copy c\u00f4ng th\u1ee9c t\u1eeb \u00f4 ph\u00eda tr\u00ean xu\u1ed1ng \u00f4 b\u00ean d\u01b0\u1edbi nh\u01b0ng v\u1eabn mu\u1ed1n gi\u1eef nguy\u00ean to\u00e0n b\u1ed9 \u0111\u1ecba ch\u1ec9 tham chi\u1ebfu trong c\u00f4ng th\u1ee9c, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng ph\u00edm t\u1eaft sau:<\/p>\n

        \n
      • Ch\u1ecdn \u00f4 n\u1eb1m d\u01b0\u1edbi \u00f4 c\u00f3 c\u00f4ng th\u1ee9c.<\/li>\n
      • Nh\u1ea5n t\u1ed5 h\u1ee3p Ctrl + ‘<\/strong> \u0111\u1ec3 sao ch\u00e9p nguy\u00ean v\u1eb9n c\u00f4ng th\u1ee9c xu\u1ed1ng \u00f4 d\u01b0\u1edbi.<\/li>\n<\/ul>\n

        \"CopySao ch\u00e9p c\u00f4ng th\u1ee9c xu\u1ed1ng \u00f4 d\u01b0\u1edbi v\u00e0 gi\u1eef nguy\u00ean tham chi\u1ebfu b\u1eb1ng Ctrl + ‘<\/em><\/p>\n

        L\u01b0u \u00fd:<\/strong> C\u00e1ch sao ch\u00e9p n\u00e0y gi\u1eef nguy\u00ean to\u00e0n b\u1ed9 tham chi\u1ebfu \u00f4 c\u1ee7a c\u00f4ng th\u1ee9c g\u1ed1c, v\u00ec v\u1eady c\u00f4ng th\u1ee9c s\u1ebd kh\u00f4ng t\u1ef1 nh\u1ea3y s\u1ed1 h\u00e0ng. C\u00e1c \u0111\u1ecba ch\u1ec9 nh\u01b0 C2, D2\u2026 v\u1eabn gi\u1eef nguy\u00ean thay v\u00ec chuy\u1ec3n th\u00e0nh C3, D3.<\/p>\n

        \n

        4. Copy c\u00f4ng th\u1ee9c Excel \u0111\u1ed1i v\u1edbi \u00f4 kh\u00f4ng li\u1ec1n nhau<\/h2>\n<\/div>\n
        \n

        4.1. Copy h\u00e0ng lo\u1ea1t<\/h3>\n<\/div>\n

        Khi c\u1ea7n sao ch\u00e9p c\u00f9ng m\u1ed9t c\u00f4ng th\u1ee9c cho nhi\u1ec1u \u00f4 c\u00f9ng l\u00fac, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn \u00f4 ch\u1ee9a c\u00f4ng th\u1ee9c ho\u1eb7c h\u00e0m mu\u1ed1n sao ch\u00e9p v\u00e0 nh\u1ea5n Ctrl + C<\/strong> \u0111\u1ec3 copy.<\/p>\n

        \"SaoCopy c\u00f4ng th\u1ee9c h\u00e0ng lo\u1ea1t b\u1eb1ng Ctrl + C<\/em><\/p>\n

        B\u01b0\u1edbc 2: <\/strong>B\u00f4i \u0111en to\u00e0n b\u1ed9 c\u00e1c \u00f4 c\u1ea7n \u00e1p d\u1ee5ng c\u00f9ng c\u00f4ng th\u1ee9c, sau \u0111\u00f3 nh\u1ea5n Ctrl + V<\/strong> \u0111\u1ec3 d\u00e1n h\u00e0ng lo\u1ea1t.<\/p>\n

        \"D\u00e1nD\u00e1n c\u00f4ng th\u1ee9c h\u00e0ng lo\u1ea1t v\u1edbi Ctrl + V<\/em><\/p>\n

        \n

        4.2. Ch\u1ec9 copy c\u00f4ng th\u1ee9c<\/h3>\n<\/div>\n

        Khi b\u1ea1n mu\u1ed1n l\u1ea5y l\u1ea1i c\u00f4ng th\u1ee9c t\u1eeb m\u1ed9t \u00f4 m\u00e0 kh\u00f4ng mang theo m\u00e0u n\u1ec1n, ki\u1ec3u ch\u1eef hay c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c, c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

        B\u01b0\u1edbc 1:<\/strong> Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u0111ang ch\u1ee9a c\u00f4ng th\u1ee9c v\u00e0 ch\u1ecdn Copy<\/strong>.<\/p>\n

        \"MenuSao ch\u00e9p c\u00f4ng th\u1ee9c b\u1eb1ng menu chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Copy<\/em><\/p>\n

        B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u0111\u00edch. T\u1ea1i m\u1ee5c Paste Options<\/strong>, ch\u1ecdn Formulas<\/strong> \u0111\u1ec3 ch\u1ec9 d\u00e1n ph\u1ea7n c\u00f4ng th\u1ee9c m\u00e0 kh\u00f4ng sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 g\u1ed1c.<\/p>\n

        \"Ch\u1ecdnCh\u1ec9 d\u00e1n c\u00f4ng th\u1ee9c b\u1eb1ng l\u1ef1a ch\u1ecdn Paste Formulas<\/em><\/p>\n

        Sao ch\u00e9p c\u00f4ng th\u1ee9c \u0111\u00fang c\u00e1ch gi\u00fap b\u1ea1n thao t\u00e1c nhanh h\u01a1n v\u00e0 h\u1ea1n ch\u1ebf l\u1ed7i trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u Excel. N\u1ebfu mu\u1ed1n kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u th\u1ee7 thu\u1eadt h\u1eefu \u00edch kh\u00e1c, h\u00e3y theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u01b0\u1eddng xuy\u00ean.<\/p>\n

        N\u1ebfu b\u1ea1n mu\u1ed1n n\u00e2ng c\u1ea5p thi\u1ebft b\u1ecb \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp ti\u1ec7n l\u1ee3i h\u01a1n, h\u00e3y tham kh\u1ea3o c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7n \u0111\u1ea1i \u0111ang \u0111\u01b0\u1ee3c \u01b0u \u0111\u00e3i t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn s\u1ea3n ph\u1ea9m ph\u00f9 h\u1ee3p nhu c\u1ea7u.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

        \u00a0 Sao ch\u00e9p c\u00f4ng th\u1ee9c l\u00e0 thao t\u00e1c quan tr\u1ecdng gi\u00fap b\u1ea1n x\u1eed l\u00fd d\u1eef li\u1ec7u Excel nhanh v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 c\u00e1c c\u00e1ch copy c\u00f4ng th\u1ee9c nh\u01b0 k\u00e9o Fill Handle, nh\u1ea5p \u0111\u00fap chu\u1ed9t, d\u00f9ng ph\u00edm t\u1eaft, sao ch\u00e9p gi\u1eef nguy\u00ean \u0111\u1ecbnh d\u1ea1ng v\u00e0 copy \u1edf c\u00e1c […]<\/p>\n","protected":false},"author":1,"featured_media":5108,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5107","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19408.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5107"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5107\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5108"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}