Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 14th 10, 05:02 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 112
Default Need to make page numbers sequential across worksheets

Hi,

I have a workbook with 3 worksheets (and page # footers on each of them) in
Excel 2003. When I print the entire workbook (4 pages per worksheet x 3
worksheets = 12 pages). each worksheet starts with "page 1". The page number
order goes: 1,2,3,4,1,2,3,4,1,2,3,4.

How do I change it so that the page numbers are listed as 1-12? I don't want
to list each manually as the data changes regularly, leading to different
page numbers

Thanks for the help.

  #2   Report Post  
Old January 15th 10, 01:34 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 108
Default Need to make page numbers sequential across worksheets

Hi Kate,

Group the sheets before printing them.
i.e. click on the first sheet tab, hold the Shift key down, click on the
last sheet tab, then go to Print Preview - the page numbering is now
consecutive.

Ed Ferrero
www.edferrero.com


I have a workbook with 3 worksheets (and page # footers on each of them)
in
Excel 2003. When I print the entire workbook (4 pages per worksheet x 3
worksheets = 12 pages). each worksheet starts with "page 1". The page
number
order goes: 1,2,3,4,1,2,3,4,1,2,3,4.

How do I change it so that the page numbers are listed as 1-12? I don't
want
to list each manually as the data changes regularly, leading to different
page numbers

Thanks for the help.


  #3   Report Post  
Old January 15th 10, 02:36 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 112
Default Need to make page numbers sequential across worksheets

Perfect!! Exactly what I needed. Thank you.

"Ed Ferrero" wrote:

Hi Kate,

Group the sheets before printing them.
i.e. click on the first sheet tab, hold the Shift key down, click on the
last sheet tab, then go to Print Preview - the page numbering is now
consecutive.

Ed Ferrero
www.edferrero.com


I have a workbook with 3 worksheets (and page # footers on each of them)
in
Excel 2003. When I print the entire workbook (4 pages per worksheet x 3
worksheets = 12 pages). each worksheet starts with "page 1". The page
number
order goes: 1,2,3,4,1,2,3,4,1,2,3,4.

How do I change it so that the page numbers are listed as 1-12? I don't
want
to list each manually as the data changes regularly, leading to different
page numbers

Thanks for the help.


.



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
new page opened with sequential numbers from last saved Newman Excel Worksheet Functions 1 March 18th 08 11:50 PM
Make sequential numbers each time sheet is opened Darrell Shuman Excel Worksheet Functions 1 October 19th 05 03:35 AM
Print sequential page numbers on one worksheet printed multiple ti 2 hard basket Excel Worksheet Functions 1 August 5th 05 03:02 AM
print multiple copies of the same page with sequential numbers labrat Excel Discussion (Misc queries) 1 June 14th 05 05:32 PM
How can i print sequential page numbers 1 to 10, if i have one wo. DJN822 Excel Discussion (Misc queries) 2 March 24th 05 04:41 AM


All times are GMT +1. The time now is 09:35 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017