{"id":9588,"date":"2025-01-02T10:43:47","date_gmt":"2025-01-02T10:43:47","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-an-hoac-hien-thanh-chua-danh-sach-cac-trang-tinh-trong-excel\/"},"modified":"2025-01-02T10:43:47","modified_gmt":"2025-01-02T10:43:47","slug":"huong-dan-an-hoac-hien-thanh-chua-danh-sach-cac-trang-tinh-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-an-hoac-hien-thanh-chua-danh-sach-cac-trang-tinh-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn \u1ea9n ho\u1eb7c hi\u1ec7n thanh ch\u1ee9a danh s\u00e1ch c\u00e1c trang t\u00ednh trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n ho\u1eb7c hi\u1ec7n c\u00e1c trang t\u00ednh trong Excel? Li\u1ec7u b\u1ea1n \u0111\u00e3 bi\u1ebft c\u00e1ch \u1ea9n ho\u1eb7c hi\u1ec7n thanh ch\u1ee9a danh s\u00e1ch c\u00e1c trang t\u00ednh? Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3.<\/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-67766de288918\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/an-hoac-hien-thanh-chua-danh-sach-cac-trang-tinh.html#An_hoac_hien_trang_tinh_trong_Excel\" title=\"\u1ea8n ho\u1eb7c hi\u1ec7n trang t\u00ednh trong Excel\">\u1ea8n ho\u1eb7c hi\u1ec7n trang t\u00ednh trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/an-hoac-hien-thanh-chua-danh-sach-cac-trang-tinh.html#An_hoac_hien_thanh_chua_danh_sach_cac_trang_tinh_voi_1_click\" title=\"\u1ea8n ho\u1eb7c hi\u1ec7n thanh ch\u1ee9a danh s\u00e1ch c\u00e1c trang t\u00ednh v\u1edbi 1 click\">\u1ea8n ho\u1eb7c hi\u1ec7n thanh ch\u1ee9a danh s\u00e1ch c\u00e1c trang t\u00ednh v\u1edbi 1 click<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"An_hoac_hien_trang_tinh_trong_Excel\"><\/span>\u1ea8n ho\u1eb7c hi\u1ec7n trang t\u00ednh trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc khi \u0111i v\u00e0o ch\u1ee7 \u0111\u1ec1 ch\u00ednh, ta h\u00e3y \u00f4n l\u1ea1i m\u1ed9t ch\u00fat. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n c\u00e1c trang t\u00ednh trong Excel?<\/p>\n<p><strong>C\u00e1ch 1:<\/strong><\/p>\n<p>1. T\u1ea1i thanh ch\u1ee9a danh s\u00e1ch c\u00e1c trang t\u00ednh, ta click chu\u1ed9t ph\u1ea3i v\u00e0o trang t\u00ednh mu\u1ed1n \u1ea9n v\u00e0 ch\u1ecdn\u00a0<strong>Hide.\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23934\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/an-hien-sheet-bar-1.png\" width=\"223\" height=\"299\" title=\"an-hien-sheet-bar-1\"><\/p>\n<p>2. \u0110\u1ec3 hi\u1ec7n l\u1ea1i trang t\u00ednh \u0111\u00e3 \u1ea9n, ch\u1ecdn\u00a0<strong>Unhide.\u00a0<\/strong>Trong \u0111\u00f3 ch\u1ecdn trang t\u00ednh mu\u1ed1n hi\u1ec7n v\u00e0 \u1ea5n OK.<\/p>\n<p><strong>C\u00e1ch 2:<\/strong><\/p>\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\/2025\/01\/ex101_92019-nho-69.gif\" title=\"ex101_92019-nho-69\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong th\u1ebb\u00a0<strong>Home<\/strong>, nh\u00f3m\u00a0<strong>Cells<\/strong>, ch\u1ecdn\u00a0<strong>Format<\/strong>,\u00a0<strong>Hide &amp; Unhide<\/strong> sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Hide Sheet\/Unhide sheet\u2026<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-23935\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/an-hien-sheet-bar-2.png\" width=\"418\" height=\"467\" title=\"an-hien-sheet-bar-2\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"An_hoac_hien_thanh_chua_danh_sach_cac_trang_tinh_voi_1_click\"><\/span>\u1ea8n ho\u1eb7c hi\u1ec7n thanh ch\u1ee9a danh s\u00e1ch c\u00e1c trang t\u00ednh v\u1edbi 1 click<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<figure id=\"attachment_23936\" aria-describedby=\"caption-attachment-23936\" style=\"width: 469px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23936 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/an-hien-sheet-bar-3.png\" width=\"469\" height=\"703\" title=\"an-hien-sheet-bar-3\"><figcaption id=\"caption-attachment-23936\" class=\"wp-caption-text\">Nh\u01b0 th\u1ebf n\u00e0y<\/figcaption><\/figure>\n<p>\u0110\u1ec3 \u1ea9n thanh ch\u1ee9a danh s\u00e1ch c\u00e1c trang t\u00ednh ta l\u00e0m nh\u01b0 sau:<\/p>\n<p><strong>1:\u00a0<\/strong>T\u1ea1i th\u1ebb\u00a0<strong>File<\/strong>, ch\u1ecdn\u00a0<strong>Options.<\/strong><\/p>\n<p><strong>2:\u00a0<\/strong>Trong h\u1ed9p tho\u1ea1i\u00a0<strong>Excel Options<\/strong>, ch\u1ecdn\u00a0<strong>Advanced.<\/strong><\/p>\n<p><strong>3:\u00a0<\/strong>K\u00e9o chu\u1ed9t xu\u1ed1ng t\u1edbi ph\u1ea7n\u00a0<em>Display options for this workbook.<\/em><\/p>\n<p><strong>4:\u00a0<\/strong>B\u1ecf ch\u1ecdn m\u1ee5c\u00a0<strong>Show sheet tabs.<\/strong><\/p>\n<p>\u00a0<\/p>\n<p>Sau khi th\u1ef1c hi\u1ec7n thao t\u00e1c n\u00e0y, to\u00e0n b\u1ed9 c\u00e1c th\u1ebb trang t\u00ednh tr\u00ean thanh \u0111\u00e3 b\u1ecb \u1ea9n \u0111i. \u0110\u1ec3 hi\u1ec7n l\u1ea1i ta th\u1ef1c hi\u1ec7n l\u1ea1i c\u00e1c thao t\u00e1c tr\u00ean v\u00e0 ch\u1ecdn l\u1ea1i\u00a0<strong>Show sheet tabs.<\/strong><\/p>\n<p>Ngo\u00e0i thao t\u00e1c \u1ea9n\/hi\u1ec7n tr\u00ean, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem c\u00e1c thao t\u00e1c kh\u00e1c t\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-trang-tinh-mos-excel.html\">b\u00e0i vi\u1ebft n\u00e0y<\/a>. V\u00e0 \u0111\u1eebng qu\u00ean theo d\u00f5i nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo c\u1ee7a H\u1ecdc Excel Online nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/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\/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\/2025\/01\/ex101_92019-nho-69.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9589,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9588","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\/9588","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=9588"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9588\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9589"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}