Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to email my spreadsheet to someone regarding drop down list | Excel Discussion (Misc queries) | |||
extract data from a random list & place in another ordered list | Excel Discussion (Misc queries) | |||
Adding drop-down list to spreadsheet | Excel Discussion (Misc queries) | |||
create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions |