List arrow is not visible

ABC3132

Board Regular
Joined
Nov 7, 2017
Messages
52
Office Version
  1. 2019
Platform
  1. Windows
Hi
I have created a simple list where you have to choose the company sector.
The problem is that you cannot see that you have choices.
The B2 has the arrow visible simply because I´m in the cell B2.
In B3 and B4 the reader has the same choices but as I do not see any arrow at the side the reader cannot realize that.
So, there is anyway to do it or show the first cell with the options ( Like column G)?
Thanks in advance
1645435412557.png
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
That's the way Excel in-cell drop-downs work. If you don't like it then replace the functionality by using ActiveX Combo-boxes.
 
Upvote 0
Solution

Forum statistics

Threads
1,224,817
Messages
6,181,149
Members
453,021
Latest member
Justyna P

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