{"id":11781,"date":"2025-01-15T05:05:08","date_gmt":"2025-01-15T05:05:08","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sao-chep-dinh-dang-bieu-do-sang-bieu-do-khac-trong-excel\/"},"modified":"2025-01-15T05:05:08","modified_gmt":"2025-01-15T05:05:08","slug":"cach-sao-chep-dinh-dang-bieu-do-sang-bieu-do-khac-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-sao-chep-dinh-dang-bieu-do-sang-bieu-do-khac-trong-excel\/","title":{"rendered":"C\u00e1ch sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3 sang bi\u1ec3u \u0111\u1ed3 kh\u00e1c trong Excel"},"content":{"rendered":"
\n

Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 sang bi\u1ec3u \u0111\u1ed3 kh\u00e1c b\u1eb1ng Paste Special<\/strong><\/p>\n

Trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, bi\u1ec3u \u0111\u1ed3 \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo \u00fd b\u1ea1n, v\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng n\u00e0y v\u1edbi bi\u1ec3u \u0111\u1ed3 kh\u00e1c.<\/p>\n

<\/p>\n

T\u00ednh n\u0103ng\u00a0Paste Special\u00a0<\/strong><\/em>c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3.<\/p>\n

1. Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng.<\/p>\n

2. Trong th\u1ebb\u00a0Home<\/strong><\/em>, nh\u1ea5n\u00a0Copy<\/strong><\/em>.<\/p>\n

\"doc-copy-chart-format1\"<\/p>\n

3. Ch\u1ecdn m\u1ed9t bi\u1ec3u \u0111\u1ed3 kh\u00e1c b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng l\u1ea1i, nh\u1ea5n Home\u00a0>\u00a0Paste\u00a0>\u00a0Paste Special<\/strong><\/em>, trong h\u1ed9p tho\u1ea1i hi\u1ec7n l\u00ean, \u0111\u00e1nh d\u1ea5u ch\u1ecdn Formats\u00a0<\/strong><\/em>b\u00ean d\u01b0\u1edbi t\u00f9y ch\u1ecdn Paste<\/strong><\/em>.<\/p>\n

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

<\/p>\n

4. Nh\u1ea5n OK. \u0110\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho bi\u1ec3u \u0111\u1ed3 n\u00e0y, l\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc v\u1edbi c\u00e1c bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng l\u1ea1i. K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n

<\/p>\n

Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng m\u1ed9t bi\u1ec3u \u0111\u1ed3 sang bi\u1ec3u \u0111\u1ed3 kh\u00e1c b\u1eb1ng c\u00e1ch t\u1ea1o m\u1ed9t Template<\/strong><\/p>\n

1. Ch\u1ecdn bi\u1ec3u \u0111\u1ed3 \u0111\u1ecbnh d\u1ea1ng b\u1ea1n c\u1ea7n, tr\u00ean th\u1ebb\u00a0Design<\/strong><\/em>, nh\u1ea5n\u00a0Save As Template<\/strong><\/em>.<\/p>\n

<\/p>\n

2. Trong c\u1eeda s\u1ed5 Save Chart Template<\/strong><\/em>, \u0111\u1eb7t t\u00ean cho bi\u1ec3u \u0111\u1ed3 m\u1eabu, nh\u1ea5n Save<\/strong><\/em>. To\u00e0n b\u1ed9 ki\u1ec3u bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c sao l\u01b0u, trong th\u01b0 m\u1ee5c Templates<\/strong><\/em>, n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c ch\u1ecdn khi b\u1ea1n t\u1ea1o bi\u1ec3u \u0111\u1ed3 m\u1edbi.<\/p>\n

<\/p>\n

3. Sau khi t\u1ea1o m\u1eabu bi\u1ec3u \u0111\u1ed3, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i ki\u1ec3u bi\u1ec3u \u0111\u1ed3 kh\u00e1c cho m\u1eabu n\u00e0y, ch\u1ecdn bi\u1ec3u \u0111\u1ed3 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng l\u1ea1i v\u00e0 nh\u1ea5p ph\u1ea3i, ch\u1ecdn Change Chart Type\u00a0<\/strong><\/em>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n

\"doc-copy-chart-format1\"<\/p>\n

4. Trong h\u1ed9p tho\u1ea1i \u00a0Change Chart Type<\/strong><\/em>, nh\u1ea5n Templates<\/strong><\/em>\u00a0t\u1eeb b\u1ea3ng b\u00ean tr\u00e1i, ch\u1ecdn m\u1eabu bi\u1ec3u \u0111\u1ed3 v\u1eeba t\u1ea1o b\u00ean d\u01b0\u1edbi t\u00f9y ch\u1ecdn My Templates<\/strong><\/em>.<\/p>\n

\"doc-copy-chart-format1\"<\/p>\n

5. Nh\u1ea5n OK \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i, \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3 \u0111\u00e3 \u0111\u01b0\u1ee3c sao ch\u00e9p \u0111\u1ebfn bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n

\"doc-copy-chart-format1\"<\/p>\n

6. L\u1eb7p l\u1ea1i b\u01b0\u1edbc 3 \u2013 5 \u0111\u1ec3 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng sang bi\u1ec3u \u0111\u1ed3 kh\u00e1c.<\/p>\n

Sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3 sang bi\u1ec3u \u0111\u1ed3 kh\u00e1c b\u1eb1ng VBA Code<\/strong><\/p>\n

\n

    \n
  1. Nh\u1ea5n gi\u1eef\u00a0Alt + F11<\/em><\/strong>, h\u1ed9p tho\u1ea1i\u00a0Microsoft Visual Basic for Applications<\/em><\/strong>\u00a0m\u1edf ra.<\/li>\n
  2. Nh\u1ea5p\u00a0Insert > Module<\/em><\/strong>, v\u00e0 d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o c\u1eeda s\u1ed5 Module.<\/li>\n<\/ol>\n
    View the code on Gist<\/a>.<\/div>\n
    <\/div>\n
    <\/div>\n
    <\/div>\n
    \n
      \n
    1. Nh\u1ea5n\u00a0F5<\/em><\/strong>\u00a0\u0111\u1ec3 ch\u1ea1y m\u00e3. T\u1ea5t c\u1ea3 bi\u1ec3u \u0111\u1ed3 kh\u00e1c trong trang t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng theo bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c ch\u1ecdn.<\/li>\n<\/ol>\n<\/div>\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":11782,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11781","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\/11781","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=11781"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11781\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11782"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}