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.
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.
all thumbs up as always to the best teacher Chester. Hope everyone subscribes as I did. thanks a lot Chester for teaching
Hi, do we have any video on index formula if could you please share link
Nice tutorial! Can you somehow change the format of the font inside the dropdown lists?
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.
thanks
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.
This is what I am looking for actually
where ts the link for download file? thanks!
Here we go...www.bluepecantraining.com/wp-content/uploads/2023/12/Drop-down-always-visible.xlsx
This shouldn’t be needed. 🤦🏻♀️