1patrick (不停游的鱼)
1.select the cell where you want a list.
2.select menu: Data>Validation
3.under Settings Panel:
- Under Allow: select List;
- Under Sources: select the field where you put your list content. or select the icon in the right side of sources box: for example, if you want the listbox contains a, b, c, d, e... you can put a b c d e in cells H2, H3, H4, H5, H6. The in sources you put in =$H$2:$H$6 or select the icon to pick the fields by mouse.

Usually, those list content are put in columns far far away, such as colume Z or AA, so you won't see it. And you can shrink the column width to make them sort of disappeared.

If you still have problem, send me your phone, I will let you know.
Have fun.
2001-10-15 -04:00
This post has been archived. It cannot be replied.
Page address has been copied. To share, click to copy page address.
Share Online by QR Code

Back To Topic: 请问各位DX一个问题。想在WORK或EXCEL 加入一个下拉是菜单选项(COMBO BOX),想知道里面的东西是怎么”放“进去的?

Back To Forum: HOME枫下论坛枫下论坛主坛枫下沙龙谈天说地