{"id":17620,"date":"2023-09-12T08:25:41","date_gmt":"2023-09-12T01:25:41","guid":{"rendered":"\/amis-mua-hang\/?post_type=ht_kb&p=17620"},"modified":"2024-01-08T11:20:18","modified_gmt":"2024-01-08T04:20:18","slug":"copy-du-lieu-tu-excel-vao-chung-tu","status":"publish","type":"ht_kb","link":"\/amis-mua-hang\/kb\/copy-du-lieu-tu-excel-vao-chung-tu\/","title":{"rendered":"Copy d\u1eef li\u1ec7u t\u1eeb excel v\u00e0o ch\u1ee9ng t\u1eeb"},"content":{"rendered":"
1. N\u1ed9i dung<\/strong><\/span><\/h6>\n

Cho ph\u00e9p copy tr\u1ef1c ti\u1ebfp t\u1eebng c\u1ed9t d\u1eef li\u1ec7u tr\u00ean Excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u, gi\u00fap nh\u1eadp li\u1ec7u nhanh ch\u00f3ng m\u00e0 kh\u00f4ng ph\u1ea3i t\u1ea1o file nh\u1eadp kh\u1ea9u t\u1eeb Excel.<\/p>\n

Ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e1p \u1ee9ng copy d\u1eef li\u1ec7u t\u1eeb excel tr\u00ean ch\u1ee9ng t\u1eeb \u0110\u1ec1 ngh\u1ecb duy\u1ec7t b\u00e1o gi\u00e1<\/a>, Th\u1ecfa thu\u1eadn mua h\u00e0ng<\/a>, K\u1ebf ho\u1ea1ch mua h\u00e0ng, <\/a>Y\u00eau c\u1ea7u mua s\u1eafm<\/a>.<\/strong><\/p>\n

2. H\u01b0\u1edbng d\u1eabn<\/strong><\/span><\/h6>\n

V\u00ed d\u1ee5 tr\u00ean ch\u1ee9ng t\u1eeb l\u1eadp \u0110\u1ec1 ngh\u1ecb duy\u1ec7t b\u00e1o gi\u00e1<\/strong>, ch\u1ee9c n\u0103ng copy d\u1eef li\u1ec7u t\u1eeb excel \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n

    \n
  • Tr\u00ean file excel<\/strong>: Copy c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n nh\u1eadp li\u1ec7u.<\/li>\n<\/ul>\n

    \"\"<\/p>\n

      \n
    • Tr\u00ean ph\u1ea7n m\u1ec1m<\/strong>: Tr\u1ecf chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed c\u1ed9t c\u1ea7n paste d\u1eef li\u1ec7u => Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl + V <\/strong>\u0111\u1ec3 sao ch\u00e9p c\u1ed9t d\u1eef li\u1ec7u t\u1eeb excel v\u00e0o ch\u1ee9ng t\u1eeb.<\/li>\n<\/ul>\n

      \"\"<\/p>\n

      L\u01b0u \u00fd:<\/strong><\/em><\/p>\n

        \n
      • Ch\u1ec9 c\u00f3 th\u1ec3 copy \u0111\u01b0\u1ee3c t\u1eebng c\u1ed9t, kh\u00f4ng th\u1ec3 copy nhi\u1ec1u c\u1ed9t c\u00f9ng l\u00fac. C\u00e1c c\u1ed9t c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng copy t\u1eeb excel bao g\u1ed3m:\u00a0M\u00e3 h\u00e0ng; T\u00ean h\u00e0ng; \u0110\u01a1n v\u1ecb t\u00ednh; \u0110\u01a1n gi\u00e1; S\u1ed1 l\u01b0\u1ee3ng; Th\u00e0nh ti\u1ec1n, Ti\u1ec1n chi\u1ebft kh\u1ea5u; T\u1ef7 l\u1ec7 chi\u1ebft kh\u1ea5u; % thu\u1ebf GTGT; Ti\u1ec1n thu\u1ebf; Tr\u01b0\u1eddng m\u1edf r\u1ed9ng chi ti\u1ebft.<\/strong><\/em><\/li>\n
      • Sau khi copy c\u1ed9t\u00a0M\u00e3 h\u00e0ng\u00a0<\/strong>ho\u1eb7c c\u1ed9t\u00a0T\u00ean h\u00e0ng<\/strong>, n\u1ebfu tr\u00f9ng v\u1edbi m\u1eb7t h\u00e0ng \u0111\u00e3 c\u00f3 trong danh m\u1ee5c, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd t\u1ef1 \u0111\u1ed9ng nh\u1eadn di\u1ec7n v\u00e0 \u0111i\u1ec1n c\u00e1c th\u00f4ng tin c\u00f2n l\u1ea1i nh\u01b0 T\u00ean h\u00e0ng\/M\u00e3 h\u00e0ng\/\u0110VT\/\u0110\u01a1n gi\u00e1\u2026<\/em><\/li>\n
      • N\u1ebfu\u00a0M\u00e3 h\u00e0ng\/T\u00ean h\u00e0ng\u00a0<\/strong>ch\u01b0a c\u00f3 trong danh m\u1ee5c, K\u1ebf to\u00e1n ph\u1ea3i t\u1ef1 ch\u1ecdn l\u1ea1i m\u00e3 h\u00e0ng \u0111\u00e3 c\u00f3 ho\u1eb7c t\u1ea1o m\u1edbi m\u00e3 h\u00e0ng.<\/em><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        1. N\u1ed9i dung Cho ph\u00e9p copy tr\u1ef1c ti\u1ebfp t\u1eebng c\u1ed9t d\u1eef li\u1ec7u tr\u00ean Excel \u0111\u1ec3 d\u00e1n v\u00e0o giao di\u1ec7n nh\u1eadp li\u1ec7u, gi\u00fap nh\u1eadp li\u1ec7u nhanh ch\u00f3ng m\u00e0 kh\u00f4ng ph\u1ea3i t\u1ea1o file nh\u1eadp kh\u1ea9u t\u1eeb Excel. Ch\u01b0\u01a1ng tr\u00ecnh \u0111\u00e1p \u1ee9ng copy d\u1eef li\u1ec7u t\u1eeb excel tr\u00ean ch\u1ee9ng t\u1eeb \u0110\u1ec1 ngh\u1ecb duy\u1ec7t…<\/p>\n","protected":false},"author":109,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[210],"ht-kb-tag":[],"class_list":["post-17620","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-khac-7-khac"],"_links":{"self":[{"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/ht-kb\/17620","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/users\/109"}],"replies":[{"embeddable":true,"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/comments?post=17620"}],"version-history":[{"count":4,"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/ht-kb\/17620\/revisions"}],"predecessor-version":[{"id":18322,"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/ht-kb\/17620\/revisions\/18322"}],"wp:attachment":[{"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/media?parent=17620"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/ht-kb-category?post=17620"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/amis-mua-hang\/wp-json\/wp\/v2\/ht-kb-tag?post=17620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}