Printing

  • Thread starter Thread starter Mira
  • Start date Start date
M

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
 
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
 
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
 
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'
 
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
 
Back
Top