10 *SURPRISING* Copy Paste Secrets for Excel PROs

We can't live with CTRL+C (Copy) CTRL+V (Paste). So how well do you know this everyday feature.

Here are 10 powerful ways Copy Paste can improve your productivity in Excel. You will be surprised.

👉For more on Excel Copy Paste functionality, check this page
==================================================

⏱ Time stamps:
==============

0:00 - Introduction
00:25 - 10 - Copy paste data to charts
00:47 - 9 - Using CTRL to make copies
01:25 - 8 - Jiggle Copy
02:04 - 7 - Transposing formulas
03:26 - 6 - Clipboard in Office
04:26 - 5 - Multiplication copy
05:18 - 4 - Moving data without copy
05:52 - 3 - Replicate chart formatting
06:40 - 2 - Copy Pivot Connections
07:30 - 1 - Format Painter

#ExcelTricks

[SanjeevKumar-kshg]

It is rightly said and confirmed with this video yet again that an average Excel user doesn't know more than 10% of the available functionality. Great tips Chandoo! Awesome 👌

[moustick]

I am following you for years and you always find a way to reinvent yourself to stay updated. A lot of Excel master are out there but no one is close to you, you are unique and I am lucky to had your class in the pass. keep the good work you are awesome.

[pektuspektus]

There's really more to learn in Excel,
Even the copy paste.
Thanks Chandoo!

[axelknutt]

Wow! I think I only knew 2 of those ‘tricks’. Great work and simple explanation. Thank you

[rdatta]

*Excellent* set of tips. Really well done. Some of the tips like the Jiggle Copy and copying a series into a chart are not commonly discussed at all. Thank you!

[johnpaulosalto]

Idk but I'm always satisfied listening to Indian's way of tutorial than that of the western's. Chandoo's style are much clearer and easier for me to understand. This guy deserved more subs.

[vn]

Thank you Chandu is all I could say. Really it is awesome and I have found at least couple of things that will improve my productivity in

[sushantachoudhury]

This is awesome. Paste using clipboard and using alt to change column positions are the 2 best learnings for me.

[maher-s]

Thank you Chandoo for grate video, super helpful.

[chriskulig]

I am impressed! Wow, thank you for this. The transpose for formulas blew my mind!

[GratefulThird]

Super helpful - I learned a lot - thank you so much.

[abdulrazakabdulkarim]

Lord have mercy I can't get enough of Channdoo

[ythetytad]

This is insane!! Never knew most of these tricks. Thank you!

[Patrick-gezn]

I do graphing often and didn't know the first short cut . good to know now, Thanks Chandoo . 👍

[pritikane]

Even the simple copy paste function has so many tricks Chandoo rocks

[dineshnagwekar]

Great information!
Thank you!
Keep it up!

[wayneedmondson]

Hi Chandoo. Great list of powerful and useful Copy / Paste tricks! Thanks for sharing :)) Thumbs up!!

[bin-naya]

MAMAMIA Totally learned new tricks you are GENIUS

[dougmphilly]

format painter and transpose with formulas are going to gets lots of use. thank you.

[skydvgrl]

Great tips that are delivered very succinctly and concisely. Nice job!