Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How do I keep all page footers unique with a page number on all pa

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...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default How do I keep all page footers unique with a page number on allpa

Each worksheet can have a unique footer.

Keys2thecitY wrote:

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...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format page number in excel footer to start at a specific page # straitctrydncr Excel Discussion (Misc queries) 4 April 28th 23 07:45 PM
Print workbook with different page number footers Angel Bivins Excel Discussion (Misc queries) 1 July 11th 07 08:20 PM
Printing Headers on only first page and Footers on only last page JacMar Excel Discussion (Misc queries) 5 January 21st 07 03:48 PM
change and/or remove page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:15 AM
Hiding the page number in page break preview background. I need coffee, wake me up! Excel Discussion (Misc queries) 0 May 15th 06 10:32 AM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"