I have a worksheet that contains 69 pages. I need a custom footer on each of
the pages. I know in Word, you could simply unselect "same as previous".
However, I can't find any information anywhere. Any help is appreciated.

Assuming the rest of your sheet formatting is the same, you can highlight all
69 pages, go to File: Page Set up and then write your footer. Hit OK and
then click on any sheet to deselect them all. Your footer should now be on
all the sheets.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"allquestionsnoanswers" wrote:

I have a worksheet that contains 69 pages. I need a custom footer on each of
the pages. I know in Word, you could simply unselect "same as previous".
However, I can't find any information anywhere. Any help is appreciated.

Okay, but I don't want the same footer on each page. For example, I want
page one's footer to say "ADAMS" and then page two's footer to say "ADAMS,
BOONE". Then maybe page three to say "CHAMPAIGN" and so on and so on. I
really don't want each page to have the same footer. Also this is Excel 2007.

"M Kan" wrote:

Assuming the rest of your sheet formatting is the same, you can highlight all
69 pages, go to File: Page Set up and then write your footer. Hit OK and
then click on any sheet to deselect them all. Your footer should now be on
all the sheets.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"allquestionsnoanswers" wrote:

I have a worksheet that contains 69 pages. I need a custom footer on each of
the pages. I know in Word, you could simply unselect "same as previous".
However, I can't find any information anywhere. Any help is appreciated.

allquestionsnoanswers wrote:
Okay, but I don't want the same footer on each page. For example, I want
page one's footer to say "ADAMS" and then page two's footer to say "ADAMS,
BOONE". Then maybe page three to say "CHAMPAIGN" and so on and so on. I
really don't want each page to have the same footer. Also this is Excel 2007.

"M Kan" wrote:

Assuming the rest of your sheet formatting is the same, you can highlight all
69 pages, go to File: Page Set up and then write your footer. Hit OK and
then click on any sheet to deselect them all. Your footer should now be on
all the sheets.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"allquestionsnoanswers" wrote:

I have a worksheet that contains 69 pages. I need a custom footer on each of
the pages. I know in Word, you could simply unselect "same as previous".
However, I can't find any information anywhere. Any help is appreciated.

Excel is an excellent program, but it doesn't do mind-reading. If you
want completely different footers on each page you're going to have to
set up each page separately or write a complex macro to do so.

Bill

So instead of 69 pages in a worksheet, I would have 69 worksheets? It makes
sense but I was really hoping for an easier fix than copy and pasting each
page into a worksheet. Thanks.

"Bill Sharpe" wrote:

allquestionsnoanswers wrote:
Okay, but I don't want the same footer on each page. For example, I want
page one's footer to say "ADAMS" and then page two's footer to say "ADAMS,
BOONE". Then maybe page three to say "CHAMPAIGN" and so on and so on. I
really don't want each page to have the same footer. Also this is Excel 2007.

"M Kan" wrote:

Assuming the rest of your sheet formatting is the same, you can highlight all
69 pages, go to File: Page Set up and then write your footer. Hit OK and
then click on any sheet to deselect them all. Your footer should now be on
all the sheets.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"allquestionsnoanswers" wrote:

I have a worksheet that contains 69 pages. I need a custom footer on each of
the pages. I know in Word, you could simply unselect "same as previous".
However, I can't find any information anywhere. Any help is appreciated.

Excel is an excellent program, but it doesn't do mind-reading. If you
want completely different footers on each page you're going to have to
set up each page separately or write a complex macro to do so.

Bill