LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Print workbook with different page number footers

I have a workbook with about 30 tabs, each one with a different table. Some
tables are 1 page long and some are 4 pages long. I want to print the entire
workbook so that the table that has 1 page says 1 of 1 and the 4page table
says 1 of 4, and so on. However, since I'm using the footer feature, 1 of ?,
it just gives me 1 of total number of pages in the workbook.

How can I get around this without printing each tab individually?
--
Angel Bivins
WordAngel Document Design
www.wordangel.com
 
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
Print 1st Page Multiple Sheets in Same Workbook Ben Dummar Excel Discussion (Misc queries) 8 May 22nd 07 09:18 PM
Can a header be applied once to a workbook & print on each page? Christine Sullivan Excel Worksheet Functions 2 August 8th 06 06:34 PM
How do I print a one page spreadsheet multiple time, each with its own page number? lhsallwasser Excel Discussion (Misc queries) 4 August 17th 05 03:00 PM
How can I print page 2 of each sheet in a workbook? sflower Excel Discussion (Misc queries) 1 March 9th 05 02:15 PM
Print Workbook Without Page Breaks Between Worksheets annem Excel Worksheet Functions 0 December 21st 04 08:05 PM


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