Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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 -  ddalgleish@contextures.com

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:

  • New Book: Even You Can Learn Statistics and Analytics, by David M. Levine and David F. Stephan. "practical, up-to-date introduction to statistics...updated for "big data" analytics and the newest applications...Simple jargon-free explanations help you understand every technique...updated for the newest versions of Microsoft Excel. You'll find downloadable practice files, templates, data sets, and sample models – including complete solutions you can put right to work! "

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:

  • save and apply preferred pivot table settings
  • format all the data fields at once
  • change all the data fields from the Count function to the Sum function.

It makes a lovely Christmas gift too! ;-)

________________________

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

 

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright ©2014
All rights reserved.