View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keys2thecitY Keys2thecitY is offline
external usenet poster
 
Posts: 2
Default Unique Footer for each page in worksheet with a page number

Conflict:
I have chosen the "Different First Page" option in the header and footer
selection menu. What happens is the footer on the first page is different,
but will not allow me to add a page number. The footer information for the
first page is aligned to the left, and I want to align the page number to the
right. All the subsequent pages have consecutive page numbers, but the
problem is they will have an identical footer. What I need to have is each
page in the worksheet with an exclusive footer aligned to the left, followed
by its page number aligned to the right.

Scenario:
I have a worksheet that has no cover page. Therefore I need each page
specifically numbered in sequence, 1,2,3..., and each page to also include a
unique footer with information relevant to that page.

Example's:
First page describes finances. I need to describe the columns and rows by
illustrating in the footer their indicated purpose for that page (Column A-
payments for forecasted transactions, Column B- net income, etc...). Page 2
on the otherhand describes investments and stocks, which has a contrast in
information but also needs an authentic footer.

Any help or information is well appreciated, Thank you...