Eliminate page breaks between worksheets

[Guest]

Is there a way to eliminate page breaks between worksheets when printing multiple worksheets at the same time?

 

[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.

 

[Guest]

Seems like a really complicated "work-around". Any way to just eliminate the page breaks so the worksheets print one after another?

 

[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?

 

[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.

Seems like a really complicated "work-around". Any way to just eliminate

the page breaks so the worksheets print one after another?