Authentic voices. Remarkable stories. AOL On Originals showcase the passions that make the world a more interesting place.
Gwyneth Paltrow and Tracy Anderson spend time with women who've overcome hardship, injury, and setbacks to triumph in the face of adversity. We'll hear their inspiring stories firsthand, whether fighting back from a career-ending injury or transforming their lives and bodies through diet and exercise.
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.
The Future Of Us is a powerful original series from television personality, futurist, filmmaker and techno-philosopher, Jason Silva. In this series, Silva shares his excitement around recent discoveries and inventions.
ACTING DISRUPTIVE takes viewers inside the businesses and passion projects of Hollywood’s top celebrities.
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.
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.”
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.
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