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 use the paste special command to get pasted data to look exactly how you want it ...
- showing the formulas, values, formatting or anything in between.
Tags:How to Use Paste Special - Excel 2007,Excel 2007,excel help,excel print special,Excel tips,Excel tutorials,How to Use Excel,software help,software tips,tech help,techtutortv,use paste special
Grab video code:
You may find yourself in a situation where you want to copy some information from a worksheet and paste it some where else but you don’t want it to show up exactly how you copy them. And so in order to do that you would need to paste special. So before you can paste, you need to copy it to the clipboard first. So go ahead and select the cells that you want to copy and right click and go to copy and then go to where you want to paste whether it be in this worksheet or another worksheet, click the cell where you want to begin to paste that, right click and go to paste special.
You’re going to get the paste special dialog box. You have lots of options here. You can choose to paste it all which is just regular pasting. You are pasting exactly what you just copied. You can have it where you go ahead and paste the formulas, just the values where you keep the format of the cell, where you keep any cell comments, where you keep cell validations, where you keep the original source theme and not the theme to where your pasting it to, where you paste everything except for your borders, where you keep the column widths, where you keep the formulas and the number formats and where you keep the values in the number formats.
You also have some operation choices. You can choose none, you can choose to add and this is if you were pasting over values that were already in the cells that you are pasting. You could choose to add the values that you copied to the values that you’re pasting over, subtract, to multiply, or divide those values. You can also choose to skip blanks or to transpose. Now if you are working in two different worksheets and you want to keep it this paste special options link together when you’re working with the original item that you copied and the items that you pasted. You can choose the paste link button and I will do that for you. So let’s go ahead and choose to keep just our values and we’ll choose none for operation and we’ll click OK and we got our paste special.