microsoft excel courses in london - Header/Footer Update Automatically

The UK's most regular instructor-led training courses.
Training information: microsoft excel courses in london · Excel course london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Header/Footer Update Automatically

Shavaun has attended:
Word Intermediate course
Excel Intermediate course

by - delegate Shavaun [2 posts] (2006 Nov 22 Wed, 13:45) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 28 Thu	Southwark	0	FULL
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Sep 4 Thu	Bayswater	5	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
Full Schedule: See all 139 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Header/Footer Update Automatically

by - trainer Orok bronze contributer [29 posts] (2006 Nov 23 Thu, 10:24) Reply

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

· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Compare Different MS Excel Training Methods
· Database Tips from an Excel Training Course

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips