Custom Data Views Controlled by a Drop Down Menu in Excel
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
Question? Ask it in our Excel Forum
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.)
Tutorial: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...
Tutorial: How to reset all Form Controls on a worksheet in Excel with the click of a button or two ...
Tutorial: How to make a data validation drop-down list arrow that is always visible in Excel. This ...
Tutorial: I'll show you how to make a drop down list menu in a cell in Excel. This allows you to ha...
Tutorial: Quickly make data validation drop down lists (menus) in Excel. This method is simple, onl...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
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.)