combo box on a column

[Stephanie]

I am (ok was) a database programmer, so maybe my brain is stuck in database
land. I am trying to make a spreadsheet. It is going to be an expense
spreadsheet. Super simple. Date of the expense. Receipt number. But I want
to assign a type to the expense from a list of 3 possibilities. I figured
out how to make a combo box in a cell. But I really want the combo box to
repeat on each new row I enter.

Is this possible? I don't want to

- Type the value of the type in because I cannot type. I will invariably
make typos causing things not to group down the line. And I am very lazy.

- Copy and paste the combo with each insertion. I want to be fast, fast,
fast. Because fundamentally I hate doing the expense spreadsheet!

Thanks for your help.

 

[Carim]

Hi Stephanie,

Use Data Validation
Select List and the Source field input your 3 possibilities ...

That's it ...

HTH
Carim

 

[Dave O]

If you copy the combo box down a thousand or so rows, that will keep
you going for a while. It's not consistent with database optimization
guidelines, but that's one of the trade offs for using Excel as a
database! (Kidding, not scolding.) If you do it this way you're done,
and just have to remember to copy another thousand or so rows when you
finish the first thousand.

 

[Stephanie]

Hi Stephanie,

Use Data Validation
Select List and the Source field input your 3 possibilities ...

That's it ...

HTH
Carim

Waa Hoo. As I was not using the correct term to look up in help I did not
find that. Thanks!

Now that I think of it, I have done that before. Anyway thanks again.

 

[Carim]

Stephanie,

Glad I could help.
Thanks for the feedback.

Carim