Create List and Drop Down List in Excel 2003

xiaoxiao2021-03-06  45

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 '

转载请注明原文地址:https://www.9cbs.com/read-51698.html

New Post(0)