Excel: Excel 2013 Allows Slicers on Regular Tables

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


New in Excel 2013, you can filter a regular data set, provided you convert the data to a table using Ctrl+T first.

  1. Convert a regular data set to a table using Ctrl+T

    From the Table Tools Design tab, choose Insert Slicer. Select the fields for the slicers. Use the Slicer Tools Design tab to change the number of columns, colors, and so on.

  2. As you select from the slicers, the data set is filtered.

For more resources for Microsoft Excel