How to create a list in Microsoft Excel Data Series

In addition to the data series number or date, you can also create a list of the data series itself. For example, you create a data series name of your company's employees. This technique would be very helpful if the data series are frequently used.1. Press Ctrl + N to create a new workbook. Click the Office Button and then press the button Excel Options. Excel Options dialog box appears.

2. Select the option line and press the Edit Custom List. Custom dialog box will appear List. Enter a series of data in the text box list entries: like the example image below.

 
3. If so, press the Add button. If there is no data series you'll make again press OK. 

4. Will reappear Excel Options dialog box and then press OK.

5. To try typing Roy result in cell A2. Drag the fill handle in cell A2 down until cell A8. The result will be like this.

 
Listing data series can also be derived from the range that contains specific data. For example, you create a list of data series subsidiary contained in range A1: A10.

1. Press Ctrl + N to create a new workbook. Type a company branch data in the range A1: A10 as in the image below.

 
2. Click the Office Button and then press the button Excel Options. Excel Options dialog box appears. Select the option line and press the Edit Custom Lists. Custom Lists dialog box appears.

 3. Import list in the text box cells: Type $ A1: $ A $ 10, the range of sources used in the data series. 

4. The move can also be done by pressing the button on the right of the Import list box From cells: Collapse Options dialog will appear as shown in the example image below.

 
5. Block range A1: A10 (the block is marked with dashed lines) and then press the button. 

6. Reappeared Custom Lists dialog box and then press the Import button. Range of data series that have been entered will look something like this.Press OK

 
7. Will reappear Excel Options dialog box and then press OK. 

8. To try the American Branch of the result type D1. Pull Handle on cell D1 fill down until the cell D10. The result looks like this.

 
Similarly, a brief description of me on How to create a list in Microsoft Excel Data Series. May be useful for you all.