|
Grand_MasterB
|
04-20-2005, 04:08 PM
Post subject: Excel Help!
|
#1 (permalink)
|
|
Flush
Join Date: Jul 2004
Location: Cincinnati
Posts: 466
|
|
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!
|
|
|
Play for FREE and practice your game at...
Join the FTR Poker Forum to disable these banners and start posting!
|
|
DWDuck
|
|
Straight
Join Date: Jan 2005
Location: Canada eh?
Posts: 178
|
|
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
|
|
Flush
Join Date: Jul 2004
Location: Cincinnati
Posts: 466
|
|
Thank you so much Brad! I never would have found that on my own
|
|
|
|
DWDuck
|
|
Straight
Join Date: Jan 2005
Location: Canada eh?
Posts: 178
|
|
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
|
|
NO YOU
Join Date: Oct 2004
Location: My ice is polarized
Posts: 2,797
|
|
I cringe @ VLOOKUP
|
|
|
|
stevedonel
|
|
Full House
Join Date: Aug 2004
Location: Vegas
Posts: 617
|
|
Quote:
|
Originally Posted by 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
|
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?
|
|
Is that guy still part of the forum??
|
|
™
|
|
Straight
Join Date: Jan 2005
Location: MA
Posts: 144
|
|
Quote:
|
Originally Posted by stevedonel
Quote:
|
Originally Posted by 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
|
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
|
|
Full House
Join Date: Aug 2004
Location: Vegas
Posts: 617
|
|
Quote:
|
Originally Posted by ™
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.
|
|
Is that guy still part of the forum??
|
|
ngericl
|
|
Straight
Join Date: Oct 2004
Location: Los Angeles
Posts: 119
|
|
Quote:
|
Originally Posted by stevedonel
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.
|
|
ningster
My only purpose in life is to serve as a warning to others.
"Your best hand isn't just the hand with which you have the best cards, it's the hand with which you find yourself in the best position to make money." -- Daniel Kimberg
|
English
Deutsch
Español
Français
Italiano
Nederlands
Pусский
Svenska
05-26-2012, 03:08 PM Australia Legalized Online Poker coming up in next 6 to 12 Months
Linear Mode
