Is there a way in excel to change the way excel drags cell contents?

So for instance I have listed 1-10 listed from top to bottom. I want to have a separate cell
referencing this 1-10 but I want to drag cell going horizontally 1-10. Is the only way to do this by a vlookup or index + match formula?