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

(35% Sale Ends Jan. 26)

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 (35% Discount)

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

(35% Sale Ends Jan. 26)

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 (35% Discount)