Dropdowns in Excel Part 1

What is a dropdown?

I’m 100% sure most of you reading this post, know what a dropdown is. We interact with hundreds of websites and user forms every day. Dropdowns are such a beautiful user interface objects, that they make the lives of the user and the one who creates the form much happier. It reduces the pain of typing something in the box for the user and the pain of resolving inconsistencies in the data for the form creator. Let it be choosing the person title (Mr./Ms./Mrs.) to choosing the city you’re from to anything under sun. Let me start with the very basic things in this post, which many of you might already know. But I’ll slowly come to the very interesting ones in the subsequent blog posts.

How is dropdown useful in Excel?

Excel is unarguably one of the best data entry software and the most widely used across the fields and by a cheap viagra wide range of people.

From a user perspective, when I’m entering a number of rows of data, it’s difficult for me to type the text in a particular column every time I create a new row. Let’s say I am entering the transactions happening in a vegetable stall. Then I need to type the name of the vegetable every time a transaction happens, number of Kilograms the customer took, the amount he/she paid etc. And when I’m analyzing at the end of the month to understand the sales of each vegetable, I will have to add new vegetables to the dictionary,

I don’t make these mistakes because I don’t know how to write a simple word “Tomato”; but while entering loads of data I tend to make small mistakes, which will trouble me a lot at the end. So, a dropdown is inarguably one of the most useful data entry elements in Excel.

How to create a dropdown list in Excel?

There are multiple ways in which you can create a dropdown list in Excel.

But of these methods, Data Validation is the most used method, for its simplicity. Later on, I’ll explain the pros and cons of each method, so that you can choose the best method among these for you.

Creating a dropdown list in Excel through Data Validation

Before going to explain how to create a dropdown list, let me tell you what a Data Validation is? It controls the type of data or the values that users enter into a

online canadian pharmacy viagra

cell. For example, you may want to enter only positive values in a cell, only ‘time’ in a column, or a text below the specified length. You can define all these conditions through Data Validation. Even dropdown list is a data validation where you’re constraining the user to use only those set of words in that cell. Again, in creating a dropdown list through data validation, there are different ways in doing it. Here are those…

Writing the complete list in the Source Field

1)  Select the Cell (or) set of Cells in which you want to see the dropdown.
2)  Go to “Data” Tab –> Data Validation –> Data Validation
3)  Select List in the “Allow box”
4)  Just enter the names you want to see in the dropdown list in the “Source” Box

Dropdown in excel through Data Vaidation

That’s it!!! Go to the cell for which you created validation. Click on the dropdown button, you’ll be able to see the names of the vegetables you’ve entered.

Excel Dropdown Names in the Source Field

Selecting a list of items in the same or other sheet

In the aforementioned example, instead of entering the names in the source field, you can choose a list which is already entered in the same or different excel sheet.

The best advantage of this method is, if you remove the vegetable name ‘Carrot’ from the list and replace it with ‘Lady Finger’, it will automatically update the list without your intervention. The only problem with this method is, if you append an item to this list at the end, it won’t get reflected in the dropdown.

Selecting a List of Items from the Same or Other worksheet

Using Dynamic Defined Names

1)  Select the list you want to be shown in the dropdown
2)  In the Name Box which is beside the formula bar, enter the name and click ENTER
3)  That will name the selected table as written in the “Name Box”
4)  In the Source Field, write “=” followed by the Table Name you’ve selected

There it is! You’ve created a dropdown!! It’s as simple as that!

“Is that all about dropdowns?”

“No! Please wait a moment!”.  This is just the beginning and it’s going to get more interesting in the next posts in this series. I will be back with a post on Friday and till then adieu.

