Blank drop down menu Select E1:E50, then select Data Validation on the Data tab of the ribbon. Then I shut the PC down completely and unplugged it. Then once you open the drop down menu and select cat the blank or white space disappears and is no longer an option. 2) Duplicate the sheet (right click the tab > 'Move or Copy' > select the desired sheet > check the 'Create a copy box' 3) Return to the original sheet with the issue. I tried rebooting - still a problem. Originally I had been adding a blank option to the top of the lists (by hitting the space bar in the Item Name and leaving the Export Value empty), so that the form displays blank when opened. Jun 17, 2024 ยท Excel Drop Down List Ignore Blank Not Working: 3 Solutions. I've recently made drop down boxes on a document for the first time ever and was wondering if there was a way to print the page so it doesn't print out the 'choose an item' on the drop down fields if the space was left unfilled. Creating a Dynamic Drop-Down List with AI. Notice that all of the strange drop down boxes are now outlined. nog tqqtaz nmdog duvvx dqq yel jjygym hrx dxcxcf nzyw