Headers and Footers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 28 Oct 2003 16:09 GMT

How do I enter a header once and it comes out on all the
pages of my workbook? Right now I have to manually copy
and insert it on each page.

Reply to this Message

Jim - 28 Oct 2003 16:52 GMT

I do not believe you have to do that. The h & f 's are visible when printed
or in print preview, not on the ws.

Signature

Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

> How do I enter a header once and it comes out on all the
> pages of my workbook? Right now I have to manually copy
> and insert it on each page.

Reply to this Message

Don - 28 Oct 2003 17:12 GMT

I don't mean that I manually insert it on each sheet. I
use the header/footer function, but I have multiple pages
in my workbook and want to only enter in header and footer
once and for it to come out on all the sheets.
Thanks, Don

>-----Original Message-----
>I do not believe you have to do that. The h & f 's are visible when printed
[quoted text clipped - 5 lines]
>
>.

Reply to this Message

Chip Pearson - 28 Oct 2003 19:59 GMT

Don,

Select all of the sheets by first clicking the first sheet tab, holding down
the SHIFT key, then clicking the last sheet tab. This will group all the
sheets, and [Group] will appear in the Excel title bar. Now, set up your
headers and footers. The headers and footers will be applied to all sheets.
You can then ungroup the sheets by clicking on any worksheet tab.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com chip@cpearson.com

> I don't mean that I manually insert it on each sheet. I
> use the header/footer function, but I have multiple pages
[quoted text clipped - 13 lines]
> >
> >.

Reply to this Message

- 28 Oct 2003 21:10 GMT

Chip,

Worked like a charm. Thanks for the advice, I'll store it
in my FYI folder for future use as well.

Thanks,
Don

>-----Original Message-----
>Don,
[quoted text clipped - 24 lines]
>
>.

Reply to this Message

Mario - 31 Oct 2003 21:52 GMT

Chip

Is there any way to get the header/footer to automaticly
set every time a new wookbook is opened? I unhid
personal.xls file and set up the default header/footer
that I would like to use, saved the file, re-hid
personal .xls, shutdown excel, and went back into the
program and it didn't bring up the header/footer as a
default setting on the new/blank work book. The
header/footer tab still came up empty and read "none".

Any idea how to get the header/footer to come up
automaticly?

Mario

>-----Original Message-----
>Don,
[quoted text clipped - 24 lines]
>
>.

Reply to this Message

Dave Peterson - 01 Nov 2003 03:06 GMT

You can change it for any new workbooks that are based on a template.

Create new workbook with that style. Then save it in your XLStart folder
(location varies with versions of windows & excel). Save it with the filename
of BOOK.XLT.

Now each workbook you create new will use that as the default.

John Walkenbach has an addin that will help with exising worksheets.
http://j-walk.com/ss/excel/files/addpath.htm

> Chip
>
[quoted text clipped - 63 lines]
> >
> >.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Dave Peterson - 01 Nov 2003 03:16 GMT

And the name of the template in XLStart should be called BOOK.XLT.

> You can change it for any new workbooks that are based on a template.
>
[quoted text clipped - 79 lines]
> Dave Peterson
> ec35720@msn.com

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message