{"id":11995,"date":"2025-01-15T06:28:49","date_gmt":"2025-01-15T06:28:49","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cong-thuc-excel-tu-nhay-khi-nhap-du-lieu-vao-dong-tiep-theo\/"},"modified":"2025-01-15T06:28:49","modified_gmt":"2025-01-15T06:28:49","slug":"cong-thuc-excel-tu-nhay-khi-nhap-du-lieu-vao-dong-tiep-theo","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cong-thuc-excel-tu-nhay-khi-nhap-du-lieu-vao-dong-tiep-theo\/","title":{"rendered":"C\u00f4ng th\u1ee9c Excel t\u1ef1 nh\u1ea3y khi nh\u1eadp d\u1eef li\u1ec7u v\u00e0o d\u00f2ng ti\u1ebfp theo"},"content":{"rendered":"
\n

H\u00f4m tr\u01b0\u1edbc c\u00f3 1 b\u1ea1n h\u1ecfi v\u1ec1 1 file Excel m\u00e0 khi \u0111i\u1ec1n d\u1eef li\u1ec7u v\u00e0o d\u00f2ng ti\u1ebfp theo th\u00ec c\u00f4ng th\u1ee9c t\u1ef1 nh\u1ea3y m\u00e0 file kh\u00f4ng h\u1ec1 c\u00f3 code VBA, kh\u00f4ng s\u1eed d\u1ee5ng b\u1ea3ng. C\u00e1ch l\u00e0m r\u1ea5t \u0111\u01a1n gi\u1ea3n, m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i \u1ea3nh GIF sau \u0111\u00e2y.<\/p>\n

\u0110\u1ea7u ti\u00ean ch\u00fang ta c\u1ea7n thi\u1ebft l\u1eadp Excel 1 ch\u00fat nh\u01b0 sau:
\nFile<\/code>>Options<\/code>>Advanced<\/code><\/p>\n

v\u00e0 check v\u00e0o h\u1ed9p ki\u1ec3m:<\/p>\n

Extend data range formats and formulas<\/strong><\/p>\n\n

Nh\u1eefng thao t\u00e1c n\u00e0y tuy kh\u00f4ng ph\u1ee9c t\u1ea1p v\u00e0 t\u1ed1n nhi\u1ec1u th\u1eddi gian nh\u01b0ng s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c c\u00f4ng vi\u1ec7c l\u1edbn n\u1ebfu b\u1ea1n bi\u1ebft t\u1eadn d\u1ee5ng tri\u1ec7t \u0111\u1ec3 c\u00e1c ch\u1ee9c n\u0103ng. \u0110\u1ec3 gi\u00fap b\u1ea1n l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, Ho\u0323c Excel Online<\/a> \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/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":"

H\u00f4m tr\u01b0\u1edbc c\u00f3 1 b\u1ea1n h\u1ecfi v\u1ec1 1 file Excel m\u00e0 khi \u0111i\u1ec1n d\u1eef li\u1ec7u..<\/p>\n","protected":false},"author":1,"featured_media":11996,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11995","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\/11995","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=11995"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11995\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11996"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}