LearnFast.Ninja

Auto fill sequence numbers in Excel 2010

How to create sequence numbers in quick way. For example: write 1 then create sequence up to 7 in one click.

Step 1: Write number > Select the cell.


Step 2: Locate the cursor on the cell right bottom border > press Ctrl and drag down your cursor.


Step 3: Release the cursor.

Result:


Tags

excel

excel-2010-basics sequence