How to Add Drop Down Lists in Excel
Source: https://spreadsheetpoint.com/excel/dr...
To add drop down lists in Excel, use the data validation menu. I'll also cover how to remove these drop down menus and how to choose an existing range to automatically add options to your menu.
00:00 Intro
00:08 How to Add a Drop Down List in Excel
00:39 How to Remove Drop Down Lists
00:48 How to Select a Range for Drop Down Menu Options
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