Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Tools Options > Custom Lists Tab< Previous | Next > 

 

Custom Lists

 
   
 

Custom lists - There are four lists available by default and these are to help with entering days and months. Click a list that you want to edit, or click New List in the Custom lists box to create a new list, and then type the entries in the List entries box. The first character cannot be a number. You can use the Enter key to separate each entry.

 
 

Add - Allows you to create a new custom list. For more details on how to creating custom lists, please refer to the Custom Lists page.

 
 

Delete - Removes a custom list, confirm the deletion by pressing OK.

 
 

Import list from cells - To import list entries from a worksheet range, click in the Import list from cells box, select the range on the sheet, and then click Import. The worksheet range must have each entry in a separate cell. The first character of an entry cannot be a number.

 
 

Import - Creates a custom list from existing items that you've listed in a worksheet range. Click in the Import list from cells box, select the range on the sheet, and then click Import.

 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >