{"id":1943,"date":"2015-11-12T22:00:38","date_gmt":"2015-11-12T21:00:38","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1943"},"modified":"2024-02-06T15:46:12","modified_gmt":"2024-02-06T14:46:12","slug":"excel-table-slicers","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-table-slicers\/","title":{"rendered":"Excel Table Slicers"},"content":{"rendered":"<p>Slicers were introduced with <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a> in Excel 2010 and they allowed us to select items to filter with beautiful interactive buttons.<\/p>\n<p>You can see the power of Slicers and the different ways you can format them in these posts:\u00a0<span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/slicers\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/slicers\/<\/a><\/span><\/p>\n<p>In Excel 2013, Slicers have been extended to be used with\u00a0Excel Tables. \u00a0WOW!<\/p>\n\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/YzuH7yihvAI?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><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<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle 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><br \/>\n<span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Table-Slicers.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Table-Slicers.xlsx<\/span><\/a><\/span><\/p>\n<p><strong>To insert a Slicer in an Excel Table<\/strong> you have to follow these short steps:<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Click inside the Excel Table<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table Slicers\"  class=\"alignnone size-full wp-image-19505\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-01.jpg\" alt=\"Excel Table Slicers\" width=\"752\" height=\"430\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-01.jpg 752w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-01-300x172.jpg 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Select <strong><em>Table Tools &gt; Design &gt; Insert Slicer<\/em><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table Slicers\"  class=\"alignnone size-full wp-image-19506\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-02.jpg\" alt=\"Excel Table Slicers\" width=\"812\" height=\"172\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-02.jpg 812w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-02-300x64.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-02-768x163.jpg 768w\" sizes=\"(max-width: 812px) 100vw, 812px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span><strong>Tick the Table Headers<\/strong> that you want to include in your Slicer and press<strong> OK<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table Slicers\"  class=\"alignnone size-full wp-image-19507\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-03.jpg\" alt=\"Excel Table Slicers\" width=\"236\" height=\"443\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-03.jpg 236w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-03-160x300.jpg 160w\" sizes=\"(max-width: 236px) 100vw, 236px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>You can update the look and feel by going to<em><strong> Slicer Tools &gt; Options &gt; Slicer Styles<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table Slicers\"  class=\"alignnone size-full wp-image-19508\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-04.jpg\" alt=\"Excel Table Slicers\" width=\"997\" height=\"635\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-04.jpg 997w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-04-300x191.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-04-768x489.jpg 768w\" sizes=\"(max-width: 997px) 100vw, 997px\" \/><\/p>\n<p><strong>Click on the Slicer buttons<\/strong> and see how your Excel Table gets filtered without needing to select the filter drop down.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Excel Table Slicers\"  class=\"alignnone size-full wp-image-19509\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-05.jpg\" alt=\"Excel Table Slicers\" width=\"966\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-05.jpg 966w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-05-300x123.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/11\/Excel-Table-Slicers-05-768x316.jpg 768w\" sizes=\"(max-width: 966px) 100vw, 966px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1080 size-full\" style=\"display: none !important;\" hidden=\"\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/03\/728x90.gif\" alt=\"728x90\" width=\"728\" height=\"90\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Slicers were introduced with Pivot Tables in Excel 2010 and they allowed us to select items to filter with beautiful interactive buttons. You can see the power of Slicers and the different ways you can format them in these posts:\u00a0https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/slicers\/ In Excel 2013, Slicers have been extended to be used with\u00a0Excel Tables. \u00a0WOW! \ufeff Download [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17285,"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":[6,23,36],"tags":[88,97,92],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1943"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1943"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1943\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17285"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1943"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1943"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1943"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}