If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Headers and Footers
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. |
#2
|
|||
|
|||
Headers and Footers
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. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Don" wrote in message ... 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. |
#3
|
|||
|
|||
Headers and Footers
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 or in print preview, not on the ws. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Don" wrote in message ... 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. . |
#5
|
|||
|
|||
Headers and Footers
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, 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. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Don" wrote in message ... 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 or in print preview, not on the ws. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Don" wrote in message ... 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. . . |
#6
|
|||
|
|||
Headers and Footers
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, 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. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Don" wrote in message ... 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 or in print preview, not on the ws. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Don" wrote in message ... 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. . . |
#7
|
|||
|
|||
Headers and Footers
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 Mario wrote: 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, 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. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Don" wrote in message ... 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 or in print preview, not on the ws. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Don" wrote in message ... 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. . . -- Dave Peterson |
#8
|
|||
|
|||
Headers and Footers
And the name of the template in XLStart should be called BOOK.XLT.
Dave Peterson wrote: 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 Mario wrote: 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, 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. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Don" wrote in message ... 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 or in print preview, not on the ws. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Don" wrote in message ... 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. . . -- Dave Peterson -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|