Excel Help!

[Grand_MasterB]

Ok this seems like it should be easy but i cant seem to figure it out. In Microsoft Excel in a certain column i have to enter one of ten different options. Is there anyway that i can get all these options in a drop down list so when i go to that cell, all i have to do is click the drop down arrow and then choose wich one. Thanks alot guys!

[DWDuck]

It is easy, but not terribly obvious. Here's how to do it. First select the cell that you want to put the drop down list in. Then under the "Data" menu, go to "Validation". In the "Settings" tab, select "List" in the "Allow" dropdown list. A "Source" box will appear. You can either choose a named list (another fun Excel exercise), or just type a comma delimited list of choices to put in here.

Let me know if you have any troubles with this.

Brad

[Grand_MasterB]

Thank you so much Brad! I never would have found that on my own

[DWDuck]

Oops, I let my real identity slip! Err..... I mean my OTHER identity. I am the terror that flaps in the night!

No troubles. Microsoft products can be very painful to use.

Darkwing

[lolzzz_321]

I cringe @ VLOOKUP

[stevedonel]

It is easy, but not terribly obvious. Here's how to do it. First select the cell that you want to put the drop down list in. Then under the "Data" menu, go to "Validation". In the "Settings" tab, select "List" in the "Allow" dropdown list. A "Source" box will appear. You can either choose a named list (another fun Excel exercise), or just type a comma delimited list of choices to put in here.

Let me know if you have any troubles with this.

Brad

Is that ALL? How did I not figure that out, on my own?

While we're at it, is there a way to make something like this, but with multiple selections possible?

[™]

It is easy, but not terribly obvious. Here's how to do it. First select the cell that you want to put the drop down list in. Then under the "Data" menu, go to "Validation". In the "Settings" tab, select "List" in the "Allow" dropdown list. A "Source" box will appear. You can either choose a named list (another fun Excel exercise), or just type a comma delimited list of choices to put in here.

Let me know if you have any troubles with this.

Brad

Is that ALL? How did I not figure that out, on my own?

While we're at it, is there a way to make something like this, but with multiple selections possible?

What do you mean multiple selections? Do everything he said, then youll see a box named "Source" underneath where it says Source you can type in the choices with a comma between each. If you want a dropdown menu with these choices...

Fullhouse
Flush
Straight

just type "Fullhouse,Flush,Straight" into that box.

[stevedonel]

What do you mean multiple selections? Do everything he said, then youll see a box named "Source" underneath where it says Source you can type in the choices with a comma between each. If you want a dropdown menu with these choices...

Fullhouse
Flush
Straight

just type "Fullhouse,Flush,Straight" into that box.

The nerd in me wants to sort my spreadsheet by the types of games played. Lately I've been playing in a bunch of mixed games. A round of texas, round of Oh-8, round of stud, round of lowball, ect. Different groups play different games. I'd like some type of check-boxes that I could just click off and use them to sort by, but havent been able to figure it out.

But then, I havent put much time into it, and I probably need to use Access, which I know very little about.

[ngericl]

The nerd in me wants to sort my spreadsheet by the types of games played. Lately I've been playing in a bunch of mixed games. A round of texas, round of Oh-8, round of stud, round of lowball, ect. Different groups play different games. I'd like some type of check-boxes that I could just click off and use them to sort by, but havent been able to figure it out.

But then, I havent put much time into it, and I probably need to use Access, which I know very little about.

To sort your spreadsheet, go to the "Data" pulldown menu and select "Sort." From there you'll be able organize by columns.