excel computer training london - 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