Create Sequence Of Numbers With Fixed Interval Between Them In Excel

Suppose we want to create a sequence of numbers with an interval of 3(Multiplication table for 3 in excel)

Capture

Step 1

Insert the value you want your sequence to start with, as I want to start the sequence with 3, I have inserted 3.

Capture




Step 2

Select the rows or columns to fill with the sequence.

Capture

Step 3

Press Alt+E+I+S to get the series wizard in your excel as shown below

Capture

Step 3

Insert the step value in the box by which you want your series to increment, as I intend to create a series with step value 3, I have put 3 in the step value.




Capture

Press OK and you will have your series with interval 3 or multiplication table for 3.

Capture

Hope this helped.




Share The Knowledge

Random Posts

Leave a Reply