Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default In Excel how do I set up the list from the Data dropdown menu?

I'm studing Excel at SMC, and in the tutorial it says to click on Data on the
menu bar then point to List. But on my laptop it is not listed. Does anyone
know how I can add this to my computer?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,688
Default In Excel how do I set up the list from the Data dropdown menu?

Click on Data
Select: Validation
Then select: Allow: List

Biff

"Gypsy Taylor" <Gypsy wrote in message
...
I'm studing Excel at SMC, and in the tutorial it says to click on Data on
the
menu bar then point to List. But on my laptop it is not listed. Does
anyone
know how I can add this to my computer?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default In Excel how do I set up the list from the Data dropdown menu?

It's now telling me to add a source, and I have no idea what that could
possibly be.

"Biff" wrote:

Click on Data
Select: Validation
Then select: Allow: List

Biff

"Gypsy Taylor" <Gypsy wrote in message
...
I'm studing Excel at SMC, and in the tutorial it says to click on Data on
the
menu bar then point to List. But on my laptop it is not listed. Does
anyone
know how I can add this to my computer?




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default In Excel how do I set up the list from the Data dropdown menu?

The List feature was introduced in Excel 2003. In earlier versions, you
can add dropdowns to the column headings by choosing
DataFilterAutoFilter, but all of the List features won't be available.

Gypsy Taylor wrote:
I'm studing Excel at SMC, and in the tutorial it says to click on Data on the
menu bar then point to List. But on my laptop it is not listed. Does anyone
know how I can add this to my computer?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,688
Default In Excel how do I set up the list from the Data dropdown menu?

I may have misunderstood your question. I thought you wanted a drop down
list. See Debra's reply.

Biff

"Gypsy Taylor" wrote in message
...
It's now telling me to add a source, and I have no idea what that could
possibly be.

"Biff" wrote:

Click on Data
Select: Validation
Then select: Allow: List

Biff

"Gypsy Taylor" <Gypsy wrote in message
...
I'm studing Excel at SMC, and in the tutorial it says to click on Data
on
the
menu bar then point to List. But on my laptop it is not listed. Does
anyone
know how I can add this to my computer?






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
sorting 2 colums of numbers and incremening them down blk&wht Excel Discussion (Misc queries) 10 October 9th 06 10:12 PM
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Data Val list Excel 97 fire macro rgarber50 Excel Discussion (Misc queries) 4 October 9th 05 05:19 PM
Get excel to list values that occur within raw data dennis34 Excel Discussion (Misc queries) 2 October 5th 05 12:09 PM
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM


All times are GMT +1. The time now is 02:44 PM.

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

About Us

"It's about Microsoft Excel"