I'm using Excel 2007. In cell B3 there is a drop down menu with several items listed in it. I'd like to delete a couple of items in that list. How would I do that?
An Internet search turned up only vague answers about going to Data -> Data Validation -> Data Validation -> Settings and do something in "Source", but it wasn't clear as to what. The "Source" section has =L2:L12 in it. I don't know what this is. I do not have a column "L" and nothing in the "2" row.
Thanks in advance.
David
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There's no sensitive information on it. It's just a monthly expense tracking sheet.
Your Data Validation is based on a list. That list may be IN the DV menu, or it may be referenced from within the DV menu.
this tells me that the range is being referenced. Look at the column heading letters and look for the L column. If it isnt visible, it is probably hidden - highlight the columns either side of where it should be, right-click and click Unhide. Then look for the data in the range L2:L12. You can then delete what you dont want, and move the rest up, and then adjust the range accordinglyThe "Source" section has =L2:L12 in it.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Aha! Thanks.
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks