A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

uniform headers on Excel worksheets



 
 
Thread Tools Display Modes
  #1  
Old October 11th, 2006, 12:11 PM posted to microsoft.public.excel.setup
Timbertoe
external usenet poster
 
Posts: 1
Default uniform headers on Excel worksheets

I want to print a worksheet each week from one workbook. I want the headers
to be uniform from worksheet to worksheet without having to enter the text
for each worksheet. Additionally, I would like to have the date of the last
day to pring in the header. Who knows the secret?
  #2  
Old October 11th, 2006, 07:23 PM posted to microsoft.public.excel.setup
Pete_UK
external usenet poster
 
Posts: 8,780
Default uniform headers on Excel worksheets

You can set up identical headers in all worksheets by grouping them all
and apply the header once. Right-click on a sheet tab and click on
Select All Sheets. Then click on File | Page Setup | Header/Footer tab
then click Custom Header and enter your text into one of the three
panels. If you want to enter the current date, click on the symbol
which looks a bit like a calendar - "7" covering "6".

Once this is done, OK your way out of it, and then right-click a sheet
tab once more and Ungroup Sheets.

Hope this helps.

Pete

Timbertoe wrote:
I want to print a worksheet each week from one workbook. I want the headers
to be uniform from worksheet to worksheet without having to enter the text
for each worksheet. Additionally, I would like to have the date of the last
day to pring in the header. Who knows the secret?


  #3  
Old October 12th, 2006, 09:56 AM posted to microsoft.public.excel.setup
FloMM2
external usenet poster
 
Posts: 189
Default uniform headers on Excel worksheets

Timbertoe,
Or you could setup one worksheet, then save as a Template.
Then everytime you open the template, save as "New Name ", Save as type:
*.xls.
This way if you decide to change the format, change your template only. The
next time you open the worksheet and save, it will be as the new template.
Hope this helps.

"Pete_UK" wrote:

You can set up identical headers in all worksheets by grouping them all
and apply the header once. Right-click on a sheet tab and click on
Select All Sheets. Then click on File | Page Setup | Header/Footer tab
then click Custom Header and enter your text into one of the three
panels. If you want to enter the current date, click on the symbol
which looks a bit like a calendar - "7" covering "6".

Once this is done, OK your way out of it, and then right-click a sheet
tab once more and Ungroup Sheets.

Hope this helps.

Pete

Timbertoe wrote:
I want to print a worksheet each week from one workbook. I want the headers
to be uniform from worksheet to worksheet without having to enter the text
for each worksheet. Additionally, I would like to have the date of the last
day to pring in the header. Who knows the secret?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.