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

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

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

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

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

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

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