Dropdown Only Showing First Blank?

c.clavin

Board Regular
Joined
Mar 22, 2011
Messages
123
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Hi guys, I've been trying to work this out no no avail. I have a drop-down list that references a Table with 4 categories. The first space blank cell is shown as a space, but any spaces thereafter are not shown. Im guessing it's using some sort of UNIQUE searching under the hood. Is there a way to show ALL blank cell gaps as spaces?

Book1
ABC
1Apples
2Bananas
3Carrots
4
5Baking Soda
6Flour
7Sugar
8
9Coke
10Pepsi
11Sprite
12
13Frozen Pie
14Ice Cream
15Italian Ice
Sheet1
Cells with Data Validation
CellAllowCriteria
C5List=$A$1:$A$15
 

Attachments

  • Screenshot 2023-11-22 at 1.00.19 PM.png
    Screenshot 2023-11-22 at 1.00.19 PM.png
    164.6 KB · Views: 3

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Short of putting a different of spaces in each empty cell, I don't think so.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,875
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top