98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - Macros
excel computer training london - Macros
Resolved · Low Priority · Version Standard
Reyno has attended:
Excel Intermediate course
Excel Advanced course
Macros
I would like to produce a cell with a drop down arrow and the options within that cell be.... low, medium and high, but cant seem to do it.
I was wondering if someone could help me please?
Thanks
RE: macros
Hi Reyno
You can set up a dropdown list of cell entries using data validation.
Select the cell or cells you wish to have the dropdown arrow appear in.
Go to Data - Validation on the menu bar.
Under Allow: select List.
In the Source: box, type in the list with commas between each item. In this case you would type Low, Medium, High
Click OK. The dropdown arrows should appear when you click on any cell you had selected before setting up the list.
I hope this answers your question - if not please post again and we will be happy to have another go in assisting you.
Amanda
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:Adding multiple rows in an Excel 2010 WorksheetIf you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. |