Tag Archives: Error Alert

In-cell dropdown by Data Validation – Allow input NOT from a list

Posted on January 10, 2015 by MF

This is about a trick of using named range that includes a blank cell; which allows any input even the cell is with Data Validation that allows list. When you attempt to input anything other than what is restricted by Data … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 6 Comments