MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Header on First Page only - Footer on every page

Posted by Kendra Strong on May 30, 2001 5:40 PM

Is there a way to put a header on the first page only
and have the footer repeat on every page?

Posted by Kevin James on May 30, 2001 7:17 PM

Right tool for the right job

Hi Kendra,

You can study VBA and probably come out with a winning answer, but you probably want something you can use right away.

Suggestion 1:
Put the header in the spreadsheet itself, this will cause it to pring only on the first page.

Suggestion 2:
MS-Word has the ability to change header and footer on each page. Try exporting the data to Word.


Posted by jonathan on May 30, 2001 8:19 PM

Posted by jonathan on May 30, 2001 8:25 PM

Very frustrating. I'm unable post a message in the normal fashion so I have to tag onto someone else's message. My apologies. Perhaps someone can enlighten me as to how I may leave my very own message with my very own posting.

My excel problem is as follows: I made a folder entitled 'my excel' and transferred workbooks to it from 'my documents'. It resides on the desktop and in the C drive. Now, when I attempt to save to that folder I find it empty - some of the time. Also, I open excel with a particular workbook from XL Start. That workbook rarely finds itself in my wandering 'my excel' folder even when I make a point of saving it directly to that folder. What's up? How come I have multiple folders?

Again, my apologies Sandra.


Posted by Kevin James on May 30, 2001 10:13 PM

Postings and folders & puppies tails


First to address you posting problem. You need to allow the message board to load completely. It usually takes up to a 30 seconds or more. If pressing the link to post a new message doesn't work, scroll to the bottom of message listings and you will find the new posting form at the end of all the messages.

Next, regarding your folders, though I hate to say it, it is most probably user error.

From Windows Explorer (not IE), click on the root of c in the left pane and then right click on that icon and choose Find ("Search" in WinME). Perform a search on your folder name you will probably find you have created multiple instances of the same folder name in different directories. While this is not bad in itself, it is certainly confusing for you as the user.


Posted by jonathan on May 31, 2001 4:46 AM

Correct on all counts; thanks, Kevin (nt).

nt = no text