View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default drop down lists identifiers

Hi,

You may have seen a combo-box.

View|Toolbars|Forms

From the forms toolbar put a combo-box on you wrksheet.

Mike


"dave caizley" wrote:

In my XL2003 workbooks, I have a number of drop down lists. The small
indicator to the right only appears when I click on a cell with a list in it.

I have seen spreadsheets where every list is permanently identifiable as the
indicator is permanently visible.

How is this done please

Thanks in anticipation