#1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default subtotal

i want to print a report of 10 page. i want subtotal on every page while
printing like page 1 of 10 2 of 10
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default subtotal

"Noorullah" wrote:
i want to print a report of 10 page. i want subtotal on every page while
printing like page 1 of 10 2 of 10


Click File Page Setup Header/Footer tab
Click Custom Footer, place this in say, the Center section:
Page &[Page] of &[Pages]
OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
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
How do I Subtotal, then Sort by Subtotal Amounts? dnamertz Excel Discussion (Misc queries) 3 October 29th 06 12:17 AM
pasting to subtotal lines without replacing hidden -non-subtotal l harleydiva67 Excel Discussion (Misc queries) 1 October 12th 06 06:02 PM
Bolding the subtotal lines automaticlly When using the Subtotal fu 06Speed6 New Users to Excel 2 October 5th 06 03:52 PM
copy subtotal value only, subtotal value can be vlookup by others BB Excel Discussion (Misc queries) 1 June 28th 06 11:10 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 08:56 AM.

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"