How to Make a Drop Down Menu in Excel (plus Formatting and Formulas)
Source: https://spreadsheetpoint.com/excel/dr...
How to Create a Drop Down Menu in Excel & Use Formulas
In this video, you'll learn how to create drop down menus in Excel and use them within formulas. Step-by-step, you'll see how to set up a simple table, add drop down menus using both manual entry and cell range selection, and implement IF statements to validate answers. Additionally, the video covers how to use conditional formatting to visually highlight correct and incorrect answers.
00:00 Introduction to Creating Drop Down Menus in Excel
00:11 Setting Up Your First Drop Down Menu
01:36 Creating a Drop Down Menu with a Range of Values
02:56 Writing Formulas Based on Drop Down Menu Selections
04:10 Adding Conditional Formatting Based on Responses
05:35 Conclusion and Final Tips
As always, please let me know if you have any questions in the comments. I'm always happy to help!
Note that I also covered how to make dependent drop down lists in Google Sheets: https://spreadsheetpoint.com/dependen...
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/
#GoogleSheets #GoogleSheetsTips #Spreadsheet