Excel 2013 Allows Slicers on Regular Tables

June 13, 2023 - by Bill Jelen

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. — Figure 1145. 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.

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). — Figure 1146. As you select from the slicers, the data set is filtered.

This article is an excerpt from Power Excel With MrExcel

Title photo by Clay Banks on Unsplash