The sample file is attached.
In the A column and D column, I want to increase the series,
e.g in A column 5*3, 5*5, 5*7, 5*9, 5*11, 5*13, 5*15 and so on.
in D column 7*3, 7*5, 7*7, 7*9, 7*11 and so on
In A column I do it by selecting A1 to A9 and then drag to say A1000. Similarly D column. I don't want to drag this to A1000 rows. Is there a way, this can be done like with the FILL option, selecting A1 to A1000 and the series is filled.
Thank you.
Bookmarks