I get an error message when I enter rows 123456 in the rows to repeat at top
box.

Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.

I do my best not to type this in that box.

I'll just use the mouse and point at the rows I want to repeat at top. I'll let
excel figure out how to enter the value.

Geoff W wrote:

I get an error message when I enter rows 123456 in the rows to repeat at top
box.

--

Dave Peterson

"Dave O" wrote:

Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.

FINALLY, SOMEONE TELLS YOU EXACTLY HOW TO LIST IT. THANK YOU SO MUCH. I
ONLY WANTED ROW 1 REPEATED SO I HAD TO LIST IT $1:$1. HOORAY!

"Dave O" wrote:

Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.

The easy way is to select the row or rows you want, and that will fill in
the dialogue box for you.
--
David Biddulph

"BONNIE B" <BONNIE wrote in message
...
FINALLY, SOMEONE TELLS YOU EXACTLY HOW TO LIST IT. THANK YOU SO MUCH. I
ONLY WANTED ROW 1 REPEATED SO I HAD TO LIST IT $1:$1. HOORAY!

"Dave O" wrote:

Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.

Thanks! I was getting flustered.

"Dave O" wrote:

Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.

Thanks! just what I needed

"Dave O" wrote:

Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.

"Dave O" wrote:

Enter it like this:
$1:$6
.... to indicate rows 1 thru 6.



but it adds pages. instead of 17 pages only, it adds to 34.