Insert Elements in a Header or Footer in Page Layout View : Header Footer « Format Style « Microsoft Office Excel 2007 Tutorial

Home
Microsoft Office Excel 2007 Tutorial
1.Introduction
2.Editing
3.Format Style
4.Table
5.Chart
6.Formula
7.Workbook Worksheet
8.Wordart Clip Art Shape Picture
9.PivotTable PivotChart
10.Data Analysis
11.Macro ActiveX Add in
12.Security
13.Collaboration
14.Database functions
15.Date Time functions
16.Engineering functions
17.Information functions
18.Logical functions
19.Lookup Reference functions
20.Math Trigonometry functions
21.Statistical functions
22.Text functions
VBA / Excel / Access / Word
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Word 2007 Tutorial
Microsoft Office Excel 2007 Tutorial » Format Style » Header Footer 
3.11.2.Insert Elements in a Header or Footer in Page Layout View
Click the Insert tab. Click the Header & Footer button.
Click the Insert tab. Click the Header & Footer button.
The worksheet appears in Page Layout view. 
           Click the left, center, or right header or footer text.
Click the left, center, or right header or footer text.
Click the Design tab under Header & Footer Tools.
Click the Design tab under Header & Footer Tools.
To insert individual elements, click the button in the Header & Footer Elements group.
To insert individual elements, click the button in the Header & Footer Elements group.
Select or clear Different First Page to add or remove headers and footer from the first page.
Select or clear Different First Page to add or  remove headers and footer from the first page.
Select Different Odd & 
           Even Pages to have different header or footer for odd and even pages.
Select Different Odd & Even Pages to have different header or footer for odd and even pages.
Select Scale with Document to use the same font size and scaling as the worksheet.
Select Scale with Document to use the same font size and scaling as the worksheet.
Select Align with Page Margins to align header or footer margin with page margins.
Select Align with Page Margins to align header or footer margin with page margins.
To close the headers or footers, click anywhere in the worksheet.
To close the headers or footers, click anywhere in the worksheet.

Use two ampersands (&&) to enter an & in a header or footer

3.11.Header Footer
3.11.1.Add a Predefined Header or Footer in Page Layout ViewAdd a Predefined Header or Footer in Page Layout View
3.11.2.Insert Elements in a Header or Footer in Page Layout ViewInsert Elements in a Header or Footer in Page Layout View
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.