Printing side-by-side ranges one below the other

Printing side-by-side ranges one below the other

Didn't find your answer?

Any idea how I can print two side-by-side ranges one below the other in Excel?
Tom Trainer

Replies (4)

Please login or register to join the discussion.

avatar
By User deleted
10th Jul 2006 16:32

Its in the Page setup
Hi,

There is an easy solution for this...
go to Page setup menu....and then "sheet" tab
then select "Over then Down"
and highlight the cells and preview to see if it works
should work.....

regards
ganga

Thanks (0)
avatar
By tomtrainer
10th Jul 2006 19:09

Still trying
Thanks for all your tips. The only one I can get to work, though, is Richard's

Thanks (0)
avatar
By AnonymousUser
08th Jul 2006 07:29

Printing side-by-side ranges seperatly
Assuming your second range starts in cell F10, select cell F10 and Insert a page break there. This should work

Thanks (0)
avatar
By Richard Willis
10th Jul 2006 08:54

Not sure if that would work
Hi Tom

I'm not sure Srini's idea would work, although I'm prepared to be proved wrong.

A simple solution would be to replicate the second range BELOW the first one, with all cells reading from the (original) second one. Then specify the print range as the first and duplicate ranges. This of course depends on how big the ranges are and how often the layout, of the second one at least, is changed. The inference is that you want them both on one piece of paper, so I guess that they are not huge!

If you don't like the idea of having the duplicate permanently in the work, you could name the lower position and record a macro to copy the second range to this name, print the two out, and then delete the contents (NOT the name!) of the target.

Thanks (0)