Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiple page printing
On a spreadsheet due to the size of it takes 5 pages to print it off.
Currently I `set` each page as a print area then print so I have to do this 5 times in order to print off the full spreadsheet page. Is there a way to press `print` and it will print off the 5 pre set `print areas` ? without me having to go throught the `set print area` / `print`/`clear print area` then reset for next section. thanks |
#2
|
|||
|
|||
Scudo Wrote: On a spreadsheet due to the size of it takes 5 pages to print it off. Currently I `set` each page as a print area then print so I have to do this 5 times in order to print off the full spreadsheet page. Is there a way to press `print` and it will print off the 5 pre set `print areas` ? without me having to go throught the `set print area` / `print`/`clear print area` then reset for next section. thanks Hi Scudo Try View Page Break View -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=397124 |
#3
|
|||
|
|||
Have you tried View|Page Break View and set page breaks? Set print area to
cover all the material needed to print best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Scudo" wrote in message . .. On a spreadsheet due to the size of it takes 5 pages to print it off. Currently I `set` each page as a print area then print so I have to do this 5 times in order to print off the full spreadsheet page. Is there a way to press `print` and it will print off the 5 pre set `print areas` ? without me having to go throught the `set print area` / `print`/`clear print area` then reset for next section. thanks |
#4
|
|||
|
|||
Is there some reason you can't set the entire print range at once? Are the 5
ranges discontiguous? If that's the problem, name each of the 5 ranges, something like Page1, Page2, etc. Then go to File - Page Setup and navigate to the Sheet tab. In the Print Area box type all the range names separated by commas: page1, page2, page3, page4, page5 Now each range will print on a separate page. "Scudo" wrote: On a spreadsheet due to the size of it takes 5 pages to print it off. Currently I `set` each page as a print area then print so I have to do this 5 times in order to print off the full spreadsheet page. Is there a way to press `print` and it will print off the 5 pre set `print areas` ? without me having to go throught the `set print area` / `print`/`clear print area` then reset for next section. thanks |
#5
|
|||
|
|||
I will try to sort on info you have given.
Reason for 5 pages is that the five sections relate to monday - friday and I want each day seperate, its nothing complicated just names and addresses so no formulas or anything. "Duke Carey" wrote in message ... Is there some reason you can't set the entire print range at once? Are the 5 ranges discontiguous? If that's the problem, name each of the 5 ranges, something like Page1, Page2, etc. Then go to File - Page Setup and navigate to the Sheet tab. In the Print Area box type all the range names separated by commas: page1, page2, page3, page4, page5 Now each range will print on a separate page. "Scudo" wrote: On a spreadsheet due to the size of it takes 5 pages to print it off. Currently I `set` each page as a print area then print so I have to do this 5 times in order to print off the full spreadsheet page. Is there a way to press `print` and it will print off the 5 pre set `print areas` ? without me having to go throught the `set print area` / `print`/`clear print area` then reset for next section. thanks |
#6
|
|||
|
|||
Stoll not getting this, spreadsheet only appears to accept one page break, I
know its me not setting it correctly, Any advice please. thanks "Scudo" wrote in message . .. I will try to sort on info you have given. Reason for 5 pages is that the five sections relate to monday - friday and I want each day seperate, its nothing complicated just names and addresses so no formulas or anything. "Duke Carey" wrote in message ... Is there some reason you can't set the entire print range at once? Are the 5 ranges discontiguous? If that's the problem, name each of the 5 ranges, something like Page1, Page2, etc. Then go to File - Page Setup and navigate to the Sheet tab. In the Print Area box type all the range names separated by commas: page1, page2, page3, page4, page5 Now each range will print on a separate page. "Scudo" wrote: On a spreadsheet due to the size of it takes 5 pages to print it off. Currently I `set` each page as a print area then print so I have to do this 5 times in order to print off the full spreadsheet page. Is there a way to press `print` and it will print off the 5 pre set `print areas` ? without me having to go throught the `set print area` / `print`/`clear print area` then reset for next section. thanks |
#7
|
|||
|
|||
Scudo
Can you sort the entire range by the column with day of week? If so, you could then manually insert a page break at each change of day. Or run this macro which looks at Column A after it is sorted and inserts a page break at a change in data. Sub InsertBreaks() Set Rng = Range(Cells(2, 1), _ Cells(Rows.Count, 1).End(xlUp)) For Each Cell In Rng If Trim(Cell.Value) < _ Trim(Cell.Offset(-1, 0).Value) Then ActiveSheet.HPageBreaks.Add Cell End If Next End Sub Gord Dibben Excel MVP On Sun, 21 Aug 2005 10:23:26 GMT, "Scudo" wrote: Stoll not getting this, spreadsheet only appears to accept one page break, I know its me not setting it correctly, Any advice please. thanks "Scudo" wrote in message ... I will try to sort on info you have given. Reason for 5 pages is that the five sections relate to monday - friday and I want each day seperate, its nothing complicated just names and addresses so no formulas or anything. "Duke Carey" wrote in message ... Is there some reason you can't set the entire print range at once? Are the 5 ranges discontiguous? If that's the problem, name each of the 5 ranges, something like Page1, Page2, etc. Then go to File - Page Setup and navigate to the Sheet tab. In the Print Area box type all the range names separated by commas: page1, page2, page3, page4, page5 Now each range will print on a separate page. "Scudo" wrote: On a spreadsheet due to the size of it takes 5 pages to print it off. Currently I `set` each page as a print area then print so I have to do this 5 times in order to print off the full spreadsheet page. Is there a way to press `print` and it will print off the 5 pre set `print areas` ? without me having to go throught the `set print area` / `print`/`clear print area` then reset for next section. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing a Column in Multiple Segments on One Page | Excel Discussion (Misc queries) | |||
printing multiple page workbook | Excel Discussion (Misc queries) | |||
Printing multiple worksheets on one page | Excel Discussion (Misc queries) | |||
Excel - printing multiple worksheets on one page | Excel Discussion (Misc queries) | |||
Printing multiple areas on the 1 page | Excel Discussion (Misc queries) |