Drop-down List
来源:互联网 发布:32单片机蜂鸣器程序 编辑:程序博客网 时间:2024/05/20 09:10
Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.
1. On the second sheet, type the items you want to appear in the drop-down list.
2. On the first sheet, select cell B1.
3. On the Data tab, click Data Validation.
The 'Data Validation' dialog box appears.
4. In the Allow box, click List.
5. Click in the Source box and select the range A1:A3 on Sheet2.
6. Click OK.
Result:
Tip: If you don't want users to access the items on Sheet2, you can hide Sheet2. To achieve this, right click on the sheet tab of Sheet2 and click on Hide.
7. You can also type the items directly into the text box, without using Sheet2. This gives the exact same result.
- spinner (drop down list)
- Drop-down List
- MVC drop down list
- CComboBox Drop down 和 Drop List 不同
- Height of CComboBox's drop down list
- Drop-down list in OA Framework
- Android Spinner (Drop Down List) Example
- drop-down
- create list and drop down list in Excel 2003
- 多选下拉框 multiple select drop down list
- Some points about postback and multi-language drop down list
- Format Date in Custom Drop Down List in Ext.Net
- Drop down list 和 Comb box 的区别
- Excel 2010 create drop down list and Lookup usage
- 组合框(下拉列表)(Combo box(drop-down list))
- Remedy Developer Stuido Drop-Down List 和 Character的default value的区别
- dynamic-drop-down-box.jsp
- Spring Form Tags - How to use Text Box, Radio Button, Check Box and Drop Down List in Spring
- Git merge和git branch 分支与合并
- RelativeLayout常用属性介绍及实例讲解
- 约瑟夫环(递推)
- PHP/python 内建服务器 轻便测试走起
- (转)处理ios6到ios7后UITableView的两个显示问题
- Drop-down List
- ContentObserver
- KAFKA分布式消息系统
- LNMP一键安装 1.1版本
- SharePoint2013 App添加ribbon
- pow(x,n) 为什么错这么多次
- 避免不必要的float
- java中volatile关键字的使用
- poj 1163 The Triangle &poj 3176 Cow Bowling (dp)