{"id":6547,"date":"2021-04-01T14:41:35","date_gmt":"2021-04-01T12:41:35","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6547"},"modified":"2024-02-06T19:16:27","modified_gmt":"2024-02-06T18:16:27","slug":"ultimate-guide-excel-pivot-table-slicers","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/","title":{"rendered":"The Ultimate Guide to Excel Pivot Table Slicers"},"content":{"rendered":"<p><strong>Excel Slicer<\/strong> was first introduced in Pivot Tables in Excel 2010 for Windows and Excel 2016 for <a class=\"wpil_keyword_link\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/mac\/microsoft-365-for-mac\" target=\"_blank\" rel=\"noopener nofollow\" title=\"Mac\" data-wpil-keyword-link=\"linked\">Mac<\/a>.<\/p>\n<p><a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> Slicers are a visual filter in the form of an interactive button. \u00a0There are several cool things that you can do with Pivot Table Slicer, like customize them, filter them, connect them to multiple Pivot Tables plus much more!<\/p>\n<h3><em><strong>Learn How to Create Interactive employee photos with Excel Slicer!<\/strong><\/em><\/h3>\n<p>*** Watch our video and step by step guide below with a free downloadable Excel workbook to practice ***<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/JkNzhVpRPws?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/JkNzhVpRPws\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n\n<div class=\"table-of-contents\" id=\"table_of_contents\" ><i class=\"fa fa-arrow-down \" ><\/i>\u00a0<a href=\"#section1\"><strong>Topic 1:<\/strong> Insert a Slicer<\/a><br \/>\n<i class=\"fa fa-filter \" ><\/i>\u00a0<a href=\"#section2\"><strong>Topic 2:<\/strong> Different Ways to Filter an Excel Slicer<\/a><br \/>\n<i class=\"fa fa-columns \" ><\/i>\u00a0<a href=\"#section3\"><strong>Topic 3:<\/strong> Add Columns to Slicer Buttons<\/a><br \/>\n<i class=\"fa fa-file-excel-o \" ><\/i>\u00a0<a href=\"#section4\"><strong>Topic 4:<\/strong> Slicer Styles &amp; Settings<\/a><br \/>\n<i class=\"fa fa-table \" ><\/i>\u00a0<a href=\"#section5\"><strong>Topic 5:<\/strong> Connect Slicers to Multiple Excel Pivot Tables<\/a><br \/>\n<i class=\"fa fa-lock \" ><\/i>\u00a0<a href=\"#section6\"><strong>Topic 6:<\/strong> Lock The Excel Pivot Table But NOT The Slicer!<\/a><br \/>\n<i class=\"fa fa-desktop \" ><\/i> <a href=\"#section7\"><strong>BONUS:<\/strong> Free Excel Pivot Table Webinar Training!<\/a>\u00a0<\/div>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/#1_Insert_a_Slicer\" title=\"1. Insert a Slicer \">1. Insert a Slicer <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/#2_Different_Ways_to_Filter_an_Excel_Slicer\" title=\"2. Different Ways to Filter an Excel Slicer \">2. Different Ways to Filter an Excel Slicer <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/#3_Add_Columns_to_Slicer_Buttons\" title=\"3. Add Columns to Slicer Buttons \">3. Add Columns to Slicer Buttons <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/#4_Slicer_Styles_Settings\" title=\"4. Slicer Styles &amp; Settings \">4. Slicer Styles &amp; Settings <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/#5_Connect_Slicers_to_Multiple_Excel_Pivot_Tables\" title=\"5. Connect Slicers to Multiple Excel Pivot Tables \">5. Connect Slicers to Multiple Excel Pivot Tables <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/#6_Lock_The_Excel_Pivot_Table_But_NOT_The_Slicer\" title=\"6.\u00a0Lock The Excel Pivot Table But NOT The Slicer!\">6.\u00a0Lock The Excel Pivot Table But NOT The Slicer!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/#Free_Excel_Pivot_Table_Webinar_Training\" title=\"Free Excel Pivot Table Webinar Training! \">Free Excel Pivot Table Webinar Training! <\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"1_Insert_a_Slicer\"><\/span><span style=\"color: #ff0000;\"><a id=\"section1\"><\/a>1. Insert a Slicer <a href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em>Excel Slicer<\/em> is visual filter or interactive button that allow you to see what items have been chosen within a Pivot Table.<\/p>\n<p>They are a new feature from Excel 2010 onward and Mac for Excel 2016 and a must for anyone wanting to wow their boss by adding interactivity in their reports! \u00a0I show you How to Use Slicer in Excel below:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-Slicer.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-Slicer.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Insert-a-Slicer.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select your Pivot Table by clicking anywhere inside it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Insert a Pivot Table Slicer\"  class=\"alignnone size-full wp-image-6526\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-01.jpg\" alt=\"How To Insert a Pivot Table Slicer\" width=\"480\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-01.jpg 480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-01-300x183.jpg 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Options(Excel 2010)\/Analyze(Excel 2013&amp;2016) &gt; Insert Slicer\u00a0<\/strong><\/em><\/p>\n<p>Select the\u00a0<strong>Month\u00a0<\/strong>and\u00a0<strong>Year <\/strong>Fields.<\/p>\n<p>Click\u00a0<strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Insert a Pivot Table Slicer\"  class=\"alignnone size-full wp-image-6527\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-02.jpg\" alt=\"How To Insert a Pivot Table Slicer\" width=\"557\" height=\"687\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-02.jpg 557w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-02-243x300.jpg 243w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<p>Your slicer is now ready! \u00a0Go crazy clicking, slicing and dicing your data!<\/p>\n<p><span style=\"color: #ff0000;\"><strong>TIP:<\/strong> <\/span><em><strong>Hold down the CTRL key to select multiple items in your Slicer.<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How To Insert a Pivot Table Slicer\"  class=\"alignnone size-full wp-image-6528\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-03.jpg\" alt=\"How To Insert a Pivot Table Slicer\" width=\"418\" height=\"456\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-03.jpg 418w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Insert-a-slicer-03-275x300.jpg 275w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"2_Different_Ways_to_Filter_an_Excel_Slicer\"><\/span><span style=\"color: #ff0000;\"><a id=\"section2\"><\/a>2. Different Ways to Filter an Excel Slicer <\/span><a href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel Slicers are the best thing since sliced bread!<\/p>\n<p>They are a new feature from Excel 2010 onward and Mac for Excel 2016 and are visual buttons that show you what items have been filtered or selected in a Pivot Table.<\/p>\n<p>There are several ways that you can filter an Excel Slicer.<\/p>\n<p>Try it now by downloading this free workbook:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<\/span><span class=\"postTitle px-3\">Filtering-a-Slicer.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<p><span style=\"color: #0000ff;\"><strong>LEFT MOUSE CLICK:<\/strong> <\/span>You can select items from the Slicer by using your left mouse button;<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Different Ways to Filter an Excel Slicer\"  class=\"alignnone size-full wp-image-6531\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-01.jpg\" alt=\"Different Ways to Filter an Excel Slicer\" width=\"936\" height=\"471\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-01.jpg 936w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-01-300x151.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-01-768x386.jpg 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>DRAG LEFT MOUSE BUTTON:<\/strong> <\/span>You can select an array of items by clicking the left mouse button and doing a dragging motion downwards\/upwards within the Slicer;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Different Ways to Filter an Excel Slicer\"  class=\"alignnone size-full wp-image-6532\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-02.jpg\" alt=\"Different Ways to Filter an Excel Slicer\" width=\"942\" height=\"471\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-02.jpg 942w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-02-300x150.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-02-768x384.jpg 768w\" sizes=\"(max-width: 942px) 100vw, 942px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>CTRL KEYBOARD:<\/strong> <\/span>You can select multiple items by holding down the CTRL key on your keyboard;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Different Ways to Filter an Excel Slicer\"  class=\"alignnone size-full wp-image-6533\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-03.jpg\" alt=\"Different Ways to Filter an Excel Slicer\" width=\"936\" height=\"471\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-03.jpg 936w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-03-300x151.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-03-768x386.jpg 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>SHIFT KEYBOARD:<\/strong> <\/span>You can select a range of items by holding down the SHIFT key on your keyboard!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Different Ways to Filter an Excel Slicer\"  class=\"alignnone wp-image-6534 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-04.jpg\" alt=\"Different Ways to Filter an Excel Slicer\" width=\"939\" height=\"466\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-04.jpg 939w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-04-300x149.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/09\/Filtering-a-Slicer-04-768x381.jpg 768w\" sizes=\"(max-width: 939px) 100vw, 939px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Add_Columns_to_Slicer_Buttons\"><\/span><span style=\"color: #ff0000;\"><a id=\"section3\"><\/a>3. Add Columns to Slicer Buttons <\/span><a href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you insert an Excel Slicer with your Pivot Table it defaults to one column, showing all your items in a vertical layout.<\/p>\n<p>Say that your Slicer is showing months from January to December, you can change the layout of the buttons to show in 3 separate columns, turning it into a &#8220;Quarterly View&#8221;.<\/p>\n<p>To do this you need to click on your Slicer and go to<em> Slicer Tools &gt; Options &gt; Buttons &gt; Columns<\/em>.\u00a0 You can then use the scroll bar to increase and decrease the columns or manually type in the number of columns to show your Slicer.<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Slicer-Columns.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select your\u00a0Slicer.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add Columns to Pivot Table Slicer Buttons\"  class=\"alignnone size-full wp-image-6538\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-1.jpg\" alt=\"Add Columns to Pivot Table Slicer Buttons\" width=\"187\" height=\"459\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-1.jpg 187w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-1-122x300.jpg 122w\" sizes=\"(max-width: 187px) 100vw, 187px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Slicer Tools &gt; Options &gt; Buttons &gt; Columns\u00a0<\/strong><\/em><\/p>\n<p>Select\u00a0<strong>Columns\u00a0<\/strong>to\u00a0<strong>3.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add Columns to Pivot Table Slicer Buttons\"  class=\"alignnone size-full wp-image-6539\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-2.jpg\" alt=\"Add Columns to Pivot Table Slicer Buttons\" width=\"387\" height=\"161\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-2.jpg 387w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-2-300x125.jpg 300w\" sizes=\"(max-width: 387px) 100vw, 387px\" \/><\/a><\/p>\n<p>Your slicer now has a 3-column layout!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Add Columns to Pivot Table Slicer Buttons\"  class=\"alignnone size-full wp-image-6540\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-3.jpg\" alt=\"Add Columns to Pivot Table Slicer Buttons\" width=\"416\" height=\"242\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-3.jpg 416w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Slicer-Columns-3-300x175.jpg 300w\" sizes=\"(max-width: 416px) 100vw, 416px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"4_Slicer_Styles_Settings\"><\/span><span style=\"color: #ff0000;\"><a id=\"section4\"><\/a>4. Slicer Styles &amp; Settings <\/span><a href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are several different <em>Slicer Styles<\/em> available when you click on an Excel Slicer.\u00a0 It is located in the<em> Slicer Tools<\/em> tab in the Ribbon under <em>Options &gt; Slicer Styles<\/em>.\u00a0 You can also add columns to a Slicer and you can find more Slicer options by <em>Right Clicking<\/em> in a Slicer.<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-Settings.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-Settings.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Slicer-Styles-Settings.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select your\u00a0Slicer.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Styles &amp; Settings\"  class=\"alignnone size-full wp-image-6543\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-1.jpg\" alt=\"Slicer Styles &amp; Settings\" width=\"195\" height=\"484\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-1.jpg 195w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-1-121x300.jpg 121w\" sizes=\"(max-width: 195px) 100vw, 195px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Slicer Tools &gt; Options &gt; Slicer Styles<\/strong><\/em><\/p>\n<p>Select\u00a0a style you prefer<strong>.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Styles &amp; Settings\"  class=\"alignnone size-full wp-image-6544\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-2.jpg\" alt=\"Slicer Styles &amp; Settings\" width=\"797\" height=\"237\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-2.jpg 797w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-2-300x89.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-2-768x228.jpg 768w\" sizes=\"(max-width: 797px) 100vw, 797px\" \/><\/a><\/p>\n<p>Your slicer\u00a0now has a different style!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Slicer Styles &amp; Settings\"  class=\"alignnone size-full wp-image-6545\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-3.jpg\" alt=\"Slicer Styles &amp; Settings\" width=\"192\" height=\"486\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-3.jpg 192w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Slicer-Styles-and-Settings-3-119x300.jpg 119w\" sizes=\"(max-width: 192px) 100vw, 192px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"5_Connect_Slicers_to_Multiple_Excel_Pivot_Tables\"><\/span><span style=\"color: #ff0000;\"><a id=\"section5\"><\/a>5. Connect Slicers to Multiple Excel Pivot Tables <\/span><a href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Normally when you insert an Excel Slicer it is only connected to the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/insert-a-pivot-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Table<\/a> that you are inserting it from.<\/p>\n<p>What about if you had multiple Pivot Tables from the same data set and wanted\u00a0to connect a Slicer to all of the Pivot Tables, so when you press a button all the Pivot Tables change?<\/p>\n<p>Well this is possible with the Report Connections (Excel 2013 &amp; 2016) \/ PivotTable Connections (Excel 2010) option within the Slicer. \u00a0This is how it is achieved:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Slicer-Connections.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Slicer-Connections.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Slicer-Connections.xlsx<\/span><\/a><\/p>\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> <strong>Create 2\u00a0Pivot Tables<\/strong> by clicking in your data set and selecting <strong><em>Insert &gt; Pivot Table &gt; New Worksheet\/Existing Worksheet<\/em><\/strong><\/p>\n<p><strong><span style=\"color: #0000ff;\">Setup Pivot Table #1:<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5117\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"392\" height=\"333\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1.png 392w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-01-1-300x255.png 300w\" sizes=\"(max-width: 392px) 100vw, 392px\" \/><\/a><\/p>\n<p><strong>ROWS:<\/strong> Region<\/p>\n<p><strong>VALUES:<\/strong> Sum of Sales<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-02-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5118\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-02-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"219\" height=\"264\" \/><\/a><\/p>\n<p><strong><span style=\"color: #0000ff;\">Setup Pivot Table #2:<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5119\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"400\" height=\"336\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1.png 400w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-03-1-300x252.png 300w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/><\/a><\/p>\n<p><strong>ROWS:<\/strong>\u00a0Customer<\/p>\n<p><strong>VALUES:<\/strong> Sum of Sales<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-04-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5120\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-04-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"239\" height=\"279\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> <strong>Click in Pivot Table #1 and insert a MONTH Slicer<\/strong> by going to <strong><em>PivotTable Tools &gt; Analyze\/Options &gt; Insert Slicer &gt; Month &gt; OK<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5121\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"530\" height=\"547\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1.png 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-05-1-291x300.png 291w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5122\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"460\" height=\"485\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1.png 460w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-06-1-285x300.png 285w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0<strong>Click in Pivot Table #2 and insert a YEAR Slicer<\/strong> by going to <strong><em>PivotTable Tools &gt; Analyze\/Options &gt; Insert Slicer &gt; Year &gt; OK<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5123\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"506\" height=\"551\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1.png 506w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-07-1-275x300.png 275w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-08-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5124\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-08-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"268\" height=\"208\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> <strong>Right Click on Slicer #1<\/strong> and go to <em>Report Connections(Excel 2013 &amp; 2016)\/PivotTable Connections (Excel 2010) &gt;<\/em> <strong><em>&#8220;check&#8221;<\/em> the<\/strong> <strong><em>PivotTable2<\/em> box<\/strong> and press <strong>OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-4629\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"437\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09.png 437w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-09-291x300.png 291w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-5125\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"373\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1.png 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-10-1-300x171.png 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> <strong>Right Click on Slicer #2<\/strong> and go to <em>Report Connections(Excel 2013)\/PivotTable Connections (Excel 2010) &gt;<\/em> <strong><em>&#8220;check&#8221;<\/em> the<\/strong> <strong><em>PivotTable1<\/em>\u00a0box<\/strong> and press <strong>OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-4631\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"289\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11.png 289w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-11-193x300.png 193w\" sizes=\"(max-width: 289px) 100vw, 289px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-4632\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"384\" height=\"212\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12.png 384w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/Slicer-12-300x166.png 300w\" sizes=\"(max-width: 384px) 100vw, 384px\" \/><\/a><\/p>\n<p>Now as you select each Slicer&#8217;s items, both Pivot Tables will change!<\/p>\n<p>Have a look at the following image and the tutorial below that to see\u00a0how this is achieved using Excel 2013:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Connect Slicers to Multiple Excel Pivot Tables\"  class=\"alignnone size-full wp-image-1880\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54.png\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" width=\"656\" height=\"619\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54.png 656w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/2015-11-03_15-54-54-300x283.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"6_Lock_The_Excel_Pivot_Table_But_NOT_The_Slicer\"><\/span><span style=\"color: #ff0000;\"><a id=\"section6\"><\/a>6.\u00a0Lock The Excel Pivot Table But NOT The Slicer!<\/span><a href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: left;\">Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format.<\/p>\n<p style=\"text-align: left;\">What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interactive and secure from Excel novices like your boss \ud83d\ude42<\/p>\n<p style=\"text-align: left;\">Here is how you can lock the Pivot Table but not the Slicers:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Lock-the-workbook-Unlocked.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Lock-the-workbook-Unlocked.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download unlocked excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Lock-the-workbook-Unlocked.xlsx<\/span><\/a><\/p>\n<\/div>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Lock-the-workbook-Locked.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/10\/Lock-the-workbook-Locked.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download locked excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Lock-the-workbook-Locked.xlsx<\/span><\/a><\/p>\n<p><span style=\"color: #0000ff;\"><span style=\"color: #000000;\"> (Password to unlock: <span style=\"color: #ff0000;\"><em>myexcelonline<\/em><\/span>)<\/span><\/span><\/p>\n<\/div>\n<p style=\"text-align: left;\"><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Click on a Slicer, hold the <strong>CTRL<\/strong> key and select the other Slicers<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-356.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Ultimate Guide to Excel Pivot Table Slicers\"  class=\"alignnone size-full wp-image-23253\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-356.png\" alt=\"The Ultimate Guide to Excel Pivot Table Slicers\" width=\"937\" height=\"414\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-356.png 937w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-356-300x133.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-356-768x339.png 768w\" sizes=\"(max-width: 937px) 100vw, 937px\" \/><\/a><\/p>\n<p style=\"text-align: left;\"><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Right-click on a Slicer and select <strong>Size &amp; Properties<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-357.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Ultimate Guide to Excel Pivot Table Slicers\"  class=\"alignnone size-full wp-image-23254\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-357.png\" alt=\"The Ultimate Guide to Excel Pivot Table Slicers\" width=\"557\" height=\"540\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-357.png 557w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-357-300x291.png 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<p style=\"text-align: left;\"><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Under Properties, <em>&#8220;<\/em><strong><em>uncheck&#8221;<\/em> the Locked box<\/strong> and press Close<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-358.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Ultimate Guide to Excel Pivot Table Slicers\"  class=\"alignnone size-full wp-image-23255\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-358.png\" alt=\"The Ultimate Guide to Excel Pivot Table Slicers\" width=\"285\" height=\"419\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-358.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-358-204x300.png 204w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p style=\"text-align: left;\"><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Go to the ribbon menu and select <strong>Review &gt; Protect Sheet<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-359.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Ultimate Guide to Excel Pivot Table Slicers\"  class=\"alignnone size-full wp-image-23256\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-359.png\" alt=\"The Ultimate Guide to Excel Pivot Table Slicers\" width=\"1059\" height=\"127\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-359.png 1059w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-359-300x36.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-359-1024x123.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-359-768x92.png 768w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/><\/a><\/p>\n<p style=\"text-align: left;\"><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> <em>&#8220;<strong>Uncheck&#8221;<\/strong><\/em> the <em>Select Locked Cells <\/em>and<em> &#8220;<strong>Check&#8221;<\/strong> the Select Unlocked Cells &amp; Use Pivot Table Reports<br \/>\n<\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-360.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Ultimate Guide to Excel Pivot Table Slicers\"  class=\"alignnone size-full wp-image-23257\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-360.png\" alt=\"The Ultimate Guide to Excel Pivot Table Slicers\" width=\"273\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-360.png 273w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-360-266x300.png 266w\" sizes=\"(max-width: 273px) 100vw, 273px\" \/><\/a><\/p>\n<p style=\"text-align: left;\"><strong><span style=\"color: #ff0000;\">STEP 6:<\/span> Enter a password<\/strong> (optional) and press <strong>OK<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-361.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"The Ultimate Guide to Excel Pivot Table Slicers\"  class=\"alignnone size-full wp-image-23258\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-361.png\" alt=\"The Ultimate Guide to Excel Pivot Table Slicers\" width=\"274\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-361.png 274w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/04\/Screenshot-361-267x300.png 267w\" sizes=\"(max-width: 274px) 100vw, 274px\" \/><\/a><\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-one-slicer-for-two-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Use One Slicer for Two Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ultimate-guide-excel-pivot-table-slicers\/\" target=\"_blank\" rel=\"noopener\">The Ultimate Guide to Excel Pivot Table Slicers<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/connect-slicers-to-multiple-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Connect Slicers to Multiple Excel Pivot Tables<\/a><\/li>\n<\/ul>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Free_Excel_Pivot_Table_Webinar_Training\"><\/span><span style=\"color: #ff0000;\"><a id=\"section7\"><\/a>Free Excel Pivot Table Webinar Training! <\/span><a href=\"#table_of_contents\"><i class=\"fa fa-arrow-up \" ><\/i><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you liked all the above cool Slicer tips, then you will love my free <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Pivot Table webinar<\/a><\/strong> where I show you more cool Slicer tricks, as well as various Pivot Table features like: Grouping, Year To Data Analysis, Variance Analysis and I will also show you how to create an interactive Excel Dashboard!<\/p>\n<p>Click below to join for free and learn all these cool Pivot Table features that will make you stand out from the crowd&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6203 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot.jpg\" alt=\"\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/530x300-Pivot-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" title=\"\"><\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel Slicer was first introduced in Pivot Tables in Excel 2010 for Windows and Excel 2016 for Mac. Pivot Table Slicers are a visual filter in the form of an interactive button. \u00a0There are several cool things that you can do with Pivot Table Slicer, like customize them, filter them, connect them to multiple Pivot [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":16574,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,23],"tags":[139,92],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6547"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6547"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6547\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/16574"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}