98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in london - Header/Footer Update Automatically
microsoft excel courses in london - Header/Footer Update Automatically
Resolved · Low Priority · Version Standard
Wed 22 Nov 2006, 13:45Delegate Shavaun said...
Shavaun has attended:
Word Intermediate course
Excel Intermediate course
Header/Footer Update Automatically
Hi
I would like to know if there is a way to set the footer so that it updates the dates automatically for each new day.
Thanks
Thu 23 Nov 2006, 10:24Trainer Orok said...
RE: Header/Footer Update Automatically
Hi Shavaun,
To get the current date to display within a worksheet footer, from View menu, choose the Header and Footer option.
Within the Page Setup dialog box that appears in the Header/Footer tab sheet, select Custom Footer.
By choosing the Date button the following code &[Date] displays in the relevant section. This ensures that that the current computer date always appears at the foot of your Excel worksheet
Regards
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding Formulae in the Formula BarIt is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar. |
