use a range for a print header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need the first 3 rows of my spreadsheet to show as a header on every page.
I have a lot of columns with numbers in them and need a header to follow
through on each page.

Thanks you for any help.
SJL
 
File>Page Setup>Sheet.

Rows to repeat at top.

Enter $1:$3


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Use rows 1-3 for header on all 13 pages 2
printing a header in Excel 2
Row 1 HEADERS on EVERY printed page 2
Showing Letters For Column Headers Rather Thann Numbers ? 1
Access Page Header with merge field 0
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Printing header rows.. 5
Header 1

Back
Top