Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linked pick list

Linked pick list

ResolvedVersion 2007

Mon 6 Feb 2012, 16:47 Delegate Jade said...

Jade has attended:
Excel Advanced course

Linked pick list

How do I create a linked pick list? For example, my first list is Region (e.g. Europe) but I want the next list to have only the countries in that particular region (e.g. UK, Spain etc etc).

Tue 7 Feb 2012, 10:26 Trainer Anthony said...

RE: Linked pick list

Hi Jade, thanks for your query. What you are trying to create is a dependent drop down using data validation. There are some good walkthroughs here:

http://www.contextures.com/xldataval13.html

http://www.ozgrid.com/Excel/dependent-lists.htm

Hope this helps,

Anthony

Mon 13 Feb 2012: Automatically marked as resolved.

Excel tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Linked pick list

Linked pick list

RE: Linked pick list

Excel articles

Excel tip:

Create and delete borders