Here's how you can create a dependent drop-down list in Excel: 1. Create your first drop-down list using Data Validation. Select the cells where you want the drop-down list to appear, then go to …

Aug 28, 2021 · Hi, I'm trying to create a drop-down list with various headers in Excel. I know how to create a standard drop-down list using a table on a separate worksheet, that's rather easy. …

Mar 29, 2024 · The Column B drop down is dependent on Column A, so if I have selected 'Accommodation', I then want the Column B drop down to be Hotel 1, Hotel 2 etc etc. Likewise, …

Jan 27, 2025 · Create the Drop-Down List: Select the cell where you want the drop-down list. Go to the Data tab and click on Data Validation. In the Allow box, select List. In the Source box, …

May 6, 2014 · Then select the cell(s) that you want the drop-down to appear in, and go to the Data tab on the Ribbon. Click on Data Validation, select Data Validation... and then pick "List" …

Apr 1, 2024 · 2. Create the Drop-Down List: - Select the cell where you want the drop-down list to appear. - Go to the "Data" tab on the Ribbon. - Click on "Data Validation". - In the "Settings" …

Jun 27, 2013 · Can you create a drop down list that has pictures rather than text and repeat it over multiple rows. I want to create a spreadsheet that shows the picture and then can state how …

Jul 24, 2017 · I am trying to make it easier to use the "status" column by creating a drop down list that would apply to every cell in that column. That way, when anyone updates the spreadsheet …

Nov 9, 2017 · I created a drop down list, but I want it to function so that when you select from it, it displays something else. For example: If the dropdown list contained the names of the states, I …

May 23, 2024 · Yes. You need to create all your named ranges, then create a list of the named ranges (which you can name, say, ModList). Apply Data Validation to a cell - say, C1 - using …