how to display the drop down menu icon?

's Computer Specifications

hi. i have aready created the drop down menu list using data validation. how
can i display the drop down icon beside the cell instead of it only shown
when the cursor pt to it.

's Computer Specifications

DV dropdown arrows cannot be made visible without selecting the cell.

Either use a ComboBox or just color the cell or use drawing toolbar to draw
an arrow in the adjacent cell pointing to the DV dropdown.

Gord Dibben MS Excel MVP

On Wed, 29 Oct 2008 08:42:00 -0700, Oligo <(E-Mail Removed)> wrote:

>hi. i have aready created the drop down menu list using data validation. how
>can i display the drop down icon beside the cell instead of it only shown
>when the cursor pt to it.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
shortcut to display drop down menu	Ali00ps	Microsoft Excel Worksheet Functions	2	15th Oct 2009 07:44 PM
can i create a drop down menu for the printer icon	=?Utf-8?B?TGluZGEgU290c2tp?=	Microsoft Word Document Management	1	11th May 2005 11:19 PM
Edit menu will not display drop down with Alt + E	=?Utf-8?B?U3VzYW4sIGFuIGVkaXRvcg==?=	Microsoft Word Document Management	0	25th Jan 2005 09:09 PM
display a drop menu with options.	melawaisi	Microsoft Excel Misc	1	8th Nov 2003 02:10 AM
Drop-down menu won't display!	Jason Bram	Windows XP Internet Explorer	0	13th Aug 2003 06:21 AM