How do I repeat a row of headings when printing an excel spreadshe

R

RAT53

I want to repeat the column headings I have set in Row 1 on each page when
printing out. It appears you can do this by saying what row you want to
repeat in the Sheet window; however it doesn't say in what format this needs
to be expressed. I tried to just enter a 1 (for Row 1) and it tells me it is
the wrong format. Any advice welcome
 
M

Max

In Page Setup > Sheet tab,

Put in box for "Rows to repeat at top:" $1:$1

(Or, just click inside the box,
then click outside and select any cell in row1)
 
K

Kevin B

$1:$2 repeat rows 1 & 2 when you print the worksheet, this is done by
clicking on File, Page Setup and clicking on the Sheet tab. There is a
button to the right of the
Rows to Repeat at Top field in the Print Titles panel that will take you
back to the worksheet so you can select the rows you want to repeat.
 
P

Pogue

When I do this I click on the row # itself rather than typing anything in.
(Click the grid box to the right of the input bpx and then click the row #.)

The format that came up when I just did this was $7:$7
 
Top