Row 1 HEADERS on EVERY printed page

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
 
S

Sean Timmons

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top