98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Drop down list
Drop down list
Resolved · Medium Priority · Version 2007
Tue 3 May 2011, 13:47Delegate Lisa said...
Lisa has attended:
Excel Advanced course
Drop down list
I attended the advanced excel course but can’t understand some of my notes.
I want a particular cell in a table to have a drop down list. So I dont have to type and you can only pick between the option I have set up.
I have set up a separate page with a list of the options I want to be able to pick between.
But I can’t remember what comes next, do I format as a range or a table and how do I link the particular cell in my table to the options on the other tab?
Thank you Regards
Tue 3 May 2011, 13:58Trainer Simon said...
RE: Drop down list
Hi Lisa,
Thank you for your question.
The first thing to do is to highlight the values you typed in on the other sheet and name the range.
Now select the cell in the table and go to the Data tab and then Data Validation. Choose 'List' from the Allow box and then in the Source box enter an equals sign followed by the range name.
e.g.
=MyList
Use the Input Message and Error Alert tab if necessary.
I hope this answers your question.
Regards
Simon
Tue 3 May 2011, 17:13Delegate Lisa said...
RE: Drop down list
Dear Simon
1. Thank you for your quick reply.
2. That was prefect, it worked first time.
3. Is there any way of a calendar appearing instead on a drop down list? (Do I need to ask this as a new question?)
Thank you again for your help.
Regards
Lisa
Wed 4 May 2011, 08:53Trainer Simon said...
RE: Drop down list
Hi Lisa,
Thank you for your email.
You cannot set up a calendar to drop down using Data Validation. You can use an Active X control which displays a calendar on the sheet but not in the cell.
However this method may need an understanding of Visual Basic. I am sure you could code the value selected on the calendar control to be linked to a cell.
The only other way is to create the possible range of dates in a list and name then again and then use data validation. This would only be useful if there was a defined ranged of dates to select from.
I hope this helps. Sorry I couldn't have been of more help.
Regards
Simon
Tue 10 May 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting a data rangeAttempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own! |
