Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merge Pages for printing
I have 32 page breaks, on page one are the product names listed by rows, each
page break represents a different day in the month. How can I set page setup to merge page one on with other pages I would like to print (say page one and page 15 on the same page)? |
#2
|
|||
|
|||
Jim wrote...
I have 32 page breaks, on page one are the product names listed by rows, each page break represents a different day in the month. How can I set page setup to merge page one on with other pages I would like to print (say page one and page 15 on the same page)? Excel won't merge pages, but you could use File Page Setup, select the Sheet tab in the Page Setup dialog, then select your 'page 1' as row titles. |
#3
|
|||
|
|||
I think you would need to add another page where you use formulas to
construct the layout you want (or manually copy the data over the way you want) and then print that page. However, If it is just page 1 and page 15 and you want them one above the other, then you can just hide the rows inbetween and after, then print it. -- Regards, Tom Ogilvy "Jim" wrote in message ... I have 32 page breaks, on page one are the product names listed by rows, each page break represents a different day in the month. How can I set page setup to merge page one on with other pages I would like to print (say page one and page 15 on the same page)? |
#4
|
|||
|
|||
Hi,
Download this sharewa http://www.fineprint.com Fineprint is an indispensible tool to combine prints - not just from Excel. Ola |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
How do I remove pages in Excel? | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) | |||
Mail merge to a chart | Charts and Charting in Excel |