RSS Feed

Excel 2007 Dropdown Boxes

Posted on


In this post I decided to provide a tutorial on how to add a dropdown box in Microsoft Excel 2007.  It’s incredibly easy and takes just a few seconds.  I love this feature because I go NUTS when data isn’t consistent throughout a spreadsheet, so this dropdown box allows you to limit the options someone has to enter into your spreadsheet.

1.  Open Microsoft Excel 2007

2.  Type your “Key” with the options that you would like to use for the dropdown box

3.  Highlight the area you’d like to apply the drop down box to

4.  Go to the Data tab at the top

5.  Click the Data Validation portion and pull down the options

6.  Again, hit Data Validation

7.  In the “Allow” portion, choose “List”

8.  Click in the “Source” portion then highlight your Key

9.  Hit OK and Voila!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: