create list and drop down list in Excel 2003

原创 2005年03月02日 16:36:00
create list 1. Highlight the range of data that you want make into a list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.). Note You can also select the range of cells to be specified as a list by selecting the range of cells from the Create List dialog box. 2. On the Data menu, point to List, and then click Create List. 3. If the selected data has headers, select the My list has headers check box and click OK. The selected range of data is highlighted by the list indicator, and the most common list related functionality is made available on the List toolbar. Note If you don't see the List toolbar, on the View menu point to Toolbars, and then click List. After the list has been created, it will be identified by a blue border. In addition, AutoFilter drop-downs will be automatically enabled for each column in the list and the insert row will be added as the last row or the list. If you choose to add a total row by clicking Toggle Total Row Button image on the List toolbar, a total row will be displayed under the insert row. When you select a cell, row, or column outside of the list, the list becomes inactive. An inactive list is surrounded by a blue border and does not display the insert row or AutoFilter drop-downs. Note The border will not be displayed if you clicked Hide Border of Inactive Lists on the List menu. create dropdown list 1.Select the cell where you want the drop-down list. 2. On the Data menu, click Validation, and then click the Settings tab. 3. In the Allow box, click List. 4. If the list is in the same worksheet, enter a reference to your list in the Source box. 5.If the list is elsewhere, enter the name you defined for your list in the Source box. 6.Make sure the reference or name is preceded with an equal sign (=). 7. Make sure the In-cell drop-down check box is selected. 8. Specify whether the cell can be left blank: Select or clear the Ignore blank check box. 9. To display optional input instructions when the cell is clicked, click the Input Message tab, make sure the Show input message when cell is selected check box is selected, and then fill in the title and text for the message. 10.Specify how you want Microsoft Excel to respond when invalid data is entered.

相关文章推荐

Some points about postback and multi-language drop down list

/*By Jiangong SUN*/ Cultures.ascx.cs: public partial class Cultures : System.Web.UI.UserCo...

Drop Down List

  • 2014年01月02日 15:22
  • 35KB
  • 下载

Use linked list to create queue stack BST in C

Use linked list to create queue stack BST in C

A.Drag.and.Drop.List.Control

  • 2010年01月18日 22:24
  • 11KB
  • 下载

How to Activate the Drop Down Menu in MOSS 2010 Sites

MOSS 2010 sites can display drop down menus in the tabbed navigation across the top.  Unfortunately ...

A Drag and Drop List Control文件和Demo

  • 2013年05月02日 22:00
  • 38KB
  • 下载

About UID and How to autostart an application on boot up in 3rd- Startup List Management API

Overview UID of self-signed applications Description S60 3rd Edition introduces mandatory signing fo...
  • cyforce
  • cyforce
  • 2011年04月04日 00:11
  • 799
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:create list and drop down list in Excel 2003
举报原因:
原因补充:

(最多只允许输入30个字)