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.
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.
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.
In this Excel 2007 tutorial, learn how to freeze certain rows and columns in your Excel spreadsheet that you would like to ...
remain in view while you are working within the workbook.
Tags:How to Freeze Panes - Excel 2007,Excel 2007,excel help,Excel tips,Excel tutorials,freeze excel panes,how to freeze panes,How to Use Excel,software help,software tips,tech help,techtutortv
Grab video code:
Freezing Paints in Excel is an easy way to keep interviews certain columns or certain rows while you're working or why you're analyzing your Excel workbook. It’s pretty easy to do this. You just click on view. And then in the window section, you're got to see a section called freeze paints. Okay, go ahead and click on that and let’s look at the last options first. If you go freeze on top row, it’s going to automatically freeze your top row, and you can see there’s a black line, meaning that the top line has been frozen and you could see how it works if you scroll down. Then it’s going to click tip that first row into view or you're looking at your other data in your workbook. Okay, if you want to unfreeze your paint, just click on freeze paints again and click on unfreeze paints. Let’s look at another option, click on freeze paints and you can go to freeze first column, and it’s going to free your first column. Once again, you can see you can scroll over, and it’s going to keep that first column in view. Let’s go ahead and take that off, unfreeze paints.
Now if you want to set custom paints that you want to be frozen or if you want to set multiple rows and columns to be frozen at the same time, you would have to do that manually. What you want to do is you want to click to the bottom of the row that you want frozen and to the right of the column that you want frozen. So if you want to freeze your top row, and your first column, you click in B2. So underneath, the row you want frozen and to the right of the column you want frozen. Make sure that cell is selected, go to freeze paints and click on your first option freeze paints. You can see, you have your black lines and it froze your first row, and your first column. You can scroll and see how that works. To unfreeze your paints, click on freeze paints, and unfreeze paints