Avatar of IT_Fanatic
IT_Fanatic
 asked on

Footers and Headers

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

Avatar of undefined
Last Comment
IT_Fanatic

8/22/2022 - Mon
raysonlee

Insert Header/Footer
Put Current Date &[Date] and Current Time &[Time] in it
raysonlee

if u want that to be added automatically in every new spreadsheet, u can save that as the default template
IT_Fanatic

ASKER
How would you save it as a default template? Rusty with excel.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
raysonlee

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
IT_Fanatic

ASKER
Thanks that worked