Printing

[Mira]

How do I set that on all the worksheets that I print
appear the current date without setting it on each
worksheet alone?
I mean that each new sheet will automatically have a date
on it.
Thanks

 

[Frank Kabel]

Hi
one way:
- open your file
- select all sheets (group them, e.g. hold down the SHIFT
key and select the first and last sheet)
- set the header/footer

Now the header/footer is applied to all sheets

 

[Guest]

Thanks but what I mean is to that each file and sheet I
will make from now on will automatically appear with a
date.
Is it possible?
Thanks again

 

[Frank Kabel]

Hi
- create a new workbook
- format this to your needs
- save this workbook as 'book.xlt' template in your excel
startup folder

For more: See the excel help for -'Template'

 

[Gord Dibben]

Maybe also save as SHEET.XLT which would become the default Insert>Sheet.

No need to open a new workbook to add a sheet to an existing workbook.

Gord Dibben Excel MVP