|
| Posted By |
Message |
sticklee
LIF Adult
Member since 8/06 2984 total posts
Name:
Stick
|
MS Excel help
i have a workbook with two tabs. in the first tab i have a column where i want all of the cells to be either "yes" or "no". on the second tab i've created the selections "yes" and "no".
on the first tab i have the drop-down arrow but it is referring to the wrong selection group. how do i get it to point to the right group of values?
thanks!
|
Posted 1/24/08 12:09 PM  |
| |
|
Long Island Weddings
Long Island's Largest Bridal Resource |
HeatherRose
Life is Good :)
Member since 11/07 6605 total posts
Name:
|
Re: MS Excel help
highlight the section, right click, click format cells and pick what you need it to do
|
| Posted 1/24/08 12:10 PM |
| |
|
sticklee
LIF Adult
Member since 8/06 2984 total posts
Name:
Stick
|
Re: MS Excel help
Posted by HeatherRose
highlight the section, right click, click format cells and pick what you need it to do
hmm... which option under format cells?
|
| Posted 1/24/08 12:16 PM |
| |
|
MrsMerlot
Unconditional Love
Member since 4/06 6005 total posts
Name:
Chrissy
|
Re: MS Excel help
you can email me the excel sheet if you want...
You'll have to step into the formula, and change the options on the second workbook for the drop-down selection.
|
| Posted 1/24/08 12:24 PM |
| |
|
Wendy
Wheeee!
Member since 5/05 13736 total posts
Name:
|
Re: MS Excel help
Data Validation>Allow>List
Under source put the range of the list
Once it works, copy down ...
|
| Posted 1/24/08 12:25 PM |
| |
|
sticklee
LIF Adult
Member since 8/06 2984 total posts
Name:
Stick
|
Re: MS Excel help
Posted by Wendy
Data Validation>Allow>List
Under source put the range of the list
Once it works, copy down ...
perfect.
thanks everyone for your help
|
| Posted 1/24/08 12:36 PM |
| |
|
Potentially Related Topics:
Currently 748925 users on the LIFamilies.com Chat
|
