Drag sequence number automatically in Microsoft Excel

In order to automatically drag sequence or serial number we have to drag numbers as :

Example

Write at least two numbers in cells, and then position your mouse in the lower right corner until fill handle is enable (marked in red), when fill handle is enable, Drag the cursor to the required cells as :

Step 1 Step 2
auto sequence auto sequence 2

and then the auto sequence is marked :

Video

Share

You may also like...