This exercise will explain to you how to create a dropdown list in a cell.
ARTICLES LES PLUS VUS
- Displaying Negative Numbers in Parentheses – Excel (270,356)
- The 10 most useful Excel Functions in 2023 (198,717)
- How to make automatic calendar in Excel (169,318)
- Dash for a zero in Excel (138,803)
- Convert YYYYMMDD to DD/MM/YYYY with Excel (123,854)
- Date Format in Excel (119,568)
- Excel Split Date and Time (97,642)
- How to calculate VAT in Excel? (93,334)
- Function XLOOKUP in Excel (87,986)
- Exchange rate in Excel (86,787)
- UNIQUE Function – Remove duplicates with formulas (73,020)
- Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde (68,487)
- Comma or Semicolon in an Excel formula (64,030)
- Add Emojis to your Excel charts, formulas (63,933)
- How to Compare 2 Columns in Excel (58,512)
- Change the default Date format in Excel (57,421)
- SUMIFS Function in Excel (50,670)
- COUNTIFS – Count rows automatically in Excel (48,156)
- Dynamic SUM in Excel (47,839)
- Add filter option for all your pivot table columns (47,592)
- How to display hours over 24 in Excel? (41,526)
- Anonymise your data (38,517)
- First day – Last day in Excel (35,216)
- Round to the Nearest Tenth, Hundredth with Excel (33,945)
- Find Weekend or Weekday in Excel (32,157)
- Title with date in Excel (31,265)
- Population Pyramid with Excel (30,882)
- XLS vs XLSX file format? (30,661)
- How to Link Excel to Google Maps (28,203)
- VLOOKUP to the left in Excel (28,115)
Excercise for beginners: Create a drop-down menu
This quiz must be completed in 10 minutes. Click here to start the quiz

Recent Posts
- Write Months in Excel in a Foreign Language
- How to display Months in Letters in Excel?
- WordPress shortcuts, Improve your Productivity
- Calculate the Number of Days between 2 dates in Excel
- The WEEKDAY function – Secrets and Errors
- Move to a specific column with this free Add-in
- Excel formula to Extract the Worksheet Name
- Move cells with the mouse in Excel (Easy Guide)
- How AI can be used in Excel for your data?
- Build a nested IF in Excel
- Return a result between 2 values
- Add progress bar in your cells
- Copy the formula and not the formatting in Excel
- How to Highlight Min and Max values in Excel
- Excel Dropdown list – Excluding Previously Selected Items