A1:A5 will give you 5 rows repeated

For more than one row the general syntax is................

$1:$x where x is row number


Gord Dibben MS Excel MVP


On Sat, 21 Jun 2008 21:37:00 -0700, TGS wrote:

Page Setup, Sheet, field "rows to repeat at top" then the tricky thing is
enter a range, eg "A1:A5". If you have more than one row, I'm lost.