E
eric3450
Is there a way to eliminate page breaks between worksheets when printing multiple worksheets at the same time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Copy all the data to a giant worksheet and print from there.
In fact, if you select each range, then copy, then go to the new sheet.
Shift-edit|paste picture link
and it'll be a picture that updates whenever that range changes.
Keep this up and concatenate a bunch of pictures and then print the pictures.
In fact, if you select each range, then copy, then go to the new sheet.
Shift-edit|paste picture link
and it'll be a picture that updates whenever that range changes.
Keep this up and concatenate a bunch of pictures and then print the pictures.
E
eric3450
Seems like a really complicated "work-around". Any way to just eliminate the page breaks so the worksheets print one after another?
D
Dave Peterson
eh, no.
Seems like a really complicated "work-around". Any way to just eliminate the page breaks so the worksheets print one after another?
D
David McRitchie
But that was the point.
If the columns match up with the same width and heading you could put
them all into one worksheet and use a filter to see what you would have
seen on the individual worksheets You are subject to 65,536 rows
but if you within 1/4 of that your are probably already in trouble.
Instead of pasting pictures into Excel, you could paste tables into
Microsoft Word. They may not look the same as in Excel.
Another solution would be to create an HTML file. The concept of
a distinct page is not part of HTML (or at least it wasn't when I started).
I have a macro that you could adapt to pick up different pages instead
of blocks of cells.
http://www.mvps.org/dmcritchie/excel/xl2html.htm
You could save paper by using a duplex printer, which would start
each spreadsheet on an odd numbered page, but would print on
both sides. There is much if anything builtin to Excel to save paper.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
If the columns match up with the same width and heading you could put
them all into one worksheet and use a filter to see what you would have
seen on the individual worksheets You are subject to 65,536 rows
but if you within 1/4 of that your are probably already in trouble.
Instead of pasting pictures into Excel, you could paste tables into
Microsoft Word. They may not look the same as in Excel.
Another solution would be to create an HTML file. The concept of
a distinct page is not part of HTML (or at least it wasn't when I started).
I have a macro that you could adapt to pick up different pages instead
of blocks of cells.
http://www.mvps.org/dmcritchie/excel/xl2html.htm
You could save paper by using a duplex printer, which would start
each spreadsheet on an odd numbered page, but would print on
both sides. There is much if anything builtin to Excel to save paper.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
the page breaks so the worksheets print one after another?eric3450 said:Seems like a really complicated "work-around". Any way to just eliminate