Can Excel produce printed reports in a reading view, like Word? If so, how
do I do this?

Thanks.

you mean like File / Print Preview? To make it look like a report, do it
with a macro

I have a file that is about 10 pages long. I want to be able to print it
Landscape, and put page 1 and page 2 side by side on the first sheet, then 3
and 4 and so on. You can do it in Word, it is something like a Reading view,
but I can't figure out how to do in Excel. Page Setup, fit to page did not
work. Printer was even setup to do 2 pages per sheet, but it did not work.
Any thoughts?

"Marvin P. Winterbottom" wrote:

you mean like File / Print Preview? To make it look like a report, do it
with a macro

ViewPage Break Preview

HTH.

Jason

"bdave68" wrote:

I have a file that is about 10 pages long. I want to be able to print it
Landscape, and put page 1 and page 2 side by side on the first sheet, then 3
and 4 and so on. You can do it in Word, it is something like a Reading view,
but I can't figure out how to do in Excel. Page Setup, fit to page did not
work. Printer was even setup to do 2 pages per sheet, but it did not work.
Any thoughts?

"Marvin P. Winterbottom" wrote:

you mean like File / Print Preview? To make it look like a report, do it
with a macro

That did not work. Any other thoughts?

"Jason" wrote:

ViewPage Break Preview

HTH.

Jason

"bdave68" wrote:

I have a file that is about 10 pages long. I want to be able to print it
Landscape, and put page 1 and page 2 side by side on the first sheet, then 3
and 4 and so on. You can do it in Word, it is something like a Reading view,
but I can't figure out how to do in Excel. Page Setup, fit to page did not
work. Printer was even setup to do 2 pages per sheet, but it did not work.
Any thoughts?

"Marvin P. Winterbottom" wrote:

you mean like File / Print Preview? To make it look like a report, do it
with a macro