How do I make a list in Excel without blanks?

To create a drop down list without blanks, based on a range with blank cells, add formulas to the worksheet. First, add a formula in cell A2, and copy it down to cell A13. This will number the cells that are not blank.

How do I remove blanks from Excel?

Delete Blank Rows
  1. On the Home tab, in the Editing group, click Find & Select.
  2. Click Go To Special.
  3. Select Blanks and click OK. Excel selects the blank cells.
  4. On the Home tab, in the Cells group, click Delete.
  5. Click Delete Sheet Rows. Result:

How do I ignore blanks in data validation list?

Select the cell that contains a data validation list. Choose Data|Validation. On the Settings tab, remove the check mark from the Ignore blank box. Click OK.