Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
FloBuddyDog
 
Posts: n/a
Default header/footer "page 1 of 'x' pages"

I would like to add a header or footer to my Excel worksheet printout that
needs to shows consecutive page numbers plus the total number of pages on
each page. Such as page 1 of 12 pages, page 2 of 12 pages, page 3 of 12
pages, etc.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc
  #2   Report Post  
Scott@PRM
 
Posts: n/a
Default

Go to To: View/Header&Footer

Click on Custom Header

Type the following in whichever section you want it lsted (left, cent,or
right)

Page&[Page]of&[Pages]

That should work!

"FloBuddyDog" wrote:

I would like to add a header or footer to my Excel worksheet printout that
needs to shows consecutive page numbers plus the total number of pages on
each page. Such as page 1 of 12 pages, page 2 of 12 pages, page 3 of 12
pages, etc.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

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
ONE PAGE REPORT WANTS TO PRINT 1311 pages in each copy, WHY? G'pa Woody Excel Discussion (Misc queries) 2 May 10th 05 05:45 PM
My scaling is set to print 1x1 pages. But it prints 1000's of page Graeme Excel Worksheet Functions 0 March 23rd 05 01:15 AM
need to reducing pages....i need to put the bottom part of a page. OhMyGodDeniGetAGrip Excel Discussion (Misc queries) 3 March 16th 05 03:48 PM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
Remove header/footer from Excel first page? richdsn2 Excel Discussion (Misc queries) 1 December 8th 04 05:18 PM


All times are GMT +1. The time now is 03:56 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"