Headers and Footers in Excel 2007

[allquestionsnoanswers]

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.

 

[M Kan]

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.

 

[allquestionsnoanswers]

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.

 

[Bill Sharpe]

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.

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

 

[allquestionsnoanswers]

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.