Home » Howto & Style » How to Add a Blank Item in a Drop-Down List in Excel | Add Blank as First Option

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

Written By Chester Tugwell on Thursday, Aug 26, 2021 | 09:00 AM

 
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. ------------------------