Cascading Drop Downs in Excel

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
5,310
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jun 17, 2011

Use data validation to create a drop down list whose values are defined by a what is selected in another drop down list.

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (5)

Sign In or Sign Up now to post a comment!
  • tried this but the row below does not work...

  • You can name lists by clicking on the column letter and name it in the namebox on the left.

    This way you don't have to select cells to define lists, all cells that contain data in that specific column will be in you dropdown menu

    In data validation > lists > source, press the F3 key and all the named lists will show up.

  • @IfrahSaeed9

    yes, see  /watch?v=-78bH0RZ7MA

  • Is there any way, we can populate locations under Location with names having spaces in them..i.e United States?

    

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more