Prev: Remove columns containing all zeros
Next: why is the feature "share workbook" unavailable to use
From: tlynn on 1 Jun 2010 14:09
I have followed all the steps in creating a drop down list in Excel 2007:

Created Named list on seperate sheet
goto the sheet that the drop down will be on and select the appropriate cell
Data > Data Validation > Allow:List > Source: =BlahList > Click "OK"

....And then, I get this message every time:

"The list source must be a delimited list, or a reference to single row or
column."

So. What am I doing wrong? Ive been to Youtube, and read numerous articles
on here about "Drop Down Lists" and still am having an issue with this one
feature. Thank you for your time and attention in this...

From: Roger Govier on 1 Jun 2010 14:15
Hi

It sounds as though your "blahList" is more than one column Wide.

--
-------
Regards
Roger Govier

"tlynn" <tlynn(a)discussions.microsoft.com> wrote in message
news:33770AE0-C0BE-4819-A6DD-AE9ACC6447D8(a)microsoft.com...
> I have followed all the steps in creating a drop down list in Excel 2007:
>
> Created Named list on seperate sheet
> goto the sheet that the drop down will be on and select the appropriate
> cell
> Data > Data Validation > Allow:List > Source: =BlahList > Click "OK"
>
> ...And then, I get this message every time:
>
> "The list source must be a delimited list, or a reference to single row or
> column."
>
> So. What am I doing wrong? Ive been to Youtube, and read numerous
> articles
> on here about "Drop Down Lists" and still am having an issue with this one
> feature. Thank you for your time and attention in this...
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5164 (20100601) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com



From: Max on 1 Jun 2010 16:00
Roger, a short Q. where the deuce is Insert>Name>Paste List in xl2007? where
we can immediately paste a list of defined names (to check for example).
Thanks
--
Max
Singapore
---

From: Roger Govier on 1 Jun 2010 17:03
Hi Max

Formulas tab>Define Name or Formulas tab>Name Manager>New
or as a shortcut
Alt+M+M+D
--
-------
Regards
Roger Govier

"Max" <demechanik(a)yahoo.com> wrote in message
news:241CA0E3-FE6F-4B2C-B1A7-51E522F9D477(a)microsoft.com...
> Roger, a short Q. where the deuce is Insert>Name>Paste List in xl2007?
> where
> we can immediately paste a list of defined names (to check for example).
> Thanks
> --
> Max
> Singapore
> ---
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5164 (20100601) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com



From: Gord Dibben on 1 Jun 2010 19:04
I have not been able to find that feature either.


Gord

On Tue, 1 Jun 2010 13:00:01 -0700, Max <demechanik(a)yahoo.com> wrote:

>Roger, a short Q. where the deuce is Insert>Name>Paste List in xl2007? where
>we can immediately paste a list of defined names (to check for example).
>Thanks

 |  Next  |  Last
Pages: 1 2 3
Prev: Remove columns containing all zeros
Next: why is the feature "share workbook" unavailable to use