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.
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.