Assuming data is in A1:F30

Right-click on A1. Drag across to F1 then drag down as far as you wish.

i.e. down to row 300

Release button and select "Copy Cells"


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 12:02:01 -0700, 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?