Numerous methods are there in excel to create sequence of numbers. Here, we are going to discuss about the basic methods. We can create without any usage of functions through user interface, but it will be static. If the data changes, sequence of numbers will not get updated. let's discuss about that method.
Method 1:
Enter the starting number of sequence in A1(For ex., 1), In home tab, Editing group located at the right most end, that's where fill option resides. If we click drop down menu, we can see series option.
in that series dialog box select columns, if you want fill series in column, we can change the step value based on our requirement. Here I am going to leave the default value of 1 as it is. Then in stop value, enter the last number in your series, in our case I entered 20.
Method 2:
We can populate sequence of numbers across rows and columns using this method. To initiate the sequence, we should provide the pattern as shown below.
Provide first 2 numbers of sequence in cells, after selecting those cells get the mouse pointer at the right bottom of the selection. You can see that cursor change into four headed pointer as shown in picture. Now, long press the left side button in mouse and extend the selection till the cell where you want to stop the sequence.
Method 3:
Instead of 2 numbers, enter the first number in sequence, then move your cursor into right side bottom corner in cell, press 'ctrl' button in keyboard (Do not release the press until the last cell) and extend your selection by long press in left side button of mouse.
Method 4:
Enter the start number in one cell, then move your cursor into right side bottom corner in cell, drag the selection down by pressing the left side button in mouse by long press. Once the last cell of range reached, release the mouse click. All numbers in that range will similar as the start number, but don't worry. You will see the Flash options tag at the right bottom of the cell, Click the drop down menu in that tag and select Fill series option. Then all those numbers get incremented by one.
Comentarios