How to Add a Blank Item in a Drop-Down List in Excel | Add Blank as First Option

Microsoft Excel Tips and Tricks

In this video, I demonstrate how to add a ‘blank’ option to a data validation drop-down list in Excel. The ‘blank’ option can appear in any position in the drop-down list, but in this demonstration ‘blank’ appears as the first option.

Credit Chester Tugwell