If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Place source to drop down list in another spreadsheet
What do I do when I wan't to use validation from a list, but I do not want
the list to be visible on the spreadsheet? If I hide the rows containing the list, the hidden values also becomes hidden in the list. And If I link to a source list in another spreadsheet, I get an error. |
#2
|
|||
|
|||
Place source to drop down list in another spreadsheet
Don't hide the column with the validation list. Set the font color of the
items in that column to the same as the color of the cell. In the column the list will be invisible, in the dropdown the list will still be visible. -- Gary''s Student - gsnu200729 |
#3
|
|||
|
|||
Place source to drop down list in another spreadsheet
And If I link to a source list in another spreadsheet, I get an error.
If you use a named range/list, you can get it to work .. Eg, in: DV Settings tab ---------- Allow List Source: =MyList where MyList is a named range refering to the DV items in say, Sheet2 For more info, try Debra's page at: http://www.contextures.com/xlDataVal01.html -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "PRO1306" wrote: What do I do when I wan't to use validation from a list, but I do not want the list to be visible on the spreadsheet? If I hide the rows containing the list, the hidden values also becomes hidden in the list. And If I link to a source list in another spreadsheet, I get an error. |
Thread Tools | |
Display Modes | |
|
|