LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,069
Default Trying to Figure How to Use One Page but Print 1 0f 50

I would think Word would be better. You could set up the page, add the
fields for page and total pages either in the header/footer or through the
insert, auto text, header/footer, page x of y. Add a page break then copy
and paste the required number of pages (should not take too long using the
paste shortcut of Ctrl V). You might then need to update all the page
numbers by seslectin all and pressing f9.

Alternatively you could consider using mail merge in word. Set up an excel
sheet with a list of the number of pages ie 1 to 50 in a column. Then use
this as the data source for the doccument and add this field for the page
number.

hope this helps
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Mikea12" wrote:

Hi All,
Any comments will help

I am trying using Excel or Word to do this, Basically I ship boxes and want
the same document which is one page to be able to print 1 of 50 then 2 of 50
so on...etc...

Any help

Mike

 
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 Area. 1st page Landscape 2nd page Portrait?? Corey Excel Worksheet Functions 1 June 23rd 06 08:18 AM
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE RALPH Setting up and Configuration of Excel 3 March 16th 06 11:08 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 11:29 AM
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
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 07:14 PM


All times are GMT +1. The time now is 09:20 AM.

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

About Us

"It's about Microsoft Excel"