Copying data to multiple rows and columns

Hi All,

Say I have the number 1 in cell A1, the number 2 in cell B1, and the number 3 in cell C1. If I wished to continue this pattern up to the the number 10 I could highlight
the cells and drag across to cell J1. But what if I want to drag it across and down as well so that:

A1 = 1, B1 = 2, C1 = 3, D1 = 4, E1 =5
A2 = 6, B2 = 7, C2 = 8, D2 = 9, E2 = 10

I have been trying to find an answer to this for a while now however I have not been able to come up with a search term that results with an answer. I am hoping
that I explained my question well enough however if you need more info I am more than happy to supply it.

Thanks for your reply. Just a little note... I was actually able to copy that to as many columns as I would like. Not sure why.
That formula worked well, but what if I wanted to copy something besides numbers? For example, if I created a calendar and
wanted to quickly set up the dates in the calendar, or if I had a formula that I wanted to continue to the next row. How would
I go about doing that?

Bump - Anyone?