List Slicer Selections in a Cell in Excel

Add to Favorites
Author: | Edits: don

How to list all slicer selections for a Pivot Table in a single cell in Excel.

This allows you to make a nice interface and better integrate the usage of slicers and filters into your worksheets.

You will also be able to show slicer selections on whichever worksheet you want; the slicer itself and even the pivot table can be on separate, or even hidden, worksheets. This allows you to have a high level of flexibility.

Pivot Tables and slicers are amazing, but also can be quite complex - this tutorial combines a few simple tricks to get the desired result, and it should be easy for anyone to follow.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allows...
Show All Formulas in a Worksheet in Excel
Tutorial: Display all formulas instead of their output values. This allows you to quickly troubles...
Loop through a Range of Cells in a UDF in Excel
Tutorial: How to loop through a range of cells in a UDF, User Defined Function, in Excel. This is ...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
Macro: Add data validation input messages to cells in Excel with this free Excel macro. These mes...
How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel
Tutorial: In this tutorial I am going to cover inserting and editing Shapes in an Excel workbook, as...