#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default Page Numbering

I have a spreadsheet with 3 tabs. Each tab prints out 3 pages. How can I get
Excel to # the pages 1-9 & not 1-3 3 times?
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,939
Default Page Numbering

Select all three sheets and then print... If you print the sheets one at a
tiem it will come out 1-3 three times but if you have selected all three
sheets to print in the smae print job then they will number 1-9...
--
HTH...

Jim Thomlinson


"Tom" wrote:

I have a spreadsheet with 3 tabs. Each tab prints out 3 pages. How can I get
Excel to # the pages 1-9 & not 1-3 3 times?
Thanks

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
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM


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