G Guest Sep 24, 2004 #1 I am trying to set up the print setup so that the 2 top rows are repeated at the top of each page printed....help please!
I am trying to set up the print setup so that the 2 top rows are repeated at the top of each page printed....help please!
M Max Sep 24, 2004 #3 Click File > Page Setup > Sheet tab Under Print Titles, input* in box for: Rows to repeat at the top: $1:$2 (rows1 and 2, for example) Click OK *Instead of keying-in, you could also just click inside the box, then click outside on any cell in row1, say select B1 and drag down to B2 This'll also give return "$1:$2" inside the box
Click File > Page Setup > Sheet tab Under Print Titles, input* in box for: Rows to repeat at the top: $1:$2 (rows1 and 2, for example) Click OK *Instead of keying-in, you could also just click inside the box, then click outside on any cell in row1, say select B1 and drag down to B2 This'll also give return "$1:$2" inside the box
