Footers and Headers

IT_Fanatic
IT_Fanatic used Ask the Experts™
on
I have a user who wants the date and time to always appear on the excel spreadsheet. Is there a way to set it up automatically so we don't have to insert it every time? She has excel 2010.

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Insert Header/Footer
Put Current Date &[Date] and Current Time &[Time] in it
if u want that to be added automatically in every new spreadsheet, u can save that as the default template

Author

Commented:
How would you save it as a default template? Rusty with excel.
File, SaveAs, select Excel Template for File Type, enter "book" as file name and save it to XLStart folder (usually C:\Program Files\Microsoft Office\Office14\XLStart)
Exit Excel and the template will be loaded automatically when u start Excel

Author

Commented:
Thanks that worked

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial