{"id":3701,"date":"2024-12-03T03:44:39","date_gmt":"2024-12-03T03:44:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-tao-phim-tat-de-an-hien-thanh-cong-thuc-trong-excel\/"},"modified":"2024-12-03T03:44:39","modified_gmt":"2024-12-03T03:44:39","slug":"huong-dan-tao-phim-tat-de-an-hien-thanh-cong-thuc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-tao-phim-tat-de-an-hien-thanh-cong-thuc-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u1ea9n, hi\u1ec7n thanh c\u00f4ng th\u1ee9c trong Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft trong Excel<\/strong><\/a>\u00a0hi\u1ec7n thanh c\u00f4ng th\u1ee9c trong Excel b\u1eb1ng vi\u1ec7c v\u1eadn d\u1ee5ng Record Macro trong Excel<\/em><\/p>\n

H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u1ea9n, hi\u1ec7n thanh c\u00f4ng th\u1ee9c trong Excel<\/h2>\n

N\u1ebfu nh\u01b0 b\u1ea1n ch\u01b0a r\u00f5 thanh c\u00f4ng th\u1ee9c trong Excel l\u00e0 g\u00ec th\u00ec n\u00f3 l\u00e0 \u1edf \u0111\u00e2y.<\/p>\n

\"tao-phim-tat-trong-excel-1\"<\/a><\/p>\n

B\u1eb1ng vi\u1ec7c Record Macro, trong \u0111\u00f3 c\u00f3 m\u1ed9t ph\u1ea7n \u0111\u1ec3 cho ng\u01b0\u1eddi d\u00f9ng t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 th\u1ef1c thi l\u1ec7nh Macro \u0111\u00f3. Ta s\u1ebd v\u1eadn d\u00f9ng \u0111i\u1ec1u \u0111\u00f3 \u0111\u1ec3 t\u1ea1o ph\u00edm t\u1eaft gi\u00fap ta th\u1ef1c hi\u1ec7n \u1ea9n ho\u1eb7c hi\u1ec7n thanh c\u00f4ng th\u1ee9c trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n

C\u1ee5 th\u1ec3 ta s\u1ebd c\u00f3 d\u00f2ng Code nh\u01b0 sau, b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n thao t\u00e1c Record Macro \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c d\u00f2ng Code \u1ea9n, hi\u1ec7n thanh c\u00f4ng th\u1ee9c\u00a0\u0111\u00f3.<\/p>\n

\"tao-phim-tat-trong-excel-2\"<\/a><\/p>\n

Khi th\u1ef1c hi\u1ec7n thao t\u00e1c Record Macro, t\u1ea1i ph\u1ea7n Shortcut key b\u1ea1n gi\u1eef ph\u00edm Shift<\/strong> v\u00e0 g\u00f5 ph\u00edm n\u00e0o \u0111\u00f3 \u0111\u1ec3 t\u1ea1o ph\u00edm t\u1eaft cho thao t\u00e1c n\u00e0y (\u1ede \u0111\u00e2y minh g\u00f5 Shift + Q)<\/p>\n

\n

H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u1ea9n, xo\u00e1 Sheet trong Excel<\/a><\/strong><\/em><\/p>\n<\/blockquote>\n

L\u01b0u \u00fd:<\/strong>\u00a0Ph\u00edm Ctrl + Shift + ph\u00edm b\u1ea1n g\u00f5 ph\u1ea3i kh\u00f4ng \u0111\u01b0\u1ee3c tr\u00f9ng v\u1edbi b\u1ea5t k\u1ef3 ph\u00edm t\u1eaft, ph\u00edm ch\u1ee9c n\u0103ng m\u1eb7c \u0111\u1ecbnh v\u00e0 hi\u1ec7n c\u00f3.<\/p>\n

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

\u0110o\u1ea1n Code tr\u00ean b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u nh\u01b0 sau: N\u1ebfu thanh c\u00f4ng th\u1ee9c \u0111ang kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb th\u00ec khi b\u1ea1n ch\u1ea1y Code \u0111\u00f3 (\u1ea5n ph\u00edm t\u1eaft Ctrl + Shift + Q nh\u01b0 \u0111\u00e3 l\u00e0m \u1edf thao t\u00e1c Record Macro<\/em>) th\u00ec thanh c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec7n ra. Ng\u01b0\u1ee3c l\u1ea1i, khi thanh c\u00f4ng th\u1ee9c \u0111ang hi\u1ec7n m\u00e0 b\u1ea1n \u1ea5n Ctrl + Shift + Q th\u00ec thanh c\u00f4ng th\u1ee9c s\u1ebd b\u1ecb \u1ea9n \u0111i.<\/p>\n

Ch\u1ec9 \u0111\u01a1n gi\u1ea3n nh\u01b0 v\u1eady th\u00f4i l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o cho m\u00ecnh \u0111\u01b0\u1ee3c ph\u00edm t\u1eaft \u1ea9n, hi\u1ec7n thanh c\u00f4ng th\u1ee9c trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng r\u1ed3i.<\/p>\n

H\u1ecdc Excel Online<\/a> <\/strong>ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng v\u00e0 \u0111\u01b0ng qu\u00ean \u0111\u0103ng k\u00ed tham gi\u00e1 kh\u00f3a h\u1ecdc Excel v\u0103n ph\u00f2ng<\/strong><\/a> c\u1ee7a ch\u00fang t\u00f4i nh\u00e9!<\/p>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft kh\u00e1c, c\u0169ng li\u00ean quan t\u1edbi ch\u1ee7 \u0111\u1ec1 t\u1ef1 t\u1ea1o ph\u00edm t\u1eaft cho ri\u00eang m\u00ecnh, b\u1ea1n\u00a0tham kh\u1ea3o th\u00eam \u0111\u1ec3 c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o cho m\u00ecnh \u0111\u01b0\u1ee3c nhi\u1ec1u ph\u00edm t\u1eaft h\u1eefu \u00edch h\u01a1n nh\u1eb1m ph\u1ee5c v\u1ee5\u00a0trong c\u00f4ng vi\u1ec7c \u0111\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n

\n

H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u1ea9n, xo\u00e1 Sheet trong Excel<\/a><\/strong><\/em><\/p>\n

H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 ch\u1ecdn Sheet \u0111\u1ea7u ti\u00ean, Sheet cu\u1ed1i c\u00f9ng trong Excel<\/a><\/strong><\/em><\/p>\n

H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng sheet \u1ea9n, hi\u1ec7n trong excel
<\/a><\/strong><\/em><\/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":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3702,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3701","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3701","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=3701"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3701\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3702"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}