Ten Excel Paste Special Tricks to Make You a Pro

Learn these ten Excel Paste Special tricks to make you a pro.
Pasting data is one of the most common actions, but do you know these Paste Special tricks to save time and perform secret operations.
These tricks include different examples of using the paste operations and useful 'real world' examples of using Paste Special.
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Find more great free tutorials at;
www.computergaga.com
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

[@mohammadmalik5640]

Tired and hurt 62 years old heavy truck mechanic trying to learn something less physically taxing . I found this tutorial exceedingly helpful to understand despite of highly technical material. Thankfully wishing you all the very best!

[@HappyGoLucky-tr8bo]

I wish I knew the paste special values years ago. Thank you 🙏🏽 for this.

[@Computergaga]

You are so welcome

[@mohideenthassim7180]

great little tricks Alan, many thanks! for your efforts in teaching this to everyoneCheersMohideen

[@wayneedmondson1065]

Hey Alan.. great tricks.. especially Paste Chart Formatting and Skip Blanks.. Excellent! Thanks and Thumbs up!

[@Computergaga]

Thank you Wayne.

[@glennlangford5897]

Excellent, very clear as usual, thanks Alan

[@Computergaga]

Thank you Glenn.

[@marktheexcelguy682]

Thanks for the tips! I never knew you could paste the formats on charts, that's a nice trick. I've only used paste special to paste formatting onto cells to make sure tables stay neat and tidy!

[@bennettlachlan973]

instablaster.

[@ianodonoghue6011]

Thanks for this. Really learning so much from your videos. The transpose trick will help greatly in work.

[@Computergaga]

Great to hear! Thank you, Ian.

[@anessaabs8135]

Thanks for this 🙏🏾

[@Computergaga]

You're welcome Anessa.

[@MK-uu2et]

Really Helpful

[@jsvlad]

awesome work. keep it up

[@Computergaga]

Thank you for the words of encouragement.

[@hazemali382]

the great video many thanks

[@Computergaga]

You're welcome Hazem. Thank you.

[@chinmayeesingh9040]

thanks sir...its 3rd no paste special type was not known to me...really helpfull

[@Computergaga]

Great, thanks.

[@chinmayeesingh9040]

a great thanks to u.... if u were a resedencee of india then i cd gift you for each lesson

[@stopdrinkingleftskoolaid6510]

Hello. At 3:35 you can also click on the select all button at the top left corner which selects every cell on the sheet. Then double click on just one “short” cell which hides part of or most (#####) of the data in every short cell. This adjusts every cell that needs to be lengthened to see all the data in the cells or shortened to remove extra space in each cell

[@Computergaga]

Thank you for the great tip. This is slightly different to what was shown at 3:35, as in the video we are copying the exact width of another column. While your tip autofits the column width to the content.

[@amit12000]

Great video

[@Computergaga]

Thank you Amit.

[@beingindian6007]

awsm tricks...pls make video for macro vba

[@Computergaga]

Thanks, there are more coming :)

[@sandeepkothari5000]

Gr8!

[@Computergaga]

Thank you Sandeep.

[@cd-ux9ot]

Nice text to number trick my way was a bit slower

[@Computergaga]

Thanks cd412.

[@RETENYA]

thankssss

[@Computergaga]

You're welcome, Sinan. Thank you.

[@mahamohan1]

Excel(lent) tricks simplified

[@Computergaga]

Thank you.

[@ericvanreck4686]

I did dot know the trick to paste Chart formatting. Thanks for that I often change formulas in values I use a little macro for that - saves a click Here’s the code Sub PasteValues() Application.ScreenUpdating = False Selection.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode= False End Sub If you store it in The Personal MacroWorkbook and a little button on the Toolbar it really easy and saves a click Eric

[@joefromdc]

If i hv a formula in a cell and i need to paste data over top of it, is that possible If cell 1/ row 1 is empty then copy and paste the data from cell 2/row 2

[@Computergaga]

No, you would lose the formula. You could paste over a formula with an operation such as Add. This would edit the formula to include the operation you pasted.

[@jayachandrannair6951]

how add two value in the column as mean ± SD in one column

[@reignrelic]

Why do I only get two past options ? Help!! How to I unlock the rest?

[@backendadmin1217]

Wow

[@Computergaga]

Thanks Abhi.

[@fhaque6302]

How to convert any number to text using super tricks like you ?

[@Computergaga]

There are a few ways to convert a number to text. These include the Text option in the number formatting drop down list on Home, and the TEXT function. The method you choose depends on why you are doing it, and what you need from it.

[@fhaque6302]

How to learn about simple vba to advanced vba code from you ? Why do write as string, dim, range, .cell.value, etc in excel vba. Please convince me.

[@Computergaga]

I have an online course for beginners to Excel VBA which explains all this my friend - www.udemy.com/excel-vba-course/?couponCode=ExcelVBAKZbin I do have VBA videos on this channel also though they usually about soving particular problems or tricks and not about learning VBA like my course.

[@MK-uu2et]

Sir how to convert number to words and words to Number without Macros.

[@Computergaga]

There are some formulas out there you can find on Google. I'm not sure of the formula right now.

[@uninstalledsoftwares6266]

Don't forget to increase speed to 2x

[@xXRedstonecraftXx]

boddll of wo´ a