Copy a range of cells repeatedly

  • Thread starter Thread starter Exceller
  • Start date Start date
E

Exceller

I am trying to copying a range of cells eg. 10 rows/1 column down repeatedly
on the same spreadsheet about 50 times. Is there a macro I can use to caopy
the rows without having to copy and paste 50 times manually?
 
Select all the 10 cells.
*Right* click on the fill handle of that 10 cell selection and drag down to
Row 500.

When you release the mouse, from the dialog box choose "Copy Cells".
 
Back
Top