Printing the first two rows as headers.

  • Thread starter Thread starter J. Michael Morse
  • Start date Start date
J

J. Michael Morse

I would like to have the first two rows print at the top of every page
of my print out. I know this is a basic function, yet I can not seem to
find it in the help function. Could someone please post how to do
this /AND/ tell me what key words to put in the search/help function
that would show the answer as well.

Thanks

Michael


--
J. Michael Morse
(e-mail address removed) <mailto:[email protected]>

St. Ignatius <C:/Parish%20Administration/Graphics/Bulletin/Ignatius2C.jpg>

"Let no one ever come to you without leaving better and happier." -
Mother Teresa
 
Hi Michael,

File>Page Setup, Sheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I would like to have the first two rows print at the top of every page
| of my print out. I know this is a basic function, yet I can not seem to
| find it in the help function. Could someone please post how to do
| this /AND/ tell me what key words to put in the search/help function
| that would show the answer as well.
|
| Thanks
|
| Michael
|
|
| --
| J. Michael Morse
| (e-mail address removed) <mailto:[email protected]>
|
| St. Ignatius <C:/Parish%20Administration/Graphics/Bulletin/Ignatius2C.jpg>
|
| "Let no one ever come to you without leaving better and happier." -
| Mother Teresa
 
File|Page setup|Sheet Tab|
type: 1:2
in the rows to repeat at top box.
 
Also note you cannot enter the row values if you open the SetUp dialog from
within PrintPreview; you must use the File|PageSetup route.
 
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

Header - print on first page only? 1
How do I specify row 1 as header row that is to be printed on every page, regardless of other page s 3
Formatting As Table with OUT header row formatting 5
in an Excel database, comparaison between two columns with "almost"the same names => how to search i 1
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
Excel print area which only prints pages of worksheet which are active 0
make First row Header 3
Repeat rows or columns as headers when printing? 2

Back
Top