Setting date and time default

  • Thread starter Thread starter Darrel
  • Start date Start date
D

Darrel

I want to set a default in Excel such that every time I
open a new Workbook, the current date and time will always
be displayed and print when any sheet is printed.

The goal is, for audit purposes, to follow the flow of
work by having the date and time printed on every Excel
document produced. I want to go to each workers' Excel and
set a property such that this date/time print will be a
default for every sheet, removing the risk the Excel user
forgets to manually set either a footnote or cell
containing this info.

My 'trial and error' efforts have not found a way to do
this yet so I am looking for suggestions. Thanks.
 
Hi
use the worksheet function
=NOW()

or goto the menu 'File - Pagesetup' and insert the date/time in your
header/footer

An to make this available to all worksheets/workbooks save this file as
'book.xlt' and save it in your Excel startup folder
 
or goto the menu 'File - Pagesetup' and insert the date/time in your
header/footer

An to make this available to all worksheets/workbooks save this file as
'book.xlt' and save it in your Excel startup folder
Click to expand...


Which will adjust only the current(active sheet) in the workbook.

To make all worksheets in the Template workbook default to your wishes, select
all sheets and set the header as you wish THEN save as Book.xlt.

Store this workbook in your XLSTART folder.

Another option....Set up the header/footer for one sheet and save as Sheet.xlt
and store in you XLSTART folder.

This will become the default sheet for Insert>Worksheet.

Gord Dibben Excel MVP
 
Back
Top