Making Series Serial Data In Microsoft Excel

Serial Data Series is a series of data most commonly used Excel users. Therefore, Excel provides a special technique to allow users to create data series number, for example using the key combination Ctrl to speed up the manufacturing serial number of the data series.

1. Press Ctrl + N to create a new workbook. Type the initial value of the data series in cell A2, such as type 1. Place the pointer in cell A2.

2. Move the pointer on the black frame in the lower right corner of cell A2 (fill handle). Click and hold the deed and then pull down the handle to the cell A11.

 
3. Range A2: A11 initially be charged the same data, ie 1. To transform the data into a series of sequential data click the AutoFill Options drop down menu and select Fill Series. As shown below.

 
To Make the serial number of the data series quickly use the Autofill feature in combination with the Ctrl key on the keyboard as you pull the Fill Handle. Type 1 into cell B2 as the initial value of the data series. Press and hold down the Ctrl key. Drag Fill Handle to cell B2 down to B11 cells. The result looks like the picture below.

 
You also can create a data series with a serial number of a certain multiples. For example, you create a data series starting from 1 to 15 in increments of 2.

1. type 1 as the initial value in cell C2. Because the serial number is any multiple of 2, type 3 into cell C3.

2. Block Range C2: C3 then drag the fill handle in cell C3 down to the desired value.

 
A few brief explanation of my series on How to Make Serial Data In Microsoft Excel, May be useful for you all.