MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel drop down list without the arrow head on the right hand side


Posted by Lisa on August 05, 2001 9:52 AM

Hi, I want to create a drop down list in Excel. How can I do this without the arrow head appearing on the right hand side.

Many thanks.


Posted by Lokman on August 05, 2001 9:56 AM

Use Data Validation

Posted by P Srinivas on August 06, 2001 12:29 AM

Answer to drop down list without the arrow head on the right hand side

Hi,
You can have the drop-down with out arrow head by NOT checking the In-cell dropdown check box. This is below Ignore blank check box in data-validation-setting.
Hope this will solve your problem.
-Srinivas