⬇️How to Keep Drop Down Buttons Always Visible in Excel

[@Jojosmith342]

all thumbs up as always to the best teacher Chester. Hope everyone subscribes as I did. thanks a lot Chester for teaching

[@pl4160]

Nice tutorial! Can you somehow change the format of the font inside the dropdown lists?

[@shubhamargulwar742]

Hi, do we have any video on index formula if could you please share link

[@natascha_kn]

Although I prefer the first method (I like that it still is a cell, rather than an element on top), I do like that the arrow is always visible. Is there a way to get rid of the frame around it? If I have a normal excel sheet and do the box, there's an outline and you can see the difference from a normal cell. I can't really edit the appearance of the box.

[@Bambabah]

This is great, I love the combo box method but how do you make it more expandable? I need hundreds of these buttons and wonder if there’s any smart way to do it? My problem is when I drag-copy my cells, the combo boxes has the same reference cell, I have to change it manually. Any way to automatize that bit? So that when a new button appears (from drag-copy the cell beneath the combo box), it automatically has the corresponding reference cell.

[@sinankosoglu]

This is what I am looking for actually

[@abdelazizallam]

thanks

[@albanoteles4924]

where ts the link for download file? thanks!

[@ChesterTugwell]

Here we go...www.bluepecantraining.com/wp-content/uploads/2023/12/Drop-down-always-visible.xlsx

[@iomoon3608]

This shouldn’t be needed. 🤦🏻‍♀️