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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|