Add Print Area - Episode 1190

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Mar 18, 2010.
Excel 2007 offers a new way to set up non-contiguous print ranges. Episode #1190 shows you how. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
maxresdefault.jpg


Transcript of the video:
The MrExcel podcast is brought to you by “Easy-XL”!
Hey alright, welcome back, it’s another MrExcel netcast, I'm Bill Jelen.
A cool trick that came along in Excel 2007, I never even realized this was here.
Of course, you can set the print area, so I choose Page Layout, Print Area, Set Print Area, that's just like File, Print Area, Set Print Area that we've had for a while.
But then, if you need to print another section, check this out, when we go back to Print Area, there's a new thing here now called Add to Print Area.
Alright, so I can have non-contiguous ranges that I want to add together into a single print area.
The only downside with this is that when we go into Print Preview, you'll see that it automatically throws a Page Break between each of those sections.
So as I go from section to section to section, it doesn't put them all together, that would have been a really cool thing.
If you want them to print all on the same page, you're going to have to use the camera tool to paste all those together, pictures on one page.
But if you're good enough with putting them out on separate pages, a great, great trick there, the Page Layout, Print Area, Add to Print Area, very cool feature, new in Excel 2007.
Hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
 

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top