I love using drop down lists in Excel. In this article, I’ve tried to explain all of the techniques that I use for making drop-down lists, including simple yes/no options, checkbox substitutes, dependent lists for sub-categories, and using dynamic named ranges.
We mainly create templates, but we also write about general Excel topics to help you get more out of Excel and more out of our templates. Learn how to create drop-down lists, sparklines, and new charts in Excel 2016.
In addition to the blog posts below, check out our list of Excel Articles, especially our article about Theme-Enabled Templates which allow you to customize the colors and fonts in our templates with just a couple clicks of the mouse.
As an alternative to Power Map or 3D Maps, learn how to create a geometric heat map in Excel using shapes and a simple VBA macro.
20 Excel experts share their lists of favorite Excel functions. If you want to get more out of Excel, try using these functions in your work.
A one-stop reference for using Unicode character symbols in Excel, including ways to insert symbols and how to use them in drop-down lists, number formats, etc. Also includes tables of newer Unicode symbols.
One of the best ways to learn new techniques in Excel is to see them in action. This post demonstrates how to add some fun and useful features to simple to do lists, including drop-down lists, check boxes, and progress bars.
Microsoft Excel 2016 has brought us six new built-in chart types: Waterfall, Histogram, Pareto, Box & Whisker, Treemap, and Sunburst. The addition of these new charts is largely due to user feedback and requests. This Page (contents): The Waterfall Chart [...]
The authors at Vertex42.com have created a workbook that demonstrates over 140 essential Excel tips and tricks.
Sparklines are little in-cell charts that can help you analyze your data. This article shows examples of the three types of sparklines available in Excel 2010 and 2013.
Learn how to create a drop-down list to select the next date or next check number when updating lists of transactions or adding log entries.
If you use an invoice or order form in Excel routinely, you may come across times when it would be handy to select items from a drop-down list and have other information update automatically. Here is an example.
PDF files have been around for a long while now and there is a reason they only increase in popularity – they make sharing documents with others a breeze. Created exactly for this purpose in 1993 by Adobe Systems, the [...]