MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Different Footer for each page in 1 sheet

  Asked By: Francisca    Date: Jan 11    Category: MS Office    Views: 1883

i have trouble for inserting different footer for each page on the worksheet, i
want to insert fields form select command (view) to my footer.

can me make different footer for each page ? like at MS Word ?

format i want :

"Report - " & Fields &P of &N"



3 Answers Found

Answer #1    Answered By: Tracy Cole     Answered On: Jan 11

On Excel 2002, you can go to File - Page Setup and press Custom
Footer. Using the buttons, you can make something like:
Report - &[Page] of &[Pages]

Answer #2    Answered By: Adalrich Fischer     Answered On: Jan 11

I mean :
Format Footer = "Report " & [Fields] &P of & &N
where : [fields] is dynamic for each page...
fields is variable

Answer #3    Answered By: Volker Fischer     Answered On: Jan 11

The only way I have been able to do that (kind of) is to
bypass the normal headers and footers and make a macro that
generates a "report" that has all the "footers" already at the
bottom of each page  and inserts page breaks.

Didn't find what you were looking for? Find more on Different Footer for each page in 1 sheet Or get search suggestion and latest updates.