Lists and Formatting

**Littkerl** · 01-06-2012, 11:42 AM

Two Questions: If I'm making a drop down list, with several categories and I put that in cells off to the right of my worksheet and then later notice that I need to add rows to my worksheet it messes up my list. (I get gaps for the empty cells in my drop downs) How do I fix this,

Is there anyway to put the list on another worksheet or somewhere it wont interfere?

**NBVC** · 01-06-2012, 12:26 PM

Originally Posted by Littkerl

...

Is there anyway to put the list on another worksheet or somewhere it wont interfere?

Yes, put it in another worksheet, then name those ranges and use those names in your data validation

http://www.contextures.com/xldataval01.html#Name

http://www.contextures.com/xldataval02.html

**CityMPLSEmpolyee** · 01-06-2012, 12:57 PM

I have done this and now in the Data Validation dialog box I set it up with the error to "Stop" but I don't get the error message what am I doing be wrong?

**NBVC** · 01-06-2012, 12:59 PM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

**dilipandey** · 01-06-2012, 01:02 PM

Hi CityMPLSEmployee,

Would like to see the sample file, might be some issue with using name in the data validation.

Regards,
DILIPandey

<click on below 'star' if this helps>

**CityMPLSEmpolyee** · 01-06-2012, 01:28 PM

in reply to DILIPandey
the name I gave the list is "Casting_List". I would attach a sample but as it was side this is not my thread
&
in reply to NBVC
the web sit has changed sence the last time I used it and I can't find were I am to start a new thread.

and my appoligy to Littkerl