Excel Drop-downs and Wildcards
I just found out that Excel’s in-cell drop-downs via Data Validation allow wildcards characters that match an entry in the list. Wildcards combinations that don’t match are rejected.
(more…)Ensure a Single Check Box Selection
Check boxes are supposed to be used to allow multiple selections. But since they are now so easy to insert, you might want to use them to allow a single selection. Here’s one way to do that.
(more…)Excel Data Validation Based on Another Cell
I recently had a question on an old blog post about limiting a cell’s entry to returning a whole number based on a calculated value. The requirement was entering a quantity that was a multiple of a carton quantity.
(more…)Excel Drop Down Improvement
In previous versions of Excel when you had a drop-down list that contained duplicates those duplicates would show up in the drop-down list. This has been fixed in the latest versions of Excel. The duplicates are now removed.
(more…)Display an Excel Pop-up Message Without a Macro
Would you like to display a pop-up message when a user enters a value into a cell? You don’t need a macro to achieve this.
(more…)Time to Play with Dynamic Arrays
Many things that were hard or complex are now much simpler. Creating dynamic drop down lists based on previous selections used to be tricky in Excel. Dynamic arrays make it straightforward.
(more…)Validating Data Validation in Excel
The most common type of Data Validation in Excel is a drop down list. In the example below I allow the user to select a year, then a month (using a drop down) and then enter a valid day in the month. (more…)
Simple Excel Drop Down List
A drop down list in Excel can help speed up data input and ensure the user has entered a valid entry. If you have only a few choices, creating the drop down can be a quick process. (more…)