How do you carry the first row of information to the other pages .

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

Guest

I want to take the headings from my first page and automatically use them as
headers for the rest of the pages. How do I do that?
 
Go to "File | Page Setup | Sheet"

Under "Rows to repeat at top" click on the arrow and then select your rows.
I.e., if you want the first three rows to be header for all other sheets, it
will put in $1:$3.

Hope this is helpful to you.
 
LoriM has made a good suugestion if you want to print the headers on each
page.

If by "pages" you mean "worksheets" and you don't mean when printing, you can
select all the sheets(r-click and "select all sheets") and type your
headers/titles on one sheet and they will be entered on all selected sheets.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben 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

how to carry forward a total from one page to another 3
word 2003 - How do I make the first page header a different size from the other pages? 0
I swapped my CPU, how do I carry over all my programs and settings? 1
Print Setup 3
Different First Page? 2
Excel Unique last page footer 1
Macro to determine row of page break on modified presentation sheet? 2
Repeating first Row AND first column on every page 1

Back
Top