Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Go behind the scenes with some of the biggest digital celebrities to see what life is like when the blogging and tweeting stops.
The story of punk rock singer Laura Jane Grace of Against Me! who came out as a woman in 2012, and other members of the trans community whose experiences are woefully underrepresented and misunderstood in the media.
Documentary shorts conceived of and directed by famous actors. Jeff Garlin, Katie Holmes, Alia Shawkat, Judy Greer, and James Purefoy
Park Bench is a new kind of "talking show" straight from the mind of born and bred New Yorker and host, Steve Buscemi.
Digital influencer Justine Ezarik (iJustine) is back. After covering the world of wearable tech last season, iJustine is expanding her coverage this year by profiling the hottest tech trends across the country.
A 12 episode documentary series following 5 startup companies competing in the 2013 San Francisco TechCrunch Disrupt Startup Battlefield as they fine tune their products and eventually present in front of a panel of judges in hopes of winning $50,000 in funding.
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.
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.
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.”
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity.
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.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
In this Excel 2007 tutorial, learn how to save display and print settings using custom views, so that you don't have to go ...
through the hassle of changing each and every setting again.
Tags:How to Use Custom Views - Excel 2007,Excel 2007,excel custom views,excel help,Excel tips,Excel tutorials,how to use custom views,How to Use Excel,software help,software tips,tech help,techtutortv
Grab video code:
When you’re working with an Excel you might want to have what’s color custom view. And a custom view allows you to have different displays, different print settings that you can go back to when you are doing a certain task and you want to view your workbook in a different way.
For instance you might want to have a separate view when you edit your spreadsheet or when you analyze your spreadsheet. You might want to have different margins, a different print areas set, different splits, a different zoom level. How you can set up a custom view is by clicking on your view tab and then click on the custom views. This will bring up the custom views dialog box.
To add a custom view just click on the add button and then you’re going to name your custom view. Go ahead and put editing field. Now you have the option of including the print settings on the view and also hidden rows, columns and filter settings. Just uncheck the boxes if you don’t want to include those in the view. Click OK and you’ve created your custom view now.
When you’re ready to apply your custom view, click on custom views and you’ll see that you have your save custom views. Make sure that the one you want selected right here you just have one, the one we just created editing view, have that selected and click on show and it will automatically change the view. The margins that I have changed, the zoom level that I have set are all suddenly applied. I don’t have to change each of those settings every single time I want a different view.
Now to delete a custom view, if you don’t use it anymore, click on custom views, make sure the custom views is selected that you don’t want to use anymore and click the delete button. You get a confirmation, do you wish to delete it, click yes and it will delete it. You’ll be left with what you have to your custom views, click close to close that dialog box and you can create as many custom views as you need for whatever task you needed.