Multiple print areas printout on one sheet

[Excel Chimp]

I want to have two print areas (C11:D33 & G11:I33) print on one sheet of paper. Excel seems to want to put each print selection area onto a separate page. Is this standard behavior? I can't figure out how to do it.

Please see below.

Excel Workbook
	C	D	E	F	G	H	I
11			Reforecast	Budget	Budget	$ Increase	% Increase
12			2011	2011	2012	(Decrease)	(Decrease)
13
14	OPERATING INCOME
15	Gross Potential Rent		1,730,160	1,730,160	1,958,880	228,720	13.2%
16	Loss to Lease		(8,345)	(13,419)	(45,809)	(37,464)	(448.9%)
17	Down Units		(58,560)	(18,023)	(69,253)	(10,693)	(18.3%)
18	Misc Other Rent		-	-	-	-	0.0%
19	POTENTIAL RENT		1,663,255	1,698,719	1,843,818	180,563	10.9%
20	Rent Concessions		(101,859)	(52,941)	-	101,859	100.0%
21	Recurring Concessions		(218,203)	(334,994)	(174,025)	44,178	20.2%
22	NET POTENTIAL RENT		1,343,192	1,310,784	1,669,792	326,600	24.3%
23	Vacancy Loss		(204,713)	(187,734)	(735,404)	(530,691)	(259.2%)
24	NonRev Units		(36,420)	(36,420)	(10,896)	25,524	70.1%
25	Delinquent Rent		(64,441)	(80,500)	-	64,441	100.0%
26	Prepaid Rent		281	-	-	(281)	(100.0%)
27	Bad Debt		(7,477)	1,500	(191,000)	(183,523)	(2,454.6%)
28	TOTAL RENTAL INCOME		1,030,422	1,007,629	732,492	(297,930)	(28.9%)
29	Total Other Income		59,857	81,920	18,520	(41,337)	(69.1%)
30	Net Commercial Income		-	-	-	-	0.0%
31	TOTAL INCOME		1,090,279	1,089,549	751,012	(339,267)	(31.1%)
32	Physical Occupancy		88.2%	89.1%	62.5%
33	Economic Occupancy		59.6%	58.2%	37.4%
34
Summary

Excel 2010

 

[daniels012]

There is not a simple way of doing this other than using sheet 2.
Put in cell A1 =C11 then copy the formula all the way to cell B33
Then in Column C1 Enter =G11 all the way to D33


That is the way i would do it. And then just print that page.
Michael

 

[Excel Chimp]

Thanks. I wasn't sure if there was something I was missing.