{"id":3844,"date":"2024-12-03T08:16:44","date_gmt":"2024-12-03T08:16:44","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-tao-phim-tat-dem-so-luong-sheet-an-hien-trong-excel\/"},"modified":"2024-12-03T08:16:44","modified_gmt":"2024-12-03T08:16:44","slug":"huong-dan-tao-phim-tat-dem-so-luong-sheet-an-hien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/huong-dan-tao-phim-tat-dem-so-luong-sheet-an-hien-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet \u1ea9n, hi\u1ec7n trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Trong b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ebfm xem trong File Excel c\u1ee7a b\u1ea1n c\u00f3 bao nhi\u00eau Sheet \u0111ang hi\u1ec7n c\u00f3, s\u1ed1 Sheet \u0111ang \u1ea9n.<\/em><\/p>\n<p>C\u0169ng gi\u1ed1ng nh\u01b0 c\u00e1c b\u00e0i vi\u1ebft tr\u01b0\u1edbc c\u1ee7a <strong>H\u1ecdc Excel Online <\/strong>h\u01b0\u1edbng d\u1eabn d\u1eabn vi\u1ec7c t\u1ea1o c\u00e1c ph\u00edm t\u1eaft h\u1eefu \u00edch trong Excel. B\u1eb1ng vi\u1ec7c Record Macro \u0111\u1ec3 t\u1ea1o \u0111\u01b0\u1ee3c ph\u00edm t\u1eaft v\u00e0 sau \u0111\u00f3 s\u1eeda l\u1ea1i Code, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-phim-tat-trong-excel.html\"><em><strong>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<\/strong><\/em><\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-phim-tat-de-xoa-sheet-trong-excel.html\"><em><strong>H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u1ea9n, xo\u00e1 Sheet trong Excel<\/strong><\/em><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674ebe6c00090\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-phim-tat-dem-luong-sheet-hien-trong-excel.html#Tao_phim_tat_de_dem_so_luong_Sheet_hien_co_trong_Excel\" title=\"T\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet hi\u1ec7n c\u00f3 trong Excel\">T\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet hi\u1ec7n c\u00f3 trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-phim-tat-dem-luong-sheet-hien-trong-excel.html#Tao_phim_tat_de_dem_so_luong_Sheet_dang_an_trong_Excel\" title=\"T\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet \u0111ang \u1ea9n\u00a0trong Excel\">T\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet \u0111ang \u1ea9n\u00a0trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-phim-tat-dem-luong-sheet-hien-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tao_phim_tat_de_dem_so_luong_Sheet_hien_co_trong_Excel\"><\/span>T\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet hi\u1ec7n c\u00f3 trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi \u0111\u00e3 Record Macro, trong ph\u1ea7n\u00a0Shortcut key\u00a0b\u1ea1n gi\u1eef ph\u00edm Shift v\u00e0 g\u00f5 1 k\u00fd t\u1ef1 n\u00e0o \u0111\u00f3 \u0111\u1ec3 t\u1ea1o ph\u00edm t\u1eaft (ph\u00edm t\u1eaft \u0111\u00f3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c tr\u00f9ng v\u1edbi b\u1ea5t k\u1ef3 ph\u00edm t\u1eaft n\u00e0o hi\u1ec7n c\u00f3 trong h\u1ec7 th\u1ed1ng), \u1edf\u00a0m\u00ecnh g\u00f5 ph\u00edm t\u1eaft l\u00e0 <strong>Ctrl + Shift + M<\/strong><\/p>\n<p>D\u1eebng vi\u1ec7c Record Macro, sau \u0111\u00f3 ta s\u1ebd m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA l\u00ean v\u00e0 s\u1eeda l\u1ea1i \u0111o\u1ea1n Code th\u00e0nh nh\u01b0 sau:<\/p>\n<blockquote>\n<p>MsgBox \u201cTong so Sheets la: \u201d &amp; Sheets.Count<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30858 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-1-5.png\" alt=\"tao-phim-tat-trong-excel-1\" width=\"698\" height=\"371\" title=\"1-1-5\"><\/p>\n<\/blockquote>\n<p>Ch\u1ec9 c\u1ea7n nh\u01b0 v\u1eady th\u00f4i l\u00e0 b\u1ea1n \u0111\u00e3 l\u1ea1i c\u00f3 th\u00eam 1 ph\u00edm t\u1eaft \u0111\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c trong File Excel c\u1ee7a m\u00ecnh c\u00f3 bao nhi\u00eau Sheet r\u1ed3i, v\u00e0 ph\u00edm t\u1eaft l\u00e0 <strong>Ctrl + Shift + M<\/strong><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-130.gif\" title=\"vba101_92019-nho-130\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-303.gif\" title=\"ex101_92019-nho-303\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tao_phim_tat_de_dem_so_luong_Sheet_dang_an_trong_Excel\"><\/span>T\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet \u0111ang \u1ea9n\u00a0trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u0169ng v\u1edbi vi\u1ec7c Record Macro v\u00e0 ph\u1ea7n\u00a0Shortcut key \u1edf \u0111\u00e2y m\u00ecnh g\u00f5 l\u00e0 <strong>Ctrl + Shift + N<\/strong><\/p>\n<p>Ta\u00a0s\u1eeda l\u1ea1i Code nh\u01b0 sau \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet \u0111ang \u1ea9n trong File Excel.<\/p>\n<blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30919 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-4-1.png\" alt=\"tao-phim-tat-trong-excel-2\" width=\"617\" height=\"765\" title=\"2-4-1\"><\/p>\n<\/blockquote>\n<p><strong>B\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u \u0111o\u1ea1n Code tr\u00ean nh\u01b0 sau:<\/strong> Khai b\u00e1o 1 bi\u1ebfn Ws thu\u1ed9c \u0111\u1ed1i t\u01b0\u1ee3ng Worksheet, th\u1ef1c hi\u1ec7n l\u1eb7p qua t\u1ea5t c\u1ea3 c\u00e1c Sheet trong File Excel v\u00e0 ki\u1ec3m tra xem Sheet \u0111\u00f3 c\u00f3 \u0111ang \u1ea9n hay kh\u00f4ng (Ws.Visible = False).<\/p>\n<ul>\n<li>N\u1ebfu kh\u00f4ng c\u00f3 Sheet n\u00e0o \u1ea9n (t\u1ee9c j = 0) th\u00ec s\u1ebd th\u00f4ng b\u00e1o kh\u00f4ng c\u00f3 Sheet n\u00e0o \u1ea9n v\u1edbi Msgbox,<\/li>\n<li>N\u1ebfu \u0111ang \u1ea9n th\u00ec s\u1ebd t\u00ednh v\u00e0 cu\u1ed1i c\u00f9ng s\u1ebd hi\u1ec7n ra th\u00f4ng b\u00e1o s\u1ed1 Sheet \u0111ang \u1ea9n v\u1edbi Msgbox.<\/li>\n<\/ul>\n<p>N\u1ebfu b\u1ea1n t\u1ea1o ph\u00edm t\u1eaft gi\u1ed1ng m\u00ecnh th\u00ec c\u00f9ng \u1ea5n <strong>Ctrl + Shift\u00a0 + N<\/strong> \u0111\u1ec3 th\u1ef1c hi\u1ec7n \ud83d\ude0a<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 v\u1eady qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a<strong> H\u1ecdc Excel Online<\/strong> b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ea1o th\u00eam cho m\u00ecnh \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft n\u1eefa \u0111\u1ec3\u00a0b\u1ed5 sung v\u00e0o trong danh s\u00e1ch ph\u00edm t\u1eaft c\u1ee7a m\u00ecnh.<\/p>\n<ul>\n<li><strong>Ctrl + Shift + M<\/strong>: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet hi\u1ec7n c\u00f3 trong File<\/li>\n<li><strong>Ctrl + Shift + N<\/strong>: \u0110\u1ebfm s\u1ed1 l\u01b0\u1ee3ng Sheet \u0111ang \u1ea9n trong File<\/li>\n<\/ul>\n<p><span style=\"font-size: 14pt\">Tham c\u00e1c c\u00e1ch t\u1ea1o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c c\u00f9ng ch\u1ee7 \u0111\u1ec1 ngay d\u01b0\u1edbi \u0111\u00e2y:<\/span><\/p>\n<hr>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-phim-tat-de-xoa-sheet-trong-excel.html\">H\u01b0\u1edbng d\u1eabn t\u1ea1o ph\u00edm t\u1eaft \u0111\u1ec3 \u1ea9n, xo\u00e1 Sheet trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-phim-tat-trong-excel.html\">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<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/phim-tat-ngay-thang-trong-excel-hieu-qua-nhat.html\">T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c ph\u00edm t\u1eaft ng\u00e0y th\u00e1ng trong Excel nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/20-phim-tat-thuong-xuyen-duoc-su-dung-trong-word-ban-can-biet.html\">20 ph\u00edm t\u1eaft th\u01b0\u1eddng xuy\u00ean \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Word b\u1ea1n c\u1ea7n bi\u1ebft<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-phim-tat-de-thuc-hien-viec-xoa-du-lieu-trung-lap-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng ph\u00edm t\u1eaft \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c x\u00f3a d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p trong Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/nhung-phim-tat-word-than-thanh-cua-dan-ke-toan.html\">Nh\u1eefng ph\u00edm t\u1eaft Word th\u1ea7n th\u00e0nh c\u1ee7a d\u00e2n k\u1ebf to\u00e1n<\/a><\/strong><\/em><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-130.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3845,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3844","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\/3844","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=3844"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3845"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}