advanced excel course london - Macro

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

Resolved · Low Priority · Version Standard

Macro

Jennifer has attended:
Excel Intermediate course

by - delegate Jennifer [2 posts] (2007 Aug 7 Tue, 15:39) Reply

How to apply same header/footer to all sheets?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	2	book now	£235	£240
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Macro

by - trainer David gold contributer [411 posts] (2007 Aug 8 Wed, 14:06) Reply

select and group all the sheets, goto any sheet that you want to insert the header/footer, type in the header/footer, ungroup the sheets, and you will have the header/footer on all the sheets.

· Why Should I Learn Visual Basic in Excel?
· How to Create Better Excel Spreadsheets: Part One
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Reasons Why VBA for Excel Training Fails
· MS Excel: Excel At Making The Most Of Your Christmas

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips