Excel 2013 Allows Slicers on Regular Tables
June 13, 2023 - by Bill Jelen
![Excel 2013 Allows Slicers on Regular Tables Excel 2013 Allows Slicers on Regular Tables](/img/excel-tips/2023/06/excel-2013-allows-slicers-on-regular-tables.jpg)
New in Excel 2013, you can filter a regular data set, provided you convert the data to a table using Ctrl+T first.
![The data used throughout this book (Region, Product, Date, Customer, Revenue, Profit, Sector), but formatted as a Table.](/img/content/2023/06/LE1497.png)
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.
![Three slicers for the data set: Region (arranged in 1 row with four columns). Then Sector (3 rows, 2 columns). Customer (2 columns and more than 7 rows... the figure cuts off the Customer slicer).](/img/content/2023/06/LE1498.png)
This article is an excerpt from Power Excel With MrExcel
Title photo by Clay Banks on Unsplash