Printing 1st row in every page..

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

Dear All,

In Microsoft Excel 2000 a user may freeze the first row/pane
(Window menu/Freeze panes) so that it's always viewed
regardless where he is in the spreadsheet.

Is there something similar so that the first row becomes
the printing header row so when printing a 24 pages spreadsheet
every page beggins with that first row?

Thanking you in advance for your help,
Carlos.
 
Carlos said:
Dear All,

In Microsoft Excel 2000 a user may freeze the first row/pane
(Window menu/Freeze panes) so that it's always viewed
regardless where he is in the spreadsheet.

Is there something similar so that the first row becomes
the printing header row so when printing a 24 pages spreadsheet
every page beggins with that first row?
Click to expand...

File > Page Setup > Sheet > Rows to repeat at top and simply select the row
you want.

Andy
 

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

Similar Threads

How to freeze a range in excel 2003and 2007 1
Row heights change when printing bug? 1
Print macro that hides rows before printing 1
help with page breaks 1
Page Headers and Frozen Columns 2
How do I specify row 1 as header row that is to be printed on every page, regardless of other page s 3
Print first row on each page 2
VLOOKUP and highlight row 6

Back
Top