Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Drop Down list in Excel
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have dropdown list of Colleges in Colum A. I want Colum B to be a dropdown list of courses but as there are hundreds I want the dropdown options in column B to reflect the option chosen in Colum A. So if College X is selected in Colum A then the dropdown in B shows only the courses In College X. If College Y is selected then Column B would only show courses in Colle Y etc. Any help gratefully appreciated
Microsoft 365 and Office | Excel | For business | Other
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
1 additional answer
Sort by: Most helpful
-
Anonymous
2024-08-21T10:15:17+00:00 many thanks for this - ive successfully completed task