Inserting and Using Drop Down Lists in Excel

Aug 28, 2015 | General Interest, Office 365, Productivity, Tips and Tricks, Uncategorized

A helpful tool when working in Excel spreadsheets is the drop down codes. These can be used a variety of ways. For this example we’ll use a spreadsheet with names and address that we are tracking for how a customer was contacted.

In the Status column I want drop down choices for the following:

[list style=”bullet”][li]Direct Mail[/li][li]E-Mail[/li][li]Phone Call[/li][li]Face To Face[/li][li]No Contact[/li][/list]

Here’s how we’ll insert these choices.

1. First, you’ll add a new spreadsheet to your Excel workbook to hold your drop down choices. I named mine KEY.

2. Input your data for your drop down choices.

3. Go back to your main list spreadsheet and highlight all cells within the column you want the drop downs to be active in. For example, I’m using column A and titled it Status.

4. Go to the Data tab on the Ribbon and click Data Validation.

5. The Data Validation window will appear. In the first tab Settings, under Validation criteria, choose “List” under the Allow drop-down option.

6. A new box will appear called Source. This is where you will put the location of your Key.

7. Put your cursor in the Source field. Click on the KEY spreadsheet tab and then select your drop down codes. Click OK in the Data Validation window.

8. Now in your first spreadsheet in your Status column, you’ll see a drop down arrow next to the cell your cursor is in. Click on the drop down to select your choice. That’s your result!

Drop downs in Excel spreadsheets are immensely helpful if you need to reuse the same options many times and want to ensure consistency in data entry. We hope this tip helps!

Recent Posts

The Tempo of Cybersecurity

The Tempo of Cybersecurity

You are probably thinking to yourself, “oh great, another cybersecurity article”. I feel the same way sometimes, that I’ve become numb to the statistics, and I just want to go back to a time when we didn’t have to consider unscrupulous threat actors trying to take...

Co-Managed IT is NOT the Same as Managed IT

Co-Managed IT is NOT the Same as Managed IT

All too often, small business owners try to decide about IT investments without a complete understanding of the options available. One place where this confusion often shows up is when trying to understand the difference between co-managed IT services and managed IT...

The Role of IT Security for Small and Midsized Business

The Role of IT Security for Small and Midsized Business

Everyone knows that securing their business is important. This includes an understanding that securing private data, machines, and the network itself are of paramount importance. So why do so many companies neglect security or treat it as a distant afterthought during...