multiple page printing

  • Thread starter Thread starter Scudo
  • Start date Start date
S

Scudo

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 said:
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 d
this
5 times in order to print off the full spreadsheet page. Is there a wa
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
Click to expand...

Hi Scudo

Try View > Page Break Vie
 
Have you tried View|Page Break View and set page breaks? Set print area to
cover all the material needed to print
best wishes
 
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.
 
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.
 
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

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
 
Back
Top