Search Contextures Sites
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 - firstname.lastname@example.org
- Short Drop Down List
- Excel Holiday Planner
- More Excel Tips
- Excel Announcements
- Video: Enter Data With a Built-In Form
- Weekly Photo: Cars and Lanterns
- Featured Excel Product
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
- After the recent file hacking at Sony Pictures, Melanie Pinoa reminds you that you shouldn't store all your passwords in an Excel file.
- Jordan Goldmeier takes a look at complicated Nested IF formulas, and when you should use them.
- Gašper Kamenše shows how to highlight the smallest and largest amounts in a column chart.
- Ben Orlin uses his bad drawings to explain multiplication and arrays. It might help your kids (or a co-worker), if they're struggling to understand how Excel calculates things.
- Chandoo shows how to include markers for average or a target, in an in-cell chart.
- Are your columns clean? Zack Barresse explains the difference between clean and dirty columns in an Excel table.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. And vote for your favourite!
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! "
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.
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.
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.
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.
Contextures Inc., Copyright ©2014
All rights reserved.