Drop-down button

[JGarces]

When creating a drop-down list in Excel, how can I get the list to permanently display the drop-down button in the cell. Thus allowing people to identify the cell as a drop-down rather than a normal cell. At present it only shows when the cell is selected by the user.

Help is greatly appreciated.

JFGarces

[Harald Staff]

Not possible, sorry.

HTH. Best wishes Harald

"JGarces" <[email protected]> skrev i
melding news:[email protected]...
>
> When creating a drop-down list in Excel, how can I get the list to
> permanently display the drop-down button in the cell. Thus allowing
> people to identify the cell as a drop-down rather than a normal cell.
> At present it only shows when the cell is selected by the user.
>
> Help is greatly appreciated.
>
> JFGarces
>
>
> --
> JGarces
> ------------------------------------------------------------------------
> JGarces's Profile:
http://www.excelforum.com/member.php...o&userid=30406
> View this thread: http://www.excelforum.com/showthread...hreadid=522778
>

[Michael]

Why not put a comment in that cell - the comment flag would indicate it's a
dropdown box. Or, put a colored border around the cell.
--
Sincerely, Michael Colvin


"JGarces" wrote:

>
> When creating a drop-down list in Excel, how can I get the list to
> permanently display the drop-down button in the cell. Thus allowing
> people to identify the cell as a drop-down rather than a normal cell.
> At present it only shows when the cell is selected by the user.
>
> Help is greatly appreciated.
>
> JFGarces
>
>
> --
> JGarces
> ------------------------------------------------------------------------
> JGarces's Profile: http://www.excelforum.com/member.php...o&userid=30406
> View this thread: http://www.excelforum.com/showthread...hreadid=522778
>
>