Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print Area. 1st page Landscape 2nd page Portrait?? | Excel Worksheet Functions | |||
PRINT PAGE BREAK VIEW AS WATERMARK FIOR EACH PAGE | Setting up and Configuration of Excel | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) |