validation list

  • Thread starter Thread starter trey
  • Start date Start date
T

trey

another question..my validation list originally only had
4 items... how do i add items to it...ive added
additional items and when i highlight and pull the name
of the list up and hit enter it will not let me expand
the list- it reverts back to the original list size....
thanks
trey
 
On the sheet where your list is entered:

<Insert> <Name> <Define>
Click on the name of your list,
Then click in the "RefersTo" box,
Hit <F2>,
And just change the old row number to the new row number denoting the end of
your newly revised list.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

another question..my validation list originally only had
4 items... how do i add items to it...ive added
additional items and when i highlight and pull the name
of the list up and hit enter it will not let me expand
the list- it reverts back to the original list size....
thanks
trey
 
Select the cell that contains the data validation list
Choose Data>Validation
In the Source box, change the cell reference to include the new items in
the list.
Click OK
 
When you choose Data>Validation, the Data Validation dialog box opens
On the Settings tab, from the Allow dropdown, choose List
At the bottom of the dialog box, there's a box for the Source of the list
That's where you can type a list, or select a range of cells on the
worksheet.

There are instructions here:

http://www.contextures.com/xlDataVal01.html
 
its not letting me enter in the other sheet and when i
try to maually enter in the cells of the list it dsnt
recognize that as well...help!!!
trey
 
If the list is on a different sheet, the list range must be named.
To change the named range:

Choose Insert>Name>Define
Select the range name in the list
In the Refers To box, change the reference to include the new items
Click OK

There's some information on naming ranges here:

http://www.contextures.com/xlNames01.html
 
Heck - 9 posts in almost 2 hours after I said the same darned thing.

I guess my posts are not going through.

I think it was Gord, who asked a couple of months ago;
What am I ... chopped liver?<g>
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


now i feel like a real idiot....i figured it out...
thanks for the help
trey
 
Are you saying Homer Simpson is mentioned in the Illiad? I think he used to
drive an Odyssey, but even with the Olympics, it's all Greek to me.

(no, I will not respond to any Awwwwwwwww's!!!)
 
Who's Homer Simpson ???

Perhaps you meant Homer Winslow.

I only delve in the Arts and the Sciences!

You couldn't be referring to something as that mass form of Plebeian
entertainment media labeled TV ... or could you?

I truly thought that you were above all that.<g>
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


Are you saying Homer Simpson is mentioned in the Illiad? I think he used to
drive an Odyssey, but even with the Olympics, it's all Greek to me.

(no, I will not respond to any Awwwwwwwww's!!!)
 
Back
Top