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


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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...
Tutorial Details
Excel Function: AND(), PERCENTILE.INC()
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course