Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Brick72
 
Posts: n/a
Default Create a list range

I need to create a list range
Under data, point to list and then create list.
I do not have list listed under data.
Where can it be found?
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Data Validation. Select 'List' in 'Allow' field. Into 'Refers to' field, or
enter list values separated by your list separator, or enter the link to
cell range on same worksheet, or enter the link to any named range in same
workbook.


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Brick72" wrote in message
...
I need to create a list range
Under data, point to list and then create list.
I do not have list listed under data.
Where can it be found?



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Perhaps ToolsCreate a List.


Gord Dibben Excel MVP

On Wed, 5 Oct 2005 19:05:02 -0700, "Brick72"
wrote:

I need to create a list range
Under data, point to list and then create list.
I do not have list listed under data.
Where can it be found?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to Create a Conditional Drop down list Noel Excel Worksheet Functions 6 July 26th 05 05:18 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Create a cascading list box using Excel JPB Excel Discussion (Misc queries) 1 February 24th 05 08:43 PM
How do you create a drop down list? Aviator Excel Discussion (Misc queries) 2 December 28th 04 03:07 PM
how do i create a list from a cell? AT New Users to Excel 2 December 15th 04 07:40 PM


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"