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