Excel Magic Trick #42: 6 Ways To Paste Special & TRANSPOSE
See how to Paste Special in 6 ways: Paste Special Transpose, Paste Special Skip Blanks, Paste Special Multiply Operation, Paste Special Formats (Format Painter), Paste Special Values, Paste Special Formulas. You will also see hoe to use the Array Function TRANSPOSE (Array Formula).
If you have ever had a table the orientated vertical/horizontal and you need to have it horizontal/vertical, you will not believe how easy it is with Paste Special Transpose or TRANSPOSE function.
If you have ever wanted to switch your column and row headers in a table, you will not believe how easy it is with Paste Special Transpose or TRANSPOSE function.
If you have ever wanted to paste some values but not paste the copied blanks, the Paste Special Skip Blanks will amaze you!
If you have ever needed to increase a set of numbers by 10% and you did not want to use a formula, Paste Special Operation Multiply will amaze you!
Channel: Science & Technology
Uploaded: November 30, 1999 at 12:00 am
Author: ExcelIsFun
Length: 06:01
Rating: 4.86
Views: 1769
Tags: Blanks College Community Excel Formula Gel Girvin Highline Mike Multiply Operation Paste Skip Special Transpose Values
Video Comments
|
