Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default change starting page number

We have many Excel worksheets that will need to be added in between Word
files. One of the client's stipulations is that all pages submitted must have
ALL pages numbered consecutively. The starting document is a Word file.
Hypothetically, let's say it is 100 pages long before the first Excel pages
are to be inserted. How can I get the Excel footer to dispay page 101 and
then number all subsequent worksheet pages in sequence.

I know how to change the starting number of a Word file but not in Excel.
Also, is there a way I can put a starting number before the page number (to
act as a Chapter #)? Our Word files use chapter numbering and we want this
deliverable to be consistent, regardless of the file type.

I would appreciate any guidance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default change starting page number

How can I get
the Excel footer to dispay page 101 and then number all subsequent
worksheet pages in sequence.


One way in Excel 2003 is to look at
File Page setup Page First page number
and fill in the desired number there; in this case, 101.
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default change starting page number

... is there a way I can put a starting number before the
page number (to act as a Chapter #)?


One way in Excel 2003 is to look at
File Page Setup Header/Footer Custom Footer
and in the section of your choice put
22 - &[Page]
if 22 is the chapter number.
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
Page numbers - not starting from the first page SupperDuck Excel Discussion (Misc queries) 1 March 8th 07 05:20 PM
change page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:16 AM
change and/or remove page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:15 AM
change page number in the same sheet viman_in Excel Discussion (Misc queries) 1 June 18th 06 06:40 PM
Change number of columns mid page? Bluemax Excel Worksheet Functions 4 November 24th 04 02:11 AM


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