microsoft excel training - Headers footers

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

Resolved · Low Priority · Version Standard

Headers footers

Nick has attended:
Excel Introduction course
Word Introduction course
Word Introduction course

by - delegate Nick [5 posts] (2007 Feb 27 Tue, 11:08) Reply

Hi,
I was wondering if it owuld be possible to put headers and footers inside excel spreadsheet cells?

Essentially what I'm trying to do is draw up a rough calender where I would put the number of the date in the corner of a cell, but be able to write in the cell freely.

Any help would be greatly appreciated!

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: headers footers

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 27 Tue, 11:48) Edited on 2007 Feb 27 Tue, 11:49 Reply

Hi,
You can put in Headers and Footers by using the View menu and down to Header and Footer. Either use the standard setting which are where the drop down menus are, or you can customise it for your own choice of header/footer.

Regarding your rough calendar, you can use Outlook which already has a pre-set calendar, or you could use Word where you can create a template or create tables in Word? (Tables>Insert)

Let me know if it something we can help you out with

Tracy

· Advanced level training: Microsoft Excel and the Web
· Database Tips from an Excel Training Course
· How Excel Training Can Improve Your Company's Sales Process
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Why Should I Learn Visual Basic in Excel?

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips