Custom Data Views Controlled by a Drop Down Menu in Excel

Add to Favorites
Author: | Edits: don

This trick allows you to easily perform a nice visual analysis of data in Excel without much effort.

Highlight table values that meet a certain criteria and hide the rest and control this from a drop down menu in Excel.

This is a great way to evaluate a large data set, identify trends, or just spruce things up and add a nice effect to your worksheet.

Multiple features will be combined to achieve this result, including:

  • Custom conditional formatting.
  • Hide values in cells.
  • Use Percentile to identify values that meet certain thresholds.

More Resources

Percentile Function Excel

Conditional Formatting Excel


Excel Function: AND(), PERCENTILE.INC()
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
Multi-Column ComboBox Drop Down Menus in Forms
Tutorial: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...
Make a Drop Down List Menu in a Cell in Excel
Tutorial: I'll show you how to make a drop down list menu in a cell in Excel. This allows you to ha...
Make Quick Lists for Drop Down Menus - Save A LOT of Time
Tutorial: Quickly make data validation drop down lists (menus) in Excel. This method is simple, onl...
Make Dates from Drop Down Lists in Excel
Tutorial: How to use a drop down list (data validation) to create a date in Excel. This technique c...
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...