Custom Data Views Controlled by a Drop Down Menu in Excel

Download Project Files
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

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Excel Function: AND(), PERCENTILE.INC()
Excel Version: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

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...
Quickly Reset All Form Controls in a Worksheet in Excel
Tutorial: How to reset all Form Controls on a worksheet in Excel with the click of a button or two ...
Always Visible Drop Down Arrow in Excel
Tutorial: How to make a data validation drop-down list arrow that is always visible in Excel. This ...
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...
Tutorial Details
Excel Function: AND(), PERCENTILE.INC()
Excel Version: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use
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