M
Mark
I have created a custom list. Now I want to be able to enter a text into a cell from that list
How can I do that?
How can I do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
Look at Data Validation. See Debra's site for details at
http://www.contextures.com/xlDataVal01.html
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
http://www.contextures.com/xlDataVal01.html
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
G
Gord Dibben
Mark
Just to clarify.
Custom Lists are not used in the manner you describe. See Bob's answer for
how to do the Data Validation list.
Custom Lists are used to create a list of data in adjacent cells as you
drag/copy down or across.
Example.....the days of the week are a Custom List, the alphabet is a custom
list.
George, Gord, Bob, Mark, Bill, John can be a custom list you add through
Tools>Options>Custom List.
Enter George in A1 then drag/copy down to get the other names in the list
entered in cells below.
There is a third "list type" which is "pick from list".
If you have data in a column or row and you right-click on a cell in that
column and select "pick from list" you will get a list of unique items to pick
from based on the data in the column.
Gord Dibben Excel MVP
Just to clarify.
Custom Lists are not used in the manner you describe. See Bob's answer for
how to do the Data Validation list.
Custom Lists are used to create a list of data in adjacent cells as you
drag/copy down or across.
Example.....the days of the week are a Custom List, the alphabet is a custom
list.
George, Gord, Bob, Mark, Bill, John can be a custom list you add through
Tools>Options>Custom List.
Enter George in A1 then drag/copy down to get the other names in the list
entered in cells below.
There is a third "list type" which is "pick from list".
If you have data in a column or row and you right-click on a cell in that
column and select "pick from list" you will get a list of unique items to pick
from based on the data in the column.
Gord Dibben Excel MVP
G
Gord Dibben
M
Mark
If later on I need to add more imtes into a list how would I do that?
F
Frank Kabel
Hi
you may use a dynamic range for this as data source. e.g. on the same
site see
http://www.contextures.com/DataValDateRange.xls
you may use a dynamic range for this as data source. e.g. on the same
site see
http://www.contextures.com/DataValDateRange.xls
M
Mark
Not sure how that works. Is there any other way to update named list
F
Frank Kabel
Hi
if you want a dynamic list this is the easiest solution (of course you
can define your initial list larger than required)
if you want a dynamic list this is the easiest solution (of course you
can define your initial list larger than required)