Skip to content
excelkeys

Excelkeys

  • Home
  • Privacy Policy
  • About Us
  • Contact Us
  • Most Used Functions
  • Excel
  • Toggle search form

How to Remove Blank Entries/Cells From a Drop Down List in Excel?

Posted on February 10, 2023February 10, 2023 By Excelkeys No Comments on How to Remove Blank Entries/Cells From a Drop Down List in Excel?

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.

Table of Contents

  • Answer in Text
  • Answer With Images: 2 Ways
    • First Way
    • Second Way

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.

select-data

2. Right-click > Sort > Sort A to Z

sort A 2 Z

3. Result

remove-blanks

Second Way

1. Select The List

select-data

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:

Shift-cells-up

7. Result

remove-blanks

Excel

Post navigation

Previous Post: How to add a comma after the first word in each cell?
Next Post: How to Repeat Last Action in Excel?

Related Posts

How to add a comma after the first word in each cell? Excel
Duplicate Formula of Excel: How to Find and Remove Duplicate Entries Excel
How to Repeat Last Action in Excel? Excel
How to Use Vlookup Function in Excel? A Complete Guide Excel
Main Features of Excel Excel
What is Excel? Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • How to Repeat Last Action in Excel?
  • How to Remove Blank Entries/Cells From a Drop Down List in Excel?
  • How to add a comma after the first word in each cell?
  • How to Add a Blank Option to a Drop-Down List in Excel?
  • How To Convert, Increase, Decrease, or Change Numbers to Percentages in Excel?
  • How to Convert Number into Square/Qube Root in Excel?
  • How to Use Divide Function in Excel?
  • How to Use Multiply Funtion in Excel?
  • How to Use SUBTRACT Function/Method in Excel?
  • Most Used Functions in Excel

Category

  • Excel
  • Most Used Functions

Latest Posts

  • What is Excel?
  • How to Use Vlookup Function in Excel? A Complete Guide
  • Main Features of Excel
  • Contact Us
  • All Shortcut Keys of Excel
  • Duplicate Formula of Excel: How to Find and Remove Duplicate Entries
  • Types of Errors in Excel: #N/A Error, #DIV/0! Error, #VALUE! Error, #REF! Error, #NAME ERROR, #NUM ERROR
  • ASCII Codes in Excel
  • Most Used Functions in Excel
  • How to Use SUBTRACT Function/Method in Excel?

Copyright © 2023 Excelkeys.

Powered by PressBook Grid Dark theme