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

Professional Input Forms in Excel

  • 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.

Send Emails from Excel

  • 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...
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...
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...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Tutorial Details
Excel Function: AND(), PERCENTILE.INC()
Downloadable Files: Excel File
Similar Content
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...
Excel Forum