R ranaray Member Oct 25, 2012 #1 Hi All, How do I give a title to my dropdown list. I want users to see 'Select Here' in the cell. I know how to create a drop down from data validation. please help Rana
Hi All, How do I give a title to my dropdown list. I want users to see 'Select Here' in the cell. I know how to create a drop down from data validation. please help Rana
Luke M Excel Ninja Staff member Oct 25, 2012 #2 Either make your title the first choice in cell and select it to start, or in Data Validation dialogue, go to Input Message tab, and put what you want there.
Either make your title the first choice in cell and select it to start, or in Data Validation dialogue, go to Input Message tab, and put what you want there.
J jason Member Oct 25, 2012 #3 LUKE!!! STOP BEING ABLE TO RESPOND BEFORE ME!!!!! (excel ninja appears to be fairly accurate!!! OP: i would go with the second option Luke suggested.
LUKE!!! STOP BEING ABLE TO RESPOND BEFORE ME!!!!! (excel ninja appears to be fairly accurate!!! OP: i would go with the second option Luke suggested.
bobhc Excel Ninja Oct 26, 2012 #4 Jason Your all upper case formula will not work....you forgot the closing parentheses.
SirJB7 Excel Rōnin Oct 27, 2012 #5 @b(ut)ob(ut)hc Hi, old dog! Good afternoon and have a nice weekend. Regards from your friend!
