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.