How do I create a list using Excel when there isn't a list option.

[Guest]

There is no list option on the Data Menu or anywhere on the toolbar. My
question is how can i create a List range if there isnt a Create list option,
or Create List dialog box?

 

[Govind]

Hi,

You should look for Data->Validation menu.In the validation window,
choose list as validation criteria.

Regards

Govind.

 

[SPenney]

I might be looking at this from the extremely simple point of view, bu
if you type your list, one cell after another, Excel recognizes it as
list. By placing the heading in the first cell, the sort and filte
options work better.

Staci

 

[bsullins]

Stacie,

What are you trying to use a list for?

If you want to make an easy reference to a range of data I woul
suggest using a named range. To make a named range highlight the range
hit ctrl+F3 then enter a name. I typically use that, much easier t
reference...

Be

 

[SPenney]

Ben---

Thanks, but I was trying to help, not looking for a solution.

Staci

 

[Lady Layla]

Stacie

If you include the message you are replying to in your reply, perhaps the
posters here would know what you are refering to and that you are replying vs
just posting


:
: Ben---
:
: Thanks, but I was trying to help, not looking for a solution.
:
: Stacie
:
:
: --
: SPenney
: ------------------------------------------------------------------------
: SPenney's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=1079
: View this thread: http://www.excelforum.com/showthread.php?threadid=263171
:

 

[bsullins]

oops!

LOL

Sorry Stacie, I thought you were the one that posted the question...