Excel Question

[Le Pen]

Hello,

I'm looking for the way to have a little dropdown arrow at the end of a cell, so that I can select an option (word) to go in that cell.

I'm using Excel 2010 and I'm generally useless :{ at most things!

All help would be welcome..... And, yes, I have tried switching it off then on again ;)

Love
LP

[MacBoero]

Small tutorial:

Enter the following data:

Cell A1 : First
Cell A2 : Second
Cell A3 : Third
Cell A4 : Fourth

You now have a short list of values in a column in the top left corner of your worksheet from first, to fourth.

Select cell B1
Click the "Data" tab on the ribbon.
Click the "Validate" tool button.
Set the Data Validation window that appears:
Set the "Allow:" drop down to "List".
In the "Source:" box enter the following : =$A$1:$A$4
Click "OK"
You should now see that cell B1 has a drop down selector beside it. If you click on it, a drop down will appear listing First, Second, Third, Fourth.

That is a basic example. Hopefully that will get you started.

The source list, doesn't have to be in the same worksheet.
The source list can be set by click and drag selection of the range of cells containing the values. The range has to be in a single column or single row, it can't be a rectangular block.

[mixture]

I'm using Excel 2010 and I'm generally useless at most things!

Am sure you're not as useless as a person who asked me the other day why excel kept on hanging and crashing when they were trying to copy and paste the entire 110,000 rows of column A of a 40 column wide spreadsheet they had knocked up.

:ugh:

[Le Pen]

MacBoero,

Thank you so much for that. I will try it this afternoon. :ok:

mixture,

I fix aeroplanes for a living..... I can't be that clever :}

Love
LP

[MacBoero]

I wish I fixed aeroplanes for a living, sadly I do stuff with computers!:(

[ExSp33db1rd]

I suffer from EGBF

Electronic Gadget Brain Failure.

[riverrock83]

I suffer from EGBF

Electronic Gadget Brain Failure.

I'm sure I've seen someone land there (http://airportnavfinder.com/airport/EGBF/) once...