so I have to go through these motions to copy it say, 30 times?

"T Kirtley" wrote:

Yes, you can copy a range and paste it down the spreadsheet. Just select the
range you want to copy, press Ctrl^C to copy the range to the clipboard, then
select the range to copy it to and press Ctrl^V to paste the range into the
area selected. However, you must be sure that the range you select to copy to
is an even multiple of the rows that you are copying from.

For instance, if you want to copy the range A1:D30 you could paste it into
ranges like A1:D60 or A1:D300, but the paste will fail if you try to paste it
into a range of A1:D61 or A1:D301.

HTH,

TK

"oceanmist" wrote:

Ihave a small spreadsheet I created in a worksheet. I need to copy this
spreadsheet repeatedly down the spread sheet. For example, the form is 30
rows long and I have ti typed on rows 1-30. I need to copy it to rows 31-60
and row 61-90 and so on. Is there an easy way to do this?