{"id":2342,"date":"2024-12-02T07:31:10","date_gmt":"2024-12-02T07:31:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do\/"},"modified":"2024-12-02T07:31:10","modified_gmt":"2024-12-02T07:31:10","slug":"cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do\/","title":{"rendered":"C\u00c1CH D\u00d9NG C\u00d4NG C\u1ee4 SLICER CHO PIVOT TABLE V\u00c0 BI\u1ec2U \u0110\u1ed2"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em><span style=\"font-weight: 400\">B\u00e0i vi\u1ebft n\u00e0y, <strong>H\u1ecdc Excel Online<\/strong> h\u01b0\u1edbng d\u1eabn v\u1ec1 <strong>c\u00e1ch d\u00f9ng<\/strong> <a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-slicer-cong-cu-giup-loc-dong-thoi-nhieu-bao-cao-pivot-table.html\"><strong>c\u00f4ng c\u1ee5 slicer<\/strong><\/a>, c\u00e1c t\u00ednh n\u0103ng c\u00f4ng c\u1ee5 Sliver cho Pivot Table v\u00e0 bi\u1ec3u \u0111\u1ed3 t\u1ed5ng h\u1ee3p trong Excel 2010, 2013, 2016 v\u00e0 2019. Ch\u00fang ta s\u1ebd kh\u00e1m ph\u00e1 c\u00e1c c\u00e1ch s\u1eed d\u1ee5ng n\u00e2ng cao h\u01a1n nh\u01b0 t\u1ea1o ki\u1ec3u slicer t\u00f9y ch\u1ec9nh, k\u1ebft n\u1ed1i m\u1ed9t slicer v\u1edbi nhi\u1ec1u Pivot Table,\u2026<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\"><a href=\"http:\/\/blog.ezworkapp.com\/khoi-dau-voi-pivot-table-trong-excel.html\"><strong>Pivot Table trong Excel<\/strong><\/a> l\u00e0 m\u1ed9t c\u00e1ch m\u1ea1nh m\u1ebd \u0111\u1ec3 t\u00f3m t\u1eaft l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u v\u00e0 t\u1ea1o b\u00e1o c\u00e1o t\u00f3m t\u1eaft. \u0110\u1ec3 l\u00e0m cho b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n th\u00e2n thi\u1ec7n v\u1edbi ng\u01b0\u1eddi d\u00f9ng v\u00e0 t\u01b0\u01a1ng t\u00e1c h\u01a1n, h\u00e3y th\u00eam c\u00e1c b\u1ed9 l\u1ecdc. \u0110\u01b0a b\u1ea3ng t\u1ed5ng h\u1ee3p c\u1ee7a b\u1ea1n v\u1edbi Slicer cho \u0111\u1ed3ng nghi\u1ec7p v\u00e0 h\u1ecd s\u1ebd kh\u00f4ng l\u00e0m phi\u1ec1n b\u1ea1n m\u1ed7i khi h\u1ecd mu\u1ed1n d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ecdc theo c\u00e1ch kh\u00e1c nhau.<\/span><\/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-674d623d7e849\" 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\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Excel_Slicer_la_gi\" title=\"Excel Slicer l\u00e0 g\u00ec?\">Excel Slicer l\u00e0 g\u00ec?<\/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\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Bo_loc_Excel_Slicer_va_bo_loc_PivotTable\" title=\"B\u1ed9 l\u1ecdc Excel Slicer v\u00e0 b\u1ed9 l\u1ecdc PivotTable\">B\u1ed9 l\u1ecdc Excel Slicer v\u00e0 b\u1ed9 l\u1ecdc PivotTable<\/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\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_de_chen_bo_loc_Slicers_trong_Excel\" title=\"C\u00e1ch \u0111\u1ec3 ch\u00e8n b\u1ed9 l\u1ecdc Slicers trong Excel\">C\u00e1ch \u0111\u1ec3 ch\u00e8n b\u1ed9 l\u1ecdc Slicers trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_them_Slicer_cho_PivotTable_trong_Excel\" title=\"C\u00e1ch th\u00eam Slicer cho PivotTable trong Excel\">C\u00e1ch th\u00eam Slicer cho PivotTable trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_tao_Slicers_trong_bang_Excel\" title=\"C\u00e1ch t\u1ea1o Slicers trong b\u1ea3ng Excel\u00a0\">C\u00e1ch t\u1ea1o Slicers trong b\u1ea3ng Excel\u00a0<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_de_chen_Slicer_cho_PivotChart\" title=\"C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart\">C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_su_dung_cong_cu_Slicer_trong_Excel\" title=\"C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Slicer trong Excel\">C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Slicer trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Slicer_lam_bo_loc_PivotTable\" title=\"Slicer l\u00e0m b\u1ed9 l\u1ecdc PivotTable\">Slicer l\u00e0m b\u1ed9 l\u1ecdc PivotTable<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_chon_nhieu_muc_trong_Slicer\" title=\"C\u00e1ch ch\u1ecdn nhi\u1ec1u m\u1ee5c trong Slicer\">C\u00e1ch ch\u1ecdn nhi\u1ec1u m\u1ee5c trong Slicer<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Di_chuyen_Slicer_trong_Excel\" title=\"Di chuy\u1ec3n Slicer trong Excel\">Di chuy\u1ec3n Slicer trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Thay_doi_kich_thuoc_Slicer\" title=\"Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc Slicer\">Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc Slicer<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Ngat_lien_ket_Slicer_khoi_PivotTable\" title=\"Ng\u1eaft li\u00ean k\u1ebft Slicer kh\u1ecfi PivotTable\">Ng\u1eaft li\u00ean k\u1ebft Slicer kh\u1ecfi PivotTable<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_de_loai_vo_Slicer_trong_Excel\" title=\"C\u00e1ch \u0111\u1ec3 lo\u1ea1i v\u1ecf Slicer trong Excel\">C\u00e1ch \u0111\u1ec3 lo\u1ea1i v\u1ecf Slicer trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_tuy_chinh_Slicer_trong_Excel\" title=\"C\u00e1ch t\u00f9y ch\u1ec9nh Slicer trong Excel\u00a0\">C\u00e1ch t\u00f9y ch\u1ec9nh Slicer trong Excel\u00a0<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Thay_doi_kieu_Slicer\" title=\"Thay \u0111\u1ed5i ki\u1ec3u Slicer\">Thay \u0111\u1ed5i ki\u1ec3u Slicer<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Tao_kieu_Slicer_tuy_chinh_trong_Excel\" title=\"T\u1ea1o ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh trong Excel\">T\u1ea1o ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Nhieu_cot_trong_Excel_Slicer\" title=\"Nhi\u1ec1u c\u1ed9t trong Excel Slicer\">Nhi\u1ec1u c\u1ed9t trong Excel Slicer<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Thay_doi_cai_dat_Slicer\" title=\"Thay \u0111\u1ed5i c\u00e0i \u0111\u1eb7t Slicer\">Thay \u0111\u1ed5i c\u00e0i \u0111\u1eb7t Slicer<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_de_ket_noi_Slicer_voi_nhieu_PivotTable\" title=\"C\u00e1ch \u0111\u1ec3 k\u1ebft n\u1ed1i Slicer v\u1edbi nhi\u1ec1u PivotTable\">C\u00e1ch \u0111\u1ec3 k\u1ebft n\u1ed1i Slicer v\u1edbi nhi\u1ec1u PivotTable<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/blog.hocexcel.online\/cach-dung-cong-cu-slicer-cho-pivot-table-va-bieu-do.html#Cach_de_mo_khoa_mot_trang_tinh_duoc_bao_ve\" title=\"C\u00e1ch \u0111\u1ec3 m\u1edf kh\u00f3a m\u1ed9t trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7\">C\u00e1ch \u0111\u1ec3 m\u1edf kh\u00f3a m\u1ed9t trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Slicer_la_gi\"><\/span><b>Excel Slicer l\u00e0 g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\"><strong>Slicer trong Excel<\/strong> l\u00e0 b\u1ed9 l\u1ecdc \u0111\u1ed3 h\u1ecda cho b\u1ea3ng, <strong>Pivot Table<\/strong> v\u00e0 bi\u1ec3u \u0111\u1ed3 t\u1ed5ng h\u1ee3p. Do ch\u1ea5t l\u01b0\u1ee3ng h\u00ecnh \u1ea3nh c\u1ee7a ch\u00fang, slicer \u0111\u1eb7c bi\u1ec7t ph\u00f9 h\u1ee3p v\u1edbi trang t\u1ed5ng quan v\u00e0 b\u00e1o c\u00e1o t\u00f3m t\u1eaft, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u00fang \u1edf m\u1ecdi n\u01a1i \u0111\u1ec3 gi\u00fap l\u1ecdc d\u1eef li\u1ec7u nhanh h\u01a1n v\u00e0 d\u1ec5 d\u00e0ng h\u01a1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Slicer c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng trong Excel 2010 v\u00e0 c\u00f3 s\u1eb5n trong Excel 2013, Excel 2016, Excel 2019 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n m\u1edbi h\u01a1n.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u00e2y l\u00e0 c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u PivotTable b\u1eb1ng c\u00e1ch ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u n\u00fat trong h\u1ed9p slicer:<\/span><\/p>\n<figure style=\"width: 463px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Excel Slicer l\u00e0 g\u00ec?\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-slicer.png\" alt=\"Excel Slicer l\u00e0 g\u00ec?\" width=\"463\" height=\"161\"><figcaption class=\"wp-caption-text\">Excel Slicer l\u00e0 g\u00ec?<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Bo_loc_Excel_Slicer_va_bo_loc_PivotTable\"><\/span><b>B\u1ed9 l\u1ecdc Excel Slicer v\u00e0 b\u1ed9 l\u1ecdc PivotTable<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">V\u1ec1 c\u01a1 b\u1ea3n, b\u1ed9 l\u1ecdc Slicers v\u00e0 PivotTable c\u00f3 ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 \u2013 hi\u1ec3n th\u1ecb m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u v\u00e0 \u1ea9n d\u1eef li\u1ec7u kh\u00e1c. M\u1ed7i ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec1u c\u00f3 \u0111i\u1ec3m m\u1ea1nh v\u00e0 \u0111i\u1ec3m y\u1ebfu:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ed9 l\u1ecdc PivotTable h\u01a1i kh\u00f4ng \u0111\u01b0\u1ee3c ch\u00ednh x\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">V\u1edbi Slicers, vi\u1ec7c l\u1ecdc PivotTable\u00a0 l\u00e0 \u0111\u01a1n gi\u1ea3n ch\u1ec9 b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o m\u1ed9t n\u00fat.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00e1c b\u1ed9 l\u1ecdc \u0111\u01b0\u1ee3c g\u1eafn v\u1edbi m\u1ed9t b\u1ea3ng t\u1ed5ng h\u1ee3p, c\u00e1c b\u1ed9 l\u1ecdc c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i PivotTable v\u00e0 bi\u1ec3u \u0111\u1ed3 t\u1ed5ng h\u1ee3p.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ed9 l\u1ecdc kh\u00f3a v\u1edbi c\u00e1c c\u1ed9t v\u00e0 h\u00e0ng. Slicers l\u00e0 c\u00f4ng c\u1ee5 linh ho\u1ea1t v\u00e0 c\u00f3 th\u1ec3 di chuy\u1ec3n b\u1ea5t c\u1ee9 \u0111\u00e2u. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t m\u1ed9t Slicers b\u00ean c\u1ea1nh bi\u1ec3u \u0111\u1ed3 tr\u1ee5c c\u1ee7a m\u00ecnh ho\u1eb7c th\u1eadm ch\u00ed trong khu v\u1ef1c bi\u1ec3u \u0111\u1ed3 v\u00e0 c\u1eadp nh\u1eadt n\u1ed9i dung bi\u1ec3u \u0111\u1ed3 trong th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh ch\u1ec9 b\u1eb1ng m\u1ed9t c\u00fa nh\u1ea5p v\u00e0o n\u00fat.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ed9 l\u1ecdc PivotTable c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng t\u1ed1t tr\u00ean m\u00e0n h\u00ecnh c\u1ea3m \u1ee9ng. Slicers ho\u1ea1t \u0111\u1ed9ng tuy\u1ec7t v\u1eddi trong nhi\u1ec1u m\u00f4i tr\u01b0\u1eddng m\u00e0n h\u00ecnh c\u1ea3m \u1ee9ng, ngo\u1ea1i tr\u1eeb Excel Mobile (Bao g\u1ed3m Android v\u00e0 iOS), n\u01a1i t\u00ednh n\u0103ng n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ed9 l\u1ecdc PivotTable c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng h\u00f3a d\u1ec5 d\u00e0ng v\u1edbi VBA. T\u1ef1 \u0111\u1ed9ng h\u00f3a Slicers c\u1ea7n nhi\u1ec1u k\u1ef9 n\u0103ng v\u00e0 n\u1ed7 l\u1ef1c h\u01a1n m\u1ed9t ch\u00fat.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_de_chen_bo_loc_Slicers_trong_Excel\"><\/span><b>C\u00e1ch \u0111\u1ec3 ch\u00e8n b\u1ed9 l\u1ecdc Slicers trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 b\u1eaft \u0111\u1ea7u v\u1edbi Slicers, vui l\u00f2ng l\u00e0m theo c\u00e1c h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y cho bi\u1ebft c\u00e1ch th\u00eam Slicers cho b\u1ea3ng Excel, PivotTable ho\u1eb7c PivotChart c\u1ee7a b\u1ea1n.<\/span><\/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-77.gif\" title=\"vba101_92019-nho-77\"><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-181.gif\" title=\"ex101_92019-nho-181\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_them_Slicer_cho_PivotTable_trong_Excel\"><\/span><b>C\u00e1ch th\u00eam Slicer cho PivotTable trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">T\u1ea1o m\u1ed9t Slicers trong Excel ch\u1ec9 m\u1ea5t v\u00e0i gi\u00e2y. \u0110\u00e2y l\u00e0 nh\u1eefng g\u00ec b\u1ea1n n\u00ean l\u00e0m:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u0111\u00e2u trong PivotTable.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong Excel 2013, Excel 2016 v\u00e0 Excel 2019, h\u00e3y chuy\u1ec3n \u0111\u1ebfn tab Analyze<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Filter Group v\u00e0 nh\u1ea5p v\u00e0o Insert Slicer trong Excel 2010, chuy\u1ec3n sang Option Tab v\u00e0 nh\u1ea5p Insert Slicer.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">H\u1ed9p tho\u1ea1i Insert Slicer s\u1ebd b\u1eadt l\u00ean v\u00e0 hi\u1ec3n th\u1ecb c\u00e1c h\u1ed9p ki\u1ec3m tra cho t\u1eebng tr\u01b0\u1eddng PivotTable. Ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u tr\u01b0\u1eddng m\u00e0 b\u1ea1n mu\u1ed1n Slicers. B\u1ea5m OK.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: H\u00e3y th\u00eam hai Slicers \u0111\u1ec3 l\u1ecdc b\u1ea3ng PivotTable theo Product v\u00e0 Reseller:<\/span><\/p>\n<figure style=\"width: 439px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch th\u00eam Slicer cho PivotTable trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-slicer-excel-pivottable.png\" alt=\"Insert a pivot table slicer in Excel.\" width=\"439\" height=\"463\"><figcaption class=\"wp-caption-text\">C\u00e1ch th\u00eam Slicer cho PivotTable trong Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Hai PivotTable Slicers \u0111\u01b0\u1ee3c t\u1ea1o ngay l\u1eadp t\u1ee9c:<\/span><\/p>\n<figure style=\"width: 408px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u00e0i t\u1eadp v\u00ed d\u1ee5 c\u00e1ch th\u00eam Slicer cho PivotTable trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pivot-table-slicer-excel.png\" alt=\"Pivot table slicers in Excel\" width=\"408\" height=\"325\"><figcaption class=\"wp-caption-text\">B\u00e0i t\u1eadp v\u00ed d\u1ee5 c\u00e1ch th\u00eam Slicer cho PivotTable trong Excel<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tao_Slicers_trong_bang_Excel\"><\/span><b>C\u00e1ch t\u1ea1o Slicers trong b\u1ea3ng Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i PivotTable, c\u00e1c phi\u00ean b\u1ea3n Excel hi\u1ec7n \u0111\u1ea1i c\u0169ng cho ph\u00e9p b\u1ea1n ch\u00e8n m\u1ed9t Slicers cho m\u1ed9t b\u1ea3ng Excel th\u00f4ng th\u01b0\u1eddng. \u0110\u00e2y l\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u0111\u00e2u trong b\u1ea3ng c\u1ee7a b\u1ea1n.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tr\u00ean tab Insert, trong Filter Group, nh\u1ea5p Slicer.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong h\u1ed9p tho\u1ea1i Insert Slicers, \u0111\u00e1nh d\u1ea5u v\u00e0o \u00f4 ki\u1ec3m cho m\u1ed9t ho\u1eb7c nhi\u1ec1u c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n l\u1ecdc.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea5m OK.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">M\u1ed9t Slicer \u0111\u01b0\u1ee3c t\u1ea1o v\u00e0 b\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u b\u1ea3ng c\u1ee7a m\u00ecnh:<\/span><\/p>\n<figure style=\"width: 494px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-slicer-excel-table.png\" alt=\"A slicer for an Excel table\" width=\"494\" height=\"400\"><figcaption class=\"wp-caption-text\">C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_de_chen_Slicer_cho_PivotChart\"><\/span><b>C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f3 th\u1ec3 l\u1ecdc PivotChart v\u1edbi Slicer, b\u1ea1n c\u00f3 th\u1ec3 th\u1eadt s\u1ef1 l\u00e0m Slicer cho PivotTable c\u1ee7a b\u1ea1n gi\u1ed1ng nh\u01b0 gi\u1ea3i th\u00edch b\u00ean tr\u00ean v\u00e0 n\u00f3 s\u1ebd \u0111i\u1ec1u ch\u1ec9nh PivotTable v\u00e0 PivotChart.<\/span><\/p>\n<figure style=\"width: 573px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-pivot-chart-slicer.png\" alt=\"Pivot chart slicer in Excel\" width=\"573\" height=\"269\"><figcaption class=\"wp-caption-text\">C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 t\u00edch h\u1ee3p Slicer v\u1edbi PivotChart c\u1ee7a b\u1ea1n ch\u1eb7t ch\u1ebd h\u01a1n nh\u01b0 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong h\u00ecnh b\u00ean tr\u00ean, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 PivotChart c\u1ee7a b\u1ea1n<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tr\u00ean Tab Analyze, t\u1ecfng Filter Group, b\u1ea5m Insert Slicer.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn c\u00e1c h\u1ed9 ki\u1ec3m tra cho Slicers m\u00e0 b\u1ea1n mu\u1ed1n t\u1ea1o v\u00e0 b\u1ea5m OK.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">Thao t\u00e1c n\u00e0y s\u1ebd ch\u00e8n h\u1ed9 b\u1ed9 Slicer \u0111\u00e3 quen thu\u1ed9c v\u00e0o trang t\u00ednh c\u1ee7a b\u1ea1n:<\/span><\/p>\n<figure style=\"width: 549px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00ecnh 1: C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/create-excel-chart-slicer.png\" alt=\"Inserting a slicer for a pivot able chart in Excel\" width=\"549\" height=\"497\"><figcaption class=\"wp-caption-text\">H\u00ecnh 1: C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Ngay khi b\u1ea1n t\u1ea1o Slicer, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00ean PivotChart ngay l\u1eadp t\u1ee9c. Ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n m\u1ed9t v\u00e0i c\u1ea3i ti\u1ebfn, ch\u1eb3ng h\u1ea1n nh\u01b0 \u1ea9n c\u00e1c n\u00fat b\u1ed9 l\u1ecdc tr\u00ean bi\u1ec3u \u0111\u1ed3, nh\u1eefng n\u00fai n\u00e0y \u0111\u00e3 tr\u1edf th\u00e0nh th\u1eeba v\u00ec b\u1ea1n s\u1ebd s\u1eed d\u1ee5ng b\u1ed9 c\u1eaft \u0111\u1ec3 l\u1ecdc.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Theo t\u00f9y ch\u1ecdn, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t Slicer trong v\u00f9ng bi\u1ec3u \u0111\u1ed3. \u0110\u1ed1i v\u1edbi \u0111i\u1ec1u n\u00e0y, h\u00e3y l\u00e0m cho khu v\u1ef1c bi\u1ec3u \u0111\u1ed3 l\u1edbn h\u01a1n (\u0111\u01a1n gi\u1ea3n b\u1eb1ng c\u00e1ch k\u00e9o c\u00e1c \u0111\u01b0\u1eddng vi\u1ec1n), sau \u0111\u00f3 k\u00e9o h\u1ed9p b\u1ed9 Slicer v\u00e0o kh\u00f4ng gian tr\u1ed1ng:<\/span><\/p>\n<figure style=\"width: 553px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"H\u00ecnh 2: C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/integrate-slicer-pivotchart.png\" alt=\"Positioning a slicer inside the pivot chart area\" width=\"553\" height=\"376\"><figcaption class=\"wp-caption-text\">H\u00ecnh 2: C\u00e1ch \u0111\u1ec3 ch\u00e8n Slicer cho PivotChart<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1eb9o: N\u1ebfu h\u1ed9p Slicer b\u1ecb \u1ea9n sau bi\u1ec3u \u0111\u1ed3, h\u00e3y b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ed9 Slicer v\u00e0 ch\u1ecdn Bring to Front.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_su_dung_cong_cu_Slicer_trong_Excel\"><\/span><b>C\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 Slicer trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Slicer trong Excel \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf d\u01b0\u1edbi d\u1ea1ng c\u00e1c n\u00fat l\u1ecdc d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng ch\u00fang r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 tr\u1ef1c quan. C\u00e1c ph\u1ea7n d\u01b0\u1edbi \u0111\u00e2y s\u1ebd cung c\u1ea5p cho b\u1ea1n m\u1ed9t s\u1ed1 g\u1ee3i \u00fd v\u1ec1 c\u00e1ch b\u1eaft \u0111\u1ea7u.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Slicer_lam_bo_loc_PivotTable\"><\/span><b>Slicer l\u00e0m b\u1ed9 l\u1ecdc PivotTable<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi PivotTable Slicer \u0111\u01b0\u1ee3c t\u1ea1o, n\u00fat b\u00ean trong h\u1ed9p Slicer \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. PivotTable s\u1ebd c\u1eadp nh\u1eadt ngay l\u1eadp t\u1ee9c \u0111\u1ec3 hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u ph\u00f9 h\u1ee3p v\u1edbi c\u00e0i \u0111\u1eb7t b\u1ed9 l\u1ecdc.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 x\u00f3a m\u1ed9t m\u1ee5c c\u1ee5 th\u1ec3 kh\u1ecfi b\u1ed9 l\u1ecdc, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat t\u01b0\u01a1ng \u1ee9ng trong Slicer \u0111\u1ec3 b\u1ecf ch\u1ecdn m\u1ee5c \u0111\u00f3.<\/span><\/p>\n<figure style=\"width: 375px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer l\u00e0m b\u1ed9 l\u1ecdc PivotTable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/use-slicer-excel.png\" alt=\"Using a pivot table slicer in Excel\" width=\"375\" height=\"282\"><figcaption class=\"wp-caption-text\">Slicer l\u00e0m b\u1ed9 l\u1ecdc PivotTable<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Slicer \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong PivotTable. V\u00ed d\u1ee5: Ch\u00fang ta c\u00f3 th\u1ec3 ch\u00e8n Product Slicer, sau \u0111\u00f3 \u1ea9n tr\u01b0\u1eddng Product v\u00e0 Slicer s\u1ebd v\u1eabn l\u1ecdc PivotTable c\u1ee7a ch\u00fang ta theo s\u1ea3n ph\u1ea9m:<\/span><\/p>\n<figure style=\"width: 515px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Product v\u00e0 Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/slicer-hidden-data.png\" alt=\"Using a slicer to filter data that are not shown in the pivot table\" width=\"515\" height=\"153\"><figcaption class=\"wp-caption-text\">Product v\u00e0 Slicer<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">N\u1ebfu nhi\u1ec1u Slicer \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi c\u00f9ng m\u1ed9t PivotTable v\u00e0 vi\u1ec7c nh\u1ea5p v\u00e0o m\u1ed9t m\u1ee5c nh\u1ea5t \u0111\u1ecbnh b\u00ean trong m\u1ed9t Slicer s\u1ebd l\u00e0m cho m\u1ed9t m\u1ee5c trong Slicer kh\u00e1c chuy\u1ec3n sang m\u00e0u xmas, \u0111i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u n\u00e0o \u0111\u1ec3 hi\u1ec3n th\u1ecb.<\/span><\/p>\n<p><span style=\"font-weight: 400\">V\u00ed d\u1ee5: Sau khi ch\u00fang ta ch\u1ecdn \u201cJohn\u201d trong Reseller Slicer, \u201cCherries\u201d trong Product Slicer chuy\u1ec3n sang m\u00e0u x\u00e1m, cho th\u1ea5y r\u1eb1ng John \u0111\u00e3 kh\u00f4ng th\u1ef1c hi\u1ec7n m\u1ed9t l\u1ea7n b\u00e1n \u201cCherries\u201d n\u00e0o:<\/span><\/p>\n<figure style=\"width: 382px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer l\u00e0m b\u1ed9 l\u1ecdc PivotTable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/multiple-slicers-pivot-table.png\" alt=\"Multiple slicers connected to the same pivot table\" width=\"382\" height=\"260\"><figcaption class=\"wp-caption-text\">Slicer l\u00e0m b\u1ed9 l\u1ecdc PivotTable<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_chon_nhieu_muc_trong_Slicer\"><\/span><b>C\u00e1ch ch\u1ecdn nhi\u1ec1u m\u1ee5c trong Slicer<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">C\u00f3 3 c\u00e1ch \u0111\u1ec3 ch\u1ecdn nhi\u1ec1u m\u1ee5c trong Excel Slicer:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o c\u00e1c n\u00fat c\u1ee7a Slicer trong khi gi\u1eef ph\u00edm Ctrl.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o n\u00fat Multi-Select (xem \u1ea3nh b\u00ean d\u01b0\u1edbi), sau \u0111\u00f3 nh\u1ea5p v\u00e0o t\u1eebng m\u1ee5c m\u1ed9t.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u0111\u00e2u b\u00ean trong Slicer v\u00e0 nh\u1ea5p Alt + S \u0111\u1ec3 b\u1eadt n\u00fat Multi_Select. Ch\u1ecdn c\u00e1c m\u1ee5c, sau \u0111\u00f3 nh\u1ea5n Alt + S m\u1ed9t l\u1ea7n n\u1eefa \u0111\u1ec3 t\u1eaft nhi\u1ec1u l\u1ef1a ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<figure style=\"width: 263px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch ch\u1ecdn nhi\u1ec1u m\u1ee5c trong Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-slicer-select-multiple-items.png\" alt=\"Selecting multiple items in a slicer\" width=\"263\" height=\"161\"><figcaption class=\"wp-caption-text\">C\u00e1ch ch\u1ecdn nhi\u1ec1u m\u1ee5c trong Slicer<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Di_chuyen_Slicer_trong_Excel\"><\/span><b>Di chuy\u1ec3n Slicer trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 di chuy\u1ec3n Slicer sang v\u1ecb tr\u00ed kh\u00e1c trong trang t\u00ednh, h\u00e3y \u0111\u01b0a con tr\u1ecf chu\u1ed9t l\u00ean Slicer cho \u0111\u1ebfn khi con tr\u1ecf chuy\u1ec3n th\u00e0nh m\u0169i t\u00ean b\u1ed1n \u0111\u1ea7u v\u00e0 k\u00e9o n\u00f3 \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi.<\/span><\/p>\n<figure style=\"width: 360px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Di chuy\u1ec3n Slicer trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/move-slicer-excel.png\" alt=\"Moving a slicer in Excel\" width=\"360\" height=\"158\"><figcaption class=\"wp-caption-text\">Di chuy\u1ec3n Slicer trong Excel<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_kich_thuoc_Slicer\"><\/span><b>Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc Slicer<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Nh\u01b0 v\u1edbi h\u1ea7u h\u1ebft c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng Excel, c\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc c\u1ee7a c\u00e1c c\u1ea1nh c\u1ee7a h\u1ed9p.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Ho\u1eb7c, ch\u1ecdn Slicer, chuy\u1ec3n \u0111\u1ebfn Tab Slicer Tools Option v\u00e0 \u0111\u1eb7t chi\u1ec1u cao v\u00e0 chi\u1ec1u r\u1ed9ng mong mu\u1ed1n cho m\u00e1y c\u1eaft c\u1ee7a b\u1ea1n:<\/span><\/p>\n<figure style=\"width: 396px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-resize-slicer.png\" alt=\"Resizing a slicer in Excel\" width=\"396\" height=\"432\"><figcaption class=\"wp-caption-text\">Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc Slicer<\/figcaption><\/figure>\n<p><b>C\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed Slicer trong m\u1ed9t trang t\u00ednh<\/b><\/p>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a Slicer trong trang t\u00ednh, ch\u1ec9 c\u1ea7n l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o Slicer, sau \u0111\u00f3 b\u1ea5m Size v\u00e0 Properties.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tr\u00ean ng\u0103n Format Slicer, b\u00ean d\u01b0\u1edbi Properties, h\u00e3y ch\u1ecdn Don\u2019t Move hay Size with cell box .<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">\u0110i\u1ec1u n\u00e0y s\u1ebd gi\u1eef cho Slicer c\u1ee7a b\u1ea1n kh\u00f4ng di chuy\u1ec3n khi b\u1ea1n th\u00eam ho\u1eb7c x\u00f3a h\u00e0ng v\u00e0 c\u1ed9t, th\u00eam ho\u1eb7c x\u00f3a c\u00e1c tr\u01b0\u1eddng kh\u1ecfi b\u1ea3ng t\u1ed5ng h\u1ee3p ho\u1eb7c th\u1ef1c hi\u1ec7n c\u00e1c thay \u0111\u1ed5i kh\u00e1c v\u1edbi trang t\u00ednh.<\/span><\/p>\n<figure style=\"width: 435px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed Slicer trong m\u1ed9t trang t\u00ednh\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lock-slicer-position.png\" alt=\"Lock the slicer position in a worksheet.\" width=\"435\" height=\"319\"><figcaption class=\"wp-caption-text\">C\u1ed1 \u0111\u1ecbnh v\u1ecb tr\u00ed Slicer trong m\u1ed9t trang t\u00ednh<\/figcaption><\/figure>\n<p><b>X\u00f3a b\u1ed9 l\u1ecdc Slicer<\/b><\/p>\n<p><span style=\"font-weight: 400\">B\u1ea1n c\u00f3 th\u1ec3 x\u00f3a c\u00e0i \u0111\u1eb7t Slicer hi\u1ec7n t\u1ea1i theo m\u1ed9t trong nh\u1eefng c\u00e1ch sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u0111\u00e2u trong Slicer v\u00e0 nh\u1ea5n ph\u00edm Alt + C.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o n\u00fat Clear Filter \u1edf g\u00f3c b\u00ean ph\u1ea3i.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Thao t\u00e1c n\u00e0y s\u1ebd x\u00f3a b\u1ed9 l\u1ecdc v\u00e0 ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c trong Slicer:<\/span><\/p>\n<figure style=\"width: 530px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"X\u00f3a b\u1ed9 l\u1ecdc Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/clear-excel-slicer-filetr.png\" alt=\"Clearing the slicer filter\" width=\"530\" height=\"161\"><figcaption class=\"wp-caption-text\">X\u00f3a b\u1ed9 l\u1ecdc Slicer<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Ngat_lien_ket_Slicer_khoi_PivotTable\"><\/span><b>Ng\u1eaft li\u00ean k\u1ebft Slicer kh\u1ecfi PivotTable<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 ng\u1eaft li\u00ean k\u1ebft Slicer kh\u1ecfi PivotTable nh\u1ea5t \u0111\u1ecbnh, \u0111\u00e2y l\u00e0 nh\u1eefng g\u00ec b\u1ea1n l\u00e0m:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p v\u00e0o b\u1ea5t k\u1ef3 \u0111\u00e2u trong PivotTable m\u00e0 b\u1ea1n mu\u1ed1n ng\u1eaft li\u00ean k\u1ebft v\u1edbi Slicer.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong Excel 2019, 2016 v\u00e0 2013, h\u00e3y chuy\u1ec3n \u0111\u1ebfn Analyze Tab &gt; Filter Group v\u00e0 nh\u1ea5p v\u00e0o Filter Connections. Trong Excel 2010, h\u00e3y chuy\u1ec3n Options Tab v\u00e0 nh\u1ea5p Insert Slicer &gt; Slicer Connections.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong h\u1ed9p tho\u1ea1i Filter Connections h\u00e3y b\u1ecf ch\u1ecdn Slicer m\u00e0 b\u1ea1n mu\u1ed1n ng\u1eaft li\u00ean k\u1ebft:<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">H\u00e3y nh\u1edb r\u1eb1ng n\u00f3 s\u1ebd kh\u00f4ng x\u00f3a Slicer kh\u1ecfi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n m\u00e0 ch\u1ec9 ng\u1eaft li\u00ean k\u1ebft kh\u1ecfi PivotTable. N\u1ebfu b\u1ea1n mu\u1ed1n kh\u00f4i ph\u1ee5c li\u00ean k\u1ebft l\u1ea1i, h\u00e3y m\u1edf l\u1ea1i h\u1ed9p tho\u1ea1i Filter Connections. K\u1ef9 thu\u1eadt n\u00e0y c\u00f3 th\u1ec3 h\u1eefu \u00edch khi c\u00f9ng m\u1ed9t Slicer \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi nhi\u1ec1u PivotTable.<\/span><\/p>\n<figure style=\"width: 313px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Ng\u1eaft li\u00ean k\u1ebft Slicer kh\u1ecfi PivotTable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/disconnect-slicer-pivot-table.png\" alt=\"Disconnecting a slicer from a pivot table in Excel\" width=\"313\" height=\"415\"><figcaption class=\"wp-caption-text\">Ng\u1eaft li\u00ean k\u1ebft Slicer kh\u1ecfi PivotTable<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Cach_de_loai_vo_Slicer_trong_Excel\"><\/span><b>C\u00e1ch \u0111\u1ec3 lo\u1ea1i v\u1ecf Slicer trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 x\u00f3a v\u0129nh vi\u1ec5n Slicer kh\u1ecfi PivotTable, h\u00e3y th\u1ef1c hi\u1ec7n m\u1ed9t trong c\u00e1c thao t\u00e1c sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn Slicer v\u00e0 nh\u1ea5n ph\u00edm Delete.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o Slicer, sau \u0111\u00f3 b\u1ea5m Remove &lt;T\u00ean Slicer&gt;.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tuy_chinh_Slicer_trong_Excel\"><\/span><b>C\u00e1ch t\u00f9y ch\u1ec9nh Slicer trong Excel\u00a0<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Slicer trong Excel c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00f9y ch\u1ec9nh \u2013 b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i giao di\u1ec7n, m\u00e0u s\u1eafc v\u00e0 c\u00e0i \u0111\u1eb7t c\u1ee7a ch\u00fang. Trong ph\u1ea7n n\u00e0y, ch\u00fang ra s\u1ebd t\u1eadp trung v\u00e0o c\u00e1ch b\u1ea1n c\u00f3 th\u1ec3 tinh ch\u1ec9nh Slicer m\u00e0 Microsoft Excel t\u1ea1o theo m\u1eb7c \u0111\u1ecbnh.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_kieu_Slicer\"><\/span><b>Thay \u0111\u1ed5i ki\u1ec3u Slicer<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 thay \u0111\u1ed5i m\u00e0u xanh lam m\u1eb7c \u0111\u1ecbnh c\u1ee7a Slicer trong Excel, h\u00e3y l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea5m v\u00e0o Slicer \u0111\u1ebb Tools Tab xu\u1ea5t hi\u1ec7n tr\u00ean ruy b\u0103ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tr\u00ean tab Slicer Options, trong nh\u00f3m Slicer Style, b\u1ea5m v\u00e0o h\u00ecnh thu nh\u1ecf b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng. Done!<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">M\u1eb9o: \u0110\u1ec3 xem t\u1ea5t c\u1ea3 c\u00e1c ki\u1ec3u Slicer c\u00f3 s\u1eb5n, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat More:<\/span><\/p>\n<figure style=\"width: 604px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Thay \u0111\u1ed5i ki\u1ec3u Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/change-excel-slicer-style.png\" alt=\"Changing an Excel slicer style\" width=\"604\" height=\"157\"><figcaption class=\"wp-caption-text\">Thay \u0111\u1ed5i ki\u1ec3u Slicer<\/figcaption><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Tao_kieu_Slicer_tuy_chinh_trong_Excel\"><\/span><b>T\u1ea1o ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n kh\u00f4ng h\u00e0i l\u00f2ng v\u1edbi b\u1ea5t k\u1ef3 ki\u1ec3u Slicer n\u00e0o trong Excel \u0111\u01b0\u1ee3c m\u1eb7c \u0111\u1ecbnh s\u1eb5n, h\u00e3y t\u1ea1o ki\u1ec3u ri\u00eang c\u1ee7a b\u1ea1n. \u0110\u00e2y l\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tr\u00ean Tab Slicer Tools Options, trong nh\u00f3m Slicer Styles, nh\u1ea5n n\u00fat More (xem \u1ea3nh minh h\u1ecda b\u00ean tr\u00ean).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5n v\u00e0o n\u00fat New Slicer Style \u1edf cu\u1ed1i Slicer Styles.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1eb7t t\u00ean cho ki\u1ec3u m\u1edbi c\u1ee7a b\u1ea1n,<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ch\u1ecdn m\u1ed9t ph\u1ea7n c\u1ee7a Slicer, nh\u1ea5p v\u00e0o n\u00fat Format v\u00e0 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng cho ph\u1ea7n \u0111\u00f3. Khi ho\u00e0n t\u1ea5t, h\u00e3y chuy\u1ec3n sang ph\u1ea7n ti\u1ebfp theo.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea5m OK v\u00e0 ki\u1ec3m m\u1edbi t\u1ea1o c\u1ee7a b\u1ea1n s\u1ebd xu\u1ea5t hi\u1ec7n trong Slicer Styles Gallery.<\/span><\/li>\n<\/ol>\n<figure style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"T\u1ea1o ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/custom-slicer-style.png\" alt=\"Creating a custom slicer style in Excel\" width=\"600\" height=\"704\"><figcaption class=\"wp-caption-text\">T\u1ea1o ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh trong Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ea7u ti\u00ean, m\u1ed9t s\u1ed1 y\u1ebfu t\u1ed1 c\u1ee7a Slicer c\u00f3 v\u1ebb kh\u00f3 hi\u1ec3u, nh\u01b0ng h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi hy v\u1ecdng s\u1ebd cung c\u1ea5p cho b\u1ea1n m\u1ed9t s\u1ed1 gi\u1ea3i \u0111\u00e1p:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u201cWith data\u201d l\u00e0 m\u1ed9t m\u1ee5c c\u1ee7a Slicer \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi m\u1ed1 s\u1ed1 d\u1eef li\u1ec7u trong b\u1ea3ng t\u1ed5ng h\u1ee3p.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">C\u00e1c ph\u1ea7n \u201cWith no Data\u201d l\u00e0 c\u00e1c m\u1ee5c c\u1ee7a Slicer kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u trong PivotTable (V\u00ed d\u1ee5: d\u1eef li\u1ec7u \u0111\u00e3 b\u1ecb x\u00f3a kh\u1ecfi b\u1ea3ng sau khi Slicer \u0111\u01b0\u1ee3c t\u1ea1o).<\/span><\/li>\n<\/ul>\n<figure style=\"width: 404px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u00e0i t\u1eadp t\u1ea1o ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/slicer-items-with-without-data.png\" alt=\"Formatting of different slicer elements\" width=\"404\" height=\"267\"><figcaption class=\"wp-caption-text\">B\u00e0i t\u1eadp t\u1ea1o ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh trong Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">M\u1eb9o:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N\u1ebfu b\u1ea1n mu\u1ed1n thi\u1ebft k\u1ebf Slicer tuy\u1ec7t v\u1eddi, nh\u01b0ng kh\u00f4ng bi\u1ebft b\u1eaft \u0111\u1ea7u t\u1eeb \u0111\u00e2u, h\u00e3y ch\u1ecdn ki\u1ec3u c\u00f3 s\u1eb5n g\u1ea7n nh\u1ea5t v\u1edbi \u00fd t\u01b0\u1edfng c\u1ee7a b\u1ea1n v\u1ec1 Slicer, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o n\u00f3 v\u00e0 ch\u1ecdn Duplicate. B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh c\u00e1c ph\u1ea7n ri\u00eang l\u1ebb c\u1ee7a Slicer \u0111\u00f3 theo \u00fd th\u00edch c\u1ee7a m\u00ecnh v\u00e0 l\u01b0u n\u00f3 d\u01b0\u1edbi m\u1ed9t t\u00ean kh\u00e1c.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">V\u00ec c\u00e1c ki\u1ec3u t\u00f9y ch\u1ec9nh \u0111\u01b0\u1ee3c l\u01b0u \u1edf c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c, ch\u00fang kh\u00f4ng c\u00f3 s\u1eb5n trong c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c m\u1edbi. \u0110\u1ec3 kh\u1eafc ph\u1ee5c h\u1ea1n ch\u1ebf n\u00e0y, h\u00e3y l\u01b0u c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh c\u1ee7a b\u1ea1n d\u01b0\u1edbi nhi\u1ec1u d\u1ea1ng m\u1eabu Excel (t\u1ec7p *.xltx). Khi b\u1ea1n t\u1ea1o m\u1ed9t c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c m\u1edbi d\u1ef1a tr\u00ean m\u1ea5y \u0111\u00f3, c\u00e1c ki\u1ec3u Slicer t\u00f9y ch\u1ec9nh s\u1ebd v\u1eabn \u0111\u01b0\u1ee3c l\u01b0u.<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Nhieu_cot_trong_Excel_Slicer\"><\/span><b>Nhi\u1ec1u c\u1ed9t trong Excel Slicer<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">Khi b\u1ea1n c\u00f3 qu\u00e1 nhi\u1ec1u m\u1ee5c trong Slicer, h\u00e3y s\u1eafp x\u1ebfp c\u00e1c m\u1ee5c \u0111\u00f3 th\u00e0nh nhi\u1ec1u c\u1ed9t:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">V\u1edbi Slicer \u0111\u01b0\u1ee3c ch\u1ecdn, h\u00e3y chuy\u1ec3n \u0111\u1ebfn Slicer Tools Options tab &gt; Buttons group.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong h\u1ed9p C\u1ed9t, \u0111\u1eb7t s\u1ed1 c\u1ed9t hi\u1ec3n th\u1ecb b\u00ean trong h\u1ed9p Slicer.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Theo t\u00f9y ch\u1ecdn, \u0111i\u1ec1u ch\u1ec9nh chi\u1ec1u cao v\u00e0 chi\u1ec1u r\u1ed9ng c\u1ee7a h\u1ed9p Slicer v\u00e0 c\u00e1c n\u00fat b\u1ea1n th\u1ea5y ph\u00f9 h\u1ee3p.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c m\u1ee5c c\u1ee7a Slicer m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i cu\u1ed9n l\u00ean cu\u1ed9n xu\u1ed1ng.<\/span><\/p>\n<figure style=\"width: 293px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Nhi\u1ec1u c\u1ed9t trong Excel Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/slicer-multiple-columns.png\" alt=\"Setting up multiple columns in a slicer\" width=\"293\" height=\"412\"><figcaption class=\"wp-caption-text\">Nhi\u1ec1u c\u1ed9t trong Excel Slicer<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y, b\u1ea1n th\u1eadm ch\u00ed c\u00f3 th\u1ec3 l\u00e0m cho Slicer c\u1ee7a m\u00ecnh tr\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c tab ph\u00eda sau b\u1ea3ng t\u1ed5ng h\u1ee3p c\u1ee7a b\u1ea1n:<\/span><\/p>\n<figure style=\"width: 407px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"B\u00e0i t\u1eadp nhi\u1ec1u c\u1ed9t trong Excel Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/slicer-tabs-pivottable.png\" alt=\"A custom Excel slicer that looks like tabs behind a pivot table\" width=\"407\" height=\"159\"><figcaption class=\"wp-caption-text\">B\u00e0i t\u1eadp nhi\u1ec1u c\u1ed9t trong Excel Slicer<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">\u0110\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c hi\u1ec7u \u1ee9ng \u201ctab\u201d, c\u00e1c t\u00f9y ch\u1ec9nh sau \u0111\u00e3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Slicer \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp th\u00e0nh 4 c\u1ed9t.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Ti\u00eau \u0111\u1ec1 Slicer \u0111\u00e3 b\u1ecb \u1ea9n (xem h\u01b0\u1edbng d\u1eabn b\u00ean d\u01b0\u1edbi).<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">M\u1ed9t ki\u1ec3u t\u00f9y ch\u1ec9nh \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea1o: \u0111\u01b0\u1eddng vi\u1ec1n c\u1ee7a Slicer \u0111\u01b0\u1ee3c \u0111\u1eb7t th\u00e0nh kh\u00f4ng, \u0111\u01b0\u1eddng vi\u1ec1n c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c v\u00e0 m\u00e0u t\u00f4 c\u1ee7a \u201cSelected item with data\u201d \u0111\u01b0\u1ee3c \u0111\u1eb7t \u0111\u1ec3 kh\u1edbp v\u1edbi m\u00e0u c\u1ee7a h\u00e0ng ti\u00eau \u0111\u1ec1 c\u1ee7a b\u1ea3ng t\u1ed5ng h\u1ee3p. Vui l\u00f2ng xem C\u00e1ch t\u1ea1o ki\u1ec3u m\u00e1y c\u1eaft t\u00f9y ch\u1ec9nh \u0111\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft.<\/span><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Thay_doi_cai_dat_Slicer\"><\/span><b>Thay \u0111\u1ed5i c\u00e0i \u0111\u1eb7t Slicer<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">M\u1ed9t trong nh\u1eefng \u0111i\u1ec1u t\u1ed1t nh\u1ea5t v\u1ec1 Slicer Excel l\u00e0 ch\u00fang ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh. B\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o Slicer v\u00e0 nh\u1ea5p v\u00e0o Slicer Settings. Slicer Settings s\u1ebd hi\u1ec3n th\u1ecb (h\u00ecnh \u1ea3nh minh h\u1ecda b\u00ean d\u01b0\u1edbi hi\u1ec3n th\u1ecb c\u00e1c t\u00f9y ch\u1ecdn m\u1eb7c \u0111\u1ecbnh):<\/span><\/p>\n<figure style=\"width: 499px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Thay \u0111\u1ed5i c\u00e0i \u0111\u1eb7t Slicer\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-slicer-settings.png\" alt=\"Changing the slicer settings\" width=\"499\" height=\"292\"><figcaption class=\"wp-caption-text\">Thay \u0111\u1ed5i c\u00e0i \u0111\u1eb7t Slicer<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong s\u1ed1 nh\u1eefng th\u1ee9 kh\u00e1c, c\u00e1ch t\u00f9y ch\u1ec9nh sau c\u00f3 th\u1ec3 h\u1eefu \u00edch:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u1ea8n ti\u00eau \u0111\u1ec1 Slicer b\u1eb1ng c\u00e1ch x\u00f3a Display header.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">S\u1eafp x\u1ebfp c\u00e1c m\u1ee5c c\u1ee7a Slicer t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u1ea8n c\u00e1c m\u1ee5c kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch b\u1ecf ch\u1ecdn h\u1ed9p t\u01b0\u01a1ng \u1ee9ng.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u1ea8n c\u00e1c m\u1ee5c \u0111\u00e3 x\u00f3a kh\u1ecfi ngu\u1ed3n d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch b\u1ecf h\u1ed9p ki\u1ec3m tra c\u00f3 li\u00ean quan. Khi b\u1ecf ch\u1ecdn t\u00f9y ch\u1ec9nh, slicer s\u1ebd ng\u01b0ng hi\u1ec3n th\u1ecb c\u00e1c m\u1ee5c c\u0169 \u0111\u00e3 b\u1ecb x\u00f3a kh\u1ecfi ngu\u1ed3n d\u1eef li\u1ec7u.<\/span><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_de_ket_noi_Slicer_voi_nhieu_PivotTable\"><\/span><strong>C\u00e1ch \u0111\u1ec3 k\u1ebft n\u1ed1i Slicer v\u1edbi nhi\u1ec1u PivotTable<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 t\u1ea1o c\u00e1c b\u00e1o c\u00e1o \u0111\u01b0\u1ee3c l\u1ecdc ch\u00e9o trong Excel, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n k\u1ebft n\u1ed1i c\u00f9ng m\u1ed9t Slicer v\u1edbi hai hay nhi\u1ec1u PivotTable. May m\u1eafn thay, Microsoft Excel c\u0169ng cung c\u1ea5p t\u00ednh n\u0103ng n\u00e0y v\u00e0 n\u00f3 kh\u00f4ng y\u00eau c\u1ea7u b\u1ea5t k\u1ef3 c\u1eadp nh\u1eadt n\u00e0o.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 li\u00ean k\u1ebft m\u1ed9t Slicer v\u1edbi nhi\u1ec1u PivotTable, h\u00e3y l\u00e0m c\u00e1c b\u01b0\u1edbc sau:<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">L\u00fd t\u01b0\u1edfng nh\u1ea5t l\u00e0 t\u1ea1o ra hai ho\u1eb7c nhi\u1ec1u PivotTable trong c\u00f9ng m\u1ed9t trang t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Theo t\u00f9y ch\u1ecdn, \u0111\u1eb7t t\u00ean c\u00f3 \u00fd ngh\u0129a cho PivotTable c\u1ee7a b\u1ea1n \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng x\u00e1c \u0111\u1ecbnh t\u1eebng PivotTable. \u0110\u1ec3 ddajtwj t\u00ean cho PivotTable, h\u00e3y chuy\u1ec3n \u0111\u1ebfn tab Analyze v\u00e0 nh\u1eadp t\u00ean v\u00e0o h\u1ed9p PivotTable Name \u1edf g\u00f3c tr\u00ean c\u00f9ng b\u00ean tr\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">T\u1ea1o m\u1ed9t Slicer cho b\u1ea5t k\u1ef3 PivotTable n\u00e0o nh\u01b0 b\u00ecnh th\u01b0\u1eddng.<\/span><\/li>\n<\/ol>\n<figure style=\"width: 335px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch \u0111\u1ec3 k\u1ebft n\u1ed1i Slicer v\u1edbi nhi\u1ec1u PivotTable\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/connect-slicer-multiple-pivottables.png\" alt=\"Connecting a slicer to multiple pivot tables\" width=\"335\" height=\"304\"><figcaption class=\"wp-caption-text\">C\u00e1ch \u0111\u1ec3 k\u1ebft n\u1ed1i Slicer v\u1edbi nhi\u1ec1u PivotTable<\/figcaption><\/figure>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o Slicer, sau \u0111\u00f3 b\u1ea5m Report Connections &gt; Slicer group v\u00e0 nh\u1ea5n v\u00e0o n\u00fat Report Connections.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Trong h\u1ed9p tho\u1ea1i Report Connections, h\u00e3y ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c PivotTable m\u00e0 b\u1ea1n mu\u1ed1n li\u00ean k\u1ebft \u0111\u1ebfn Slicer v\u00e0 b\u1ea5m OK.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400\">B\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc t\u1ea5t c\u1ea3 c\u00e1c PivotTable \u0111\u00e3 \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi m\u1ed9t c\u00fa click chu\u1ed9t v\u00e0o n\u00fat Slicer.<\/span><\/p>\n<figure style=\"width: 508px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"PivotTable trong Excel\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/slicer-connected-multiple-pivottables.png\" alt=\"A slicer linked to two pivot tables\" width=\"508\" height=\"393\"><figcaption class=\"wp-caption-text\">PivotTable trong Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">Trong h\u01b0\u1edbng d\u1eabn t\u01b0\u01a1ng t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i m\u1ed9t SLicer v\u1edbi nhi\u1ec1u PivotChart:<\/span><\/p>\n<figure style=\"width: 619px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"SLicer v\u1edbi nhi\u1ec1u PivotChart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/connect-slicer-multiple-pivot-charts.png\" alt=\"A slicer linked to multiple pivot charts\" width=\"619\" height=\"361\"><figcaption class=\"wp-caption-text\">SLicer v\u1edbi nhi\u1ec1u PivotChart<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">L\u01b0u \u00fd: M\u1ed9t Slicer c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi t\u1ea5t c\u1ea3 c\u00e1c PivotTable v\u00e0 PivotChart d\u1ef1a tr\u00ean c\u00f9ng m\u1ed9t ngu\u1ed3n d\u1eef li\u1ec7u.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_de_mo_khoa_mot_trang_tinh_duoc_bao_ve\"><\/span><b>C\u00e1ch \u0111\u1ec3 m\u1edf kh\u00f3a m\u1ed9t trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Khi chia s\u1ebb trang t\u00ednh c\u1ee7a b\u1ea1n v\u1edbi nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n kh\u00f3a b\u1ea3ng PivotTable c\u1ee7a m\u00ecnh kh\u1ecfi vi\u1ec7c ch\u1ec9nh s\u1eeda, nh\u01b0ng v\u1eabn c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c Slicer. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 thi\u1ebft l\u1eadp:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\u0110\u1ec3 m\u1edf kh\u00f3a nhi\u1ec1u h\u01a1n m\u1ed9t Slicer c\u00f9ng l\u00fac, h\u00e3y gi\u1eef ph\u00edm Ctrl trong khi ch\u1ecdn c\u00e1c tr\u1ea1ng th\u00e1i.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t k\u1ef3 thi\u1ebft b\u1ecb c\u1eaft n\u00e0o \u0111\u00e3 ch\u1ecdn v\u00e0 ch\u1ecdn Size v\u00e0 Properties t\u1eeb menu.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Tr\u00ean thanh Format Slicer, b\u00ean d\u01b0\u1edbi Properties, b\u1ecf ch\u1ecdn Locked v\u00e0 \u0111\u00f3ng thanh.<\/span><\/li>\n<\/ol>\n<figure style=\"width: 269px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e1ch \u0111\u1ec3 m\u1edf kh\u00f3a m\u1ed9t trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/unlock-slicer-excel.png\" alt=\"Unlocking a slicer in Excel\" width=\"269\" height=\"326\"><figcaption class=\"wp-caption-text\">C\u00e1ch \u0111\u1ec3 m\u1edf kh\u00f3a m\u1ed9t trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">4. Tr\u00ean tab Review, trong Protect group, click Protect Sheet.<\/span><\/p>\n<p><span style=\"font-weight: 400\">5. Trong h\u1ed9p tho\u1ea1i Protect Sheet, h\u00e3y ch\u1ecdn t\u00f9y ch\u1ecdn Use PivotTable &amp; PivotChart.<\/span><\/p>\n<figure style=\"width: 274px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" title=\"Use PivotTable &amp; PivotChart\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/use-pivottable-pivotchart.png\" alt=\"Protect the worksheet, but allow to use the pivot table and pivot chart.\" width=\"274\" height=\"308\"><figcaption class=\"wp-caption-text\">Use PivotTable &amp; PivotChart<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400\">6. Theo t\u00f9y ch\u1ecdn, nh\u1eadp m\u1eadt kh\u1ea9u v\u00e0 nh\u1ea5p v\u00e0o OK.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Gi\u1edd \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 chia s\u1ebb trang t\u00ednh c\u1ee7a m\u00ecnh ngay c\u1ea3 v\u1edbi ng\u01b0\u1eddi m\u1edbi quen v\u1edbi Excel m\u00e0 kh\u00f4ng ph\u1ea3i lo l\u1eafng v\u1ec1 s\u1ef1 an to\u00e0n c\u1ee7a d\u1eef li\u1ec7u \u2013 nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c s\u1ebd kh\u00f4ng l\u00e0m sai \u0111\u1ecbnh d\u1ea1ng v\u00e0 b\u1ed1 c\u1ee5c c\u1ee7a <strong>Pivot Table<\/strong> c\u1ee7a b\u1ea1n, nh\u01b0ng v\u1eabn c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c b\u00e1o c\u00e1o t\u01b0\u01a1ng t\u00e1c c\u1ee7a b\u1ea1n v\u1edbi Slicer.<\/span><\/p>\n<p><span style=\"font-weight: 400\"><strong>H\u1ecdc Excel Online<\/strong> hy v\u1ecdng h\u01b0\u1edbng d\u1eabn n\u00e0y \u0111\u00e3 l\u00e0m s\u00e1ng t\u1ecf c\u00e1ch ch\u00e8n v\u00e0 s\u1eed d\u1ee5ng Slicer trong Excel. \u0110\u1ec3 hi\u1ec3u th\u00eam, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i xu\u1ed1ng c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c m\u1eabu c\u1ee7a ch\u00fang t\u00f4i v\u1edbi v\u00ed d\u1ee5 d\u01b0\u1edbi. T\u00f4i c\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 \u0111\u1ecdc v\u00e0 hy v\u1ecdng g\u1eb7p b\u1ea1n tr\u00ean Blog c\u1ee7a ch\u00fang t\u00f4i v\u00e0o tu\u1ea7n t\u1edbi!<\/span><\/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-77.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":2343,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2342","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\/2342","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=2342"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2342\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2343"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}