Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Hank Azaria’s touching, humorous, and often enlightening journey from a man who is not even sure he wants to have kids, to a father going through the joys, trials and tribulations of being a dad.
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
Enter the graceful but competitive world of ballet through the eyes of executive producer, Sarah Jessica Parker. This behind-the-scenes docudrama reveals what it takes to perform on the ultimate stage, the New York City Ballet. Catch NYCB on stage at Lincoln Center.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
Explore what it means to be human as we rush head first into the future through the eyes, creativity, and mind of Tiffany Shlain, acclaimed filmmaker and speaker, founder of The Webby Awards, mother, constant pusher of boundaries and one of Newsweek’s “women shaping the 21st Century.”
They say every picture tells a story and AOL On's new original series My Ink proves it. Travel along as some of the world's greatest athletes bring their tattoos to life through exclusive interviews and visits to their favorite tattoo parlors.
Discover crowdfunded small business success stories with author, comedian, and entrepreneur Baratunde Thurston.
Go behind-the-scenes with racing's hottest, young talent, 17-year-old Dylan Kwasniewski, as he aspires to make it in the #1 motorsport in America – NASCAR
Follow Scott Schuman, the Sartorialist, from the streets of NYC to the capitals of Europe on his quest to photograph and document the best in culture and fashion.
Iconic potter, designer, author and personality Jonathan Adler shares his unique perspective on creativity. Showcasing the inspiration Jonathan finds in the most unlikely people and places, Inspiration Point will add style, craft and joy to your life.
Serving Innovation gives a fresh look into the stories and passions that motivate some of the most innovative tastemakers in America.
A documentary directed by Alex Winter exploring the Napster downloading revolution; the kids who created it, the bands and businesses that were affected and its impact on the world at large.
Nicole Richie brings her unfiltered sense of humor and unique perspective to life in a new series based on her irreverent twitter feed. The show follows the outspoken celebrity as she shares her perspective on style, parenting, relationships and her journey to adulthood.
Excel 2007 offers a new way to set up non-contiguous print ranges.
Tags:How to Add to Print Area in Excel 2007,Define print area on a worksheet,Excel 2007 lesson,How to Set Print Area in Excel 2007,set up Excel non-contiguous print ranges,MrExcel
Grab video code:
How to Add to Print Area in Excel 2007
The Mr. Excel Pod cast is brought to you by Easy Excel.
Hey, all right, welcome back, it’s another Mr. Excel net cast, I’m Bill Jelen. A cool trick that came along in Excel 2007, I didn’t realize it was here; of course you can set the print areas so I choose range of print area, set print area. That’s just like a file, a print area, a set print area that we have for a while but then if you want a 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. All right so I can have non contiguous ranges that I want to add together into a single print area.
Apparently 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 when 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 wanted to print all in the same page you have to do use the camera tool to paste all of those together, pictures on one page. But if you’re good enough with printing them out on separate pages, a great-great trick there. The paste layout, the print area, adds to print area, very cool feature, new in Excel 2007.
Hey I want to thank you for stopping by, see you next time for another netcast from Mr. Excel.