| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
-----Original Message----- You can use Data Validation to create a dropdown list in a cell. There are instructions in Excel's help, and he http://www.contextures.com/xlDataVal01.html Ken wrote: Excel 2000 ... Earlier today I saw a spread sheet that had what appeared to be a Filter Switch in a Cell. When cell with switch selected ... switch listed 2 values to choose from (Y or N) ... In addition, as different cells (requiring same Y or N value) were selected the switch moved to selected cell. Above said ... how is this all accomplished as I wish to replicate this capability on another spread sheet? Thanks ... Kha -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
