Suppose we want to create a sequence of numbers with an interval of 3(Multiplication table for 3 in excel)
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.
Step 2
Select the rows or columns to fill with the sequence.
Step 3
Press Alt+E+I+S to get the series wizard in your excel as shown below
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.
Press OK and you will have your series with interval 3 or multiplication table for 3.
Hope this helped.
