Tag Archives: Error Alert

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

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