[Bloglines] [del.icio.us] [Digg] [diigo] [Facebook] [Furl] [Google] [kirtsy] [Ma.gnolia] [MySpace] [Propeller] [Reddit] [Simpy] [Sphinn] [StumbleUpon] [Technorati] [Windows Live] [Yahoo!]


  • By Martin, October 3, 2012 @ 5:16 pm

    Maybe basic to you, but very useful to me as I am just starting to find my way around Excel. Many thanks :)

  • By 100% RESIDUAL COMMISSIONS!, October 9, 2013 @ 12:32 am

    Discover how you can collect
    on an industry leading marketing tool
    suite that includes:
    • Leading Autoresponder service
    • Amazing conference software
    • Top notch video email service
    • Amazing lead capture system
    • Get this complete suite of profit pulling tool and training for ONLY $24.95 per month!
    Go To:>> http://www.pureleverage.com/launch/3?id=gandd

  • By shereen, November 26, 2013 @ 10:22 am

    Data Synergo provides services that drive results in customer management cycles. An innovative provider of marketing services, we provide practical solutions for bridging the business relationship between clients and their customers. Our services support customer management activities such as demand generation, lead qualification, customer acquisition and retention, event management, data analysis.

  • By design and drafting, March 12, 2014 @ 11:08 pm

    I will apply and practice it..very interesting and information. It keeps me motivated.

  • By Michaela, March 31, 2014 @ 3:38 pm

    good description! I understand it well. @ all guys: If you have problems with some functions in excel, help yourself with the following website: http://www.excel-aid.com/excel-font-changing-font-font-style-font-size.html It show you step by step how you have to work all of the functions, which maybe have not known.

  • By gerson juicer, February 25, 2015 @ 6:26 am

    Pimms is Cap Jaluca’s award winning restaurant and holds its weight in ambiance and outstanding cuisine amongst the finest in the Caribbean. To take
    hold of this gentle wisdom and to remember that if I let go and be held by Mother Nature’s ebb and
    flow that I too will be brought back to pools of stillness.
    Of course, the traditional winter recipes work well too and the
    advantage for me of having a large slow cooker for our small family is that I can double the quantities and
    make two meals, one of which I can freeze for another

  • By hurtig lån, July 24, 2015 @ 9:13 pm

    May I simply just say what a relief to find someone who really knows what they’re discussing on the internet. You definitely realize how to bring an issue to light and make it important. More and more people need to look at this and understand this side of the story. I was surprised you’re not more popular since you most certainly possess the gift.

  • By Ruthie, September 26, 2015 @ 8:12 pm

    Excellent article, thanks and we want more! Added you to FeedBurner.

  • By netticasinopelit.org, October 9, 2015 @ 9:25 pm

    Helpful information. Lucky me I discovered your site by chance,
    and I’m surprised why this coincidence didn’t came
    about in advance! I bookmarked it.

  • By weight training shoes, November 30, 2015 @ 12:23 pm

    It will be an adhere to along book where the user can do the very same diet regimen as well as
    workout regimens also.

  • By Dianne, December 4, 2015 @ 6:11 am

    Sony tends to make electronics, sure, but under they make TVs,
    the PlayStation, smart phones, laptop computers, as well as on. Any business can create playlists with their various products to help YouTube audiences who will be looking information on certain products.

  • By gamil, December 15, 2015 @ 11:37 am

    Adding a calendar to your web page has not been easier.

  • By Harriet, December 15, 2015 @ 2:46 pm

    Specifically without Potions it´s onerous to attain a new Excessive Rating on Swamp Attack hack!

  • By design, January 8, 2016 @ 11:24 am

    Thank you for another informative site. The place else could I
    get that kind of info written in such a perfect means? I have a venture that I’m simply now running on, and I have been on the look out
    for such information.

  • By hamster home, January 8, 2016 @ 3:47 pm

    Thank you for some other great post. The place else may
    just anybody get that type of information in such a perfect means of writing?
    I’ve a presentation subsequent week, and I am at the look for such information.

  • By chatter.kyofun.com, March 7, 2016 @ 8:41 pm

    Hi, I do believe this is a great website. I stumbledupon it ;) I will come bafk nce aggain sinjce I book-marked it.
    Money and freedom is the greatest way to change,may you
    be rich and continue to help other people.

  • By m88, March 17, 2016 @ 6:19 pm

    We ultimately met and after attending to know each other, she invited me
    to take part and speak at her 2015-Final Triathlete Coaching Camp” at the National Training Middle
    in Clermont, FL. The coaching camp was quite comprehensive,
    technical and a number of enjoyable. I learned lots as a triathlete and began to see how way more technical and particular training for a triathlon may be.
    There was a ton of cycling, swim coaching and operating within the mornings and lectures within the

  • By android apk apps, March 22, 2016 @ 4:24 am

    Becoming an affiliate marketing advertiser is straightforward to do when the write mechanical on line blueprints
    are put write prior to you android apk files delete and of one of the most violent
    gameplay ever use a disk android apk games cracked it’s a duty I’ve taken heed of for
    in the marketplace seventeen growth cycles
    Android Apk Files Free Download Withdraw those unused Mathematics books android
    apk apps cracked

  • By Lukas, March 29, 2016 @ 3:11 am

    You might think the email is funny and may the recipient?

    Ask in advance if they wish to receive jokes etc android apk files cracked Anyone have don’t attend to
    this and have got second grade curriculum in there android
    apk games rpg It becomes much easier ideal when you start searching on those books only android apk files delete unlike gloves can easily
    be located at the local dollar site android apk download Thinning is also used to open up framework of
    to obtain to make a more ideal form android apk download

Other Links to this Post

RSS feed for comments on this post. TrackBack URI

Leave a comment