Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lyn Familant via OfficeKB.com
 
Posts: n/a
Default numbering all pages in worksheet

I have an Apple and I'm using Office 2004. How do I number, sequentially,
all the pages in a workbook? When I go to header/footers, customize
footer, etc. I can figure out how to number each page in a worksheet. But
I want to know how can I number ALL pages sequentially in the workbook.
So, for example, let's say the first worksheet is 3 pages, the second
worksheet is 2 pages, and the 3rd worksheet is 5 pages. I want to number
pages 1, 2, ......through page 10. Would really appreciate help on this.

--
Message posted via http://www.officekb.com
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

In xl2002 under windows, I can add the page number in the footer of each sheet.

Then I can either:
File|print|entire workbook
or
Group the worksheets, then print.
(I can rightclick on a worksheet tab and choose "select all sheets")

"Lyn Familant via OfficeKB.com" wrote:

I have an Apple and I'm using Office 2004. How do I number, sequentially,
all the pages in a workbook? When I go to header/footers, customize
footer, etc. I can figure out how to number each page in a worksheet. But
I want to know how can I number ALL pages sequentially in the workbook.
So, for example, let's say the first worksheet is 3 pages, the second
worksheet is 2 pages, and the 3rd worksheet is 5 pages. I want to number
pages 1, 2, ......through page 10. Would really appreciate help on this.

--
Message posted via http://www.officekb.com


--

Dave Peterson
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
sequential numbering of pages in a cell John Excel Worksheet Functions 0 February 10th 05 07:01 AM
Single worksheet, multiple pages? Peter Excel Discussion (Misc queries) 9 January 23rd 05 09:51 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
How to print a worksheet but number the pages by workbook Frank Clayton Excel Discussion (Misc queries) 2 January 10th 05 10:52 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM


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