Row 1 HEADERS on EVERY printed page

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

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
 
Back
Top