If you’ve ever encountered a drop down list in Excel that contains blank entries/cells, you know how frustrating it can be. Fortunately, there is an easy way to remove these blank entries from your drop down list. In this article, we’ll discuss how to easily remove blank entries/cells from Excel’s drop-down list.
Answer in Text
The first step is to select the range of cells that contain your drop down list. To do this, click and drag your mouse to choose the range of cells. Then, click the “Data” tab in the ribbon and select “Data Validation.”
Next, click the “Settings” tab and select “List.” In the “Source” box, enter the range of cells that contain your drop down list. Then, click the “Ignore Blank” checkbox. This will exclude any blank entries/cells from your drop down list.
Finally, click “OK” to save your changes. Your drop down list should now remove blank entries/cells.
Removing blank entries/cells from a drop down list in Excel is a simple process that can save you a lot of time and frustration. With just a few clicks, you can easily remove any blank cells from your drop down list and ensure that only valid entries are included.
Answer With Images: 2 Ways
First Way
1. To begin, pick the data from which we wish to delete blanks.
2. Right-click > Sort > Sort A to Z
3. Result
Second Way
1. Select The List
2. Then choose Go To Special…. Go to the Home tab, look to the right, and then click the Find & Select button to see this option.
3. Choose the Blanks option from the box that appears and press OK.
4. You will notice just the empty cells have been chosen.
5. Now, right-click a chosen cell that will be blank and choose Delete.
6. Then select Shift cells up:
7. Result