combo box on a column
 

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.

combo box on a column
 

Hi Stephanie,

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

That's it ...

HTH
Carim

combo box on a column
 

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.

combo box on a column
 

"Carim" wrote in message
ups.com...
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.

combo box on a column
 

Stephanie,

Glad I could help.
Thanks for the feedback.

Carim