ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel how do I set up the list from the Data dropdown menu? (https://www.excelbanter.com/excel-discussion-misc-queries/114873-excel-how-do-i-set-up-list-data-dropdown-menu.html)

Gypsy Taylor

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?

Biff

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?




Gypsy Taylor

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?





Debra Dalgleish

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


Biff

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?








All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com