Excel 2003 SP3
Windows XP SP3

I've got an Excel spreadsheet with nearly 700 rows. I've hidden the
appropriate columns so that I can print the data I need on a single page.
However, in Print View I can notice that pages 2 and above do NOT have a
column header to describe the various columns. Without inserting rows and
copying the headers to the first row on each output (PDF, printer etc.) is
there an easy was to put the header row on each page's output 'Row 1'?
TIA

So, Row 1 has the value you'd like, correct?

From worksheet view go to:

File - Page Setup - Sheet

Go to Row to repeat at top: and enter 1:1


"Tom" wrote:

Excel 2003 SP3
Windows XP SP3

I've got an Excel spreadsheet with nearly 700 rows. I've hidden the
appropriate columns so that I can print the data I need on a single page.
However, in Print View I can notice that pages 2 and above do NOT have a
column header to describe the various columns. Without inserting rows and
copying the headers to the first row on each output (PDF, printer etc.) is
there an easy was to put the header row on each page's output 'Row 1'?
TIA

Thanks! For as long as I've used Excel, I've never known this process!!! :-)

"Sean Timmons" wrote:

So, Row 1 has the value you'd like, correct?

From worksheet view go to:

File - Page Setup - Sheet

Go to Row to repeat at top: and enter 1:1


"Tom" wrote:

Excel 2003 SP3
Windows XP SP3

I've got an Excel spreadsheet with nearly 700 rows. I've hidden the
appropriate columns so that I can print the data I need on a single page.
However, in Print View I can notice that pages 2 and above do NOT have a
column header to describe the various columns. Without inserting rows and
copying the headers to the first row on each output (PDF, printer etc.) is
there an easy was to put the header row on each page's output 'Row 1'?
TIA