drop downs

Hi,

I would like to create a list of drop downs in the first column of an excel
spreadsheet. I would like input a list for the drop downs and also have the
icon for the drop down visible in each and every cell.

Thanks....
--
MickM

Per
Sun May 11 05:25:59 CDT 2008

Hi Mick

Look at DataValidation.

In an unused column enter the list of data to be shown in your drop down
field.

Select the cells where the drop down list shall appear.

Goto Data > Validation > Allow : List > Source : select the list entered
above > OK

Regards,
Per

"Mick" <Mick@discussions.microsoft.com> skrev i meddelelsen
news:FE6385E7-2A8E-403D-9B4B-31CA4FBA618D@microsoft.com...
> Hi,
>
> I would like to create a list of drop downs in the first column of an
> excel
> spreadsheet. I would like input a list for the drop downs and also have
> the
> icon for the drop down visible in each and every cell.
>
> Thanks....
> --
> MickM

Gord
Sun May 11 11:16:39 CDT 2008

You can create the dropdowns with Data>Validation>List.

The dropdown arrow will only be visible when you select a cell.

Quoted from Debra Dalgleish's site.................................

Only the active cell on a worksheet will display a data validation dropdown
arrow. To mark cells that contain data validation lists, you can colour the
cells, or add a comment.

If you require visible arrows for all cells that contain lists, you can use
combo boxes instead of data validation, and those arrows will be visible at all
times. To create a combo box, choose View|Toolbars, and select either the
Control Toolbox or the Forms toolbar.

End quote.......................................


Gord Dibben MS Excel MVP

On Sun, 11 May 2008 01:27:01 -0700, Mick <Mick@discussions.microsoft.com> wrote:

>Hi,
>
>I would like to create a list of drop downs in the first column of an excel
>spreadsheet. I would like input a list for the drop downs and also have the
>icon for the drop down visible in each and every cell.
>
>Thanks....