Home > Drop Down > Excel 2010 Drop Down List Not Working

Excel 2010 Drop Down List Not Working


This issue was solved using the solution BGbaum proposed: by using names to delininate my ranges instead of defining the range using something like =$A$12:$A$13. Is it possible to get the activation arrow positioned on the left? ie. If you do that, you would know what to do I know I could save your time and mine by giving you the answer, but I think it is better that his comment is here

Microsoft Customer Support Microsoft Community Forums TechCenter   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 When you click a cell for a drop down menu, it will list colors in text..red, blue, and white. (Already got this.) At the same time of the selection, another cell Thanks. To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! http://stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010

Excel 2010 Drop Down List Not Working

Tony Chen Thursday, December 12, 2013 2:50 PM Reply | Quote Moderator 1 Sign in to vote Hello Tony, Open and Repair" mode did not help. SirJB7, Apr 22, 2013 #6 (You must log in or sign up to reply here.) Show Ignored Content Share This Page Tweet Your name or email address: Do you already have Feel free to post back. Reply Report SARC 29Posts Saturday August 7, 2010Registration date August 31, 2010 Last seen - Aug 26, 2010 09:41AM wow,,.

Is there a way to do this? The validation just dissapeared from the cells... blank cells in between break the link. Excel Drop Down List Not Showing This box used to allow me to click it and select a month from the list.

What does a white over red VASI indicate? Excel 2013 Drop Down List Not Working one more issue though,.. Click the Data Validation item on the Data Tools panel again to bring up the dialogue box. Powered by vBulletin Version 4.1.8 Copyright 2012 vBulletin Solutions, Inc.

Ask Your Own Question How To Edit A Drop Down List? - Excel Excel Forum Hi there everyone, I normally enjoy being presented with Microsoft Office puzzles from co-workers and can Unable To View Drop Down List In Excel SirJB7, Apr 22, 2013 #4 s_k_s New Member Messages: 10 Thanks for your help. Rizvisa pls help.. How to plot a simple circle in LaTeX "president-elect" grammatically correct?

  1. Sunday, December 08, 2013 4:35 PM Reply | Quote Moderator 0 Sign in to vote I am seeing the same thing!
  2. I am looking for the multiple items to basically work more like pre-2007 version in this case.
  3. and thanks for your patients...

Excel 2013 Drop Down List Not Working

Go to Data tab on menu and click on Data Validation 13. To let Excel handle the job, click the icon to the right of the Source textbox: When you click this icon, the Data Validation dialogue box will shrink: Now select the Excel 2010 Drop Down List Not Working I Select about 150 cells and then using the Add method of the Validation object to create the validation on this range of cells. Excel Drop Down Boxes Not Working Excel itself will handles this part. ' This code is written with assumption that at a time only ' one cell would be changed ' if the changed column is not

No, create an account now. this content Kind regards, Martin van der Voort. Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Drop down list and macro work A1 is a cell but a range too. Excel Drop Down List Disappeared

The code runs and all 150 cells now have a drop down list. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search http://elliottwaveresearch.com/drop-down/excel-drop-down-list-not-working-2007.html As for the drop down list, I can't really paste the whole file as there is a lot of confidential info in there and I can't just send part of it

Any help or suggestions would be greatly appreciated. Drop Down List Works In Excel 2010 But Not 2007 Is there an option so that the drop down will start at the first cell included in the list? Can it be possible that Excel 2013 uses a new function that Excel 2007 doesn't support?

Now range has some properties like column, row, address etc.

Will try the suggestions listed. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote March 3rd, 2011 #3 rory View Profile View Forum Posts Super M‌oderator Join Date 2nd May 2008 Location Ubique Posts 2,266 Unfortunately this option is already on, I hope you have another solution! Excel 2007 Drop Down List From Another Sheet Reply Add comment Helpful +0 Report RLS Nov 10, 2010 10:03AM Rizviza, I have a similar query, in that I am creating 2 drop down lists, The first drop down list

Why is translateY(-50%) needed to center an element which is at top: 50%? Optionally go to input tab and error tab to enter messages for that 16. I can't seem to find any option for this in the Data Validation dialog. check over here What is the VB Code for disabling/enabling the drop down list, once it has been identified.

If I click off the cell and click back on it, I still get only the heading of the list in the drop-down list and start over again. -- Thanks, Beth This you can open by pressing CTRL + G or going to VIEW and selecting it here. Will I get a visa again? Thanks Ask Your Own Question Data Validation - Drop-down List - Make Arrow Visible At All Times - Excel Excel Forum I have added a Data Validation List to my excel

The time now is 21:16. What if I wanted this to work on just 1 cell in a column?? On a new sheet (let say sheet2) in Cells A1, B1, C1 and D1 enter values Mill, Comp, Loads, Blending respectively 2.