RE: H&F in Excel

Subject: RE: H&F in Excel
From: "Cook, Jenise" <jenise -dot- cook-crabbe -at- pacificlife -dot- com>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Fri, 14 Sep 2001 09:01:20 -0700

Hi, Swati:

You may already have the answer, since your message hit my Inbox while I was
at home, asleep. :-D

Excel's online Help has helpful procedures. In the search, enter "headers"
(w/out quotes). Here's what I found:

_Create custom headers and footers_

You can have only one custom header and one custom footer on each worksheet.
If you create a new custom header or footer, it replaces any existing custom
header or footer on the worksheet.

Click the worksheet.

On the View menu, click Header and Footer.

To base a custom header or footer on an existing built-in header or footer,
click the header or footer in the Header box or Footer box.

Click Custom Header or Custom Footer.

Click in the Left section, Center section, or Right section box, and then
click the buttons to insert the header or footer information - such as the
page number - that you want in that section.
For Help on an option, click the question mark and then click the option.

To enter additional text for the header or footer, enter the text in the
Left section, Center section, or Right section box.
To start a new line in one of the section boxes, press ENTER.

To delete a section of a header or footer, select the section that you want
to delete in the section box, and then press BACKSPACE.

Note Make sure the header or footer margin allows enough space for the
custom header or footer. More information about setting the header and
footer margins.


To include a single ampersand (&) within the text of a header or footer, use
two ampersands. For example, to include "Subcontractors & Services" in a
header, type Subcontractors && Services.

To start numbering pages with a number other than 1, use &[Page]+ or
&[Page]- followed by the number you want to add or subtract from the actual
page number. For example, to print starting with number 3 on the first page,
type &[Page]+2. To print page 4 with number 3, type &[Page]-1.

You cannot insert graphics or cell references in a header or footer. Use
print titles if you want to repeat cell contents or a graphic on every
printed page. How to use print titles.

-----Original Message-----
From: Swati Jain [mailto:swatij -at- ggn -dot- aithent -dot- com]
Sent: Friday, September 14, 2001 2:31 AM
Subject: H&F in Excel

Is it possible to have different header & footers on different pages of a
single excel sheet.??



A landmark hotel, one of America's most beautiful cities, and
three and a half days of immersion in the state of the art:
IPCC 01, Oct. 24-27 in Santa Fe.

+++ Miramo -- Database/XML publishing automation. See us at +++
+++ Seybold SFO, Sept. 25-27, in the Adobe Partners Pavilion +++
+++ More info: +++

You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit for more resources and info.

Previous by Author: RE: Enough
Next by Author: Description of databases
Previous by Thread: RE: FrameMaker defaults
Next by Thread: Re: E-mail exchange with Rays

What this post helpful? Share it with friends and colleagues:

Sponsored Ads