1. define a list in the excel, choose the cell range and right click to choose 'define name', then a list is created.
2. click on the cell, data panel , choose validation , then source input the list name above defined.
3. to edit/delete the defined names, use ctrl + F3 key.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12374161/viewspace-717019/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12374161/viewspace-717019/