Short drop down list + more Excel tips

Excel Weekly News from Contextures December 09, 2014

In this week's Excel news, you'll see how to show specific items in a drop down list, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

 -  Debra -

Short Drop Down List

If you've got a long list of items, it can be hard to find what you're looking for, in a cell's drop down list. For example, in a product list, you'd have to scroll way down to the bottom, if you want to find an item whose name begins with "T". And you have to remember the exact name of the product you're looking for!

To make it easier to find things, I've created a new sample file that you can download. Type a couple of letters in column B, and the list will only show items that contain those letters.

Click here to see the details: Short Drop Down List

Excel Holiday Planner

The holidays are just around the corner, and if you need to buy gifts, plan parties, organize the holiday dinner, or other tasks, you can use a spreadsheet to help with the planning. There is a free holiday planner on my Contextures website, and you can download it, and fill in your own tasks and gift ideas.

Click here to get the details, and download the free planner: Excel Holiday Planner

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

Video: Enter Data With a Built-In Form

Use Excel's built-in Data Form to make it easier to enter data in a list. It will display a maximum of 32 fields.

The form is a menu command in Excel 2003, and in Excel 2010, you can add the command to the Quick Access Toolbar. Watch this short video tutorial to see the steps for adding the command, and using the data form.

Cars and Lanterns

One of our newest Christmas traditions is an advent gift bag, for the grandkids. We find little gifts at the dollar store, wrap them all up, and put a number on each gift. They can open one gift a day, until Christmas Eve. It spreads out the fun over the entire month, and costs about the same as one bigger gift.

My granddaughter wanted cars, and my grandson likes to "go camping" (usually under the kitchen table), so these are a couple of the gifts they'll get this year.

Featured Excel Product

I'm working on a new version of my PivotPower Premium add-in, and will release it in the next few weeks. If you buy the current vrsion, you will automatically get the update, when it is released, and you will avoid the price increase.

The PivotPower Premium add-in saves you time and effort, when working with Excel pivot tables. For example, you can quickly:

It makes a lovely Christmas gift too! ;-)

See more recommended Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright ©2019
All rights reserved.