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

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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RAT53" wrote in message
...
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

$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.
--
Kevin Backmann


"RAT53" wrote:

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

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


"RAT53" wrote:

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

To repeat row 1 enter $1:$1

"RAT53" wrote:

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