10 *SURPRISING* Copy Paste Secrets for Excel PROs
HTML-код
- Опубликовано: 20 июл 2024
- 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
==================================================
chandoo.org/wp/17-excel-paste...
⏱ 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 Наука
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 👌
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.
It is always a pleasure to hear from long time followers like you. I am glad you find my content refreshing. I enjoy learning and sharing new things. That is what keeps me going.
Wow! I think I only knew 2 of those ‘tricks’. Great work and simple explanation. Thank you
There's really more to learn in Excel,
Even the copy paste.
Thanks Chandoo!
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.
Lord have mercy I can't get enough of Channdoo
Even the simple copy paste function has so many tricks Chandoo rocks
We spend so much of our time on copy paste, so I fugured we should master it.
@@chandoo_ Is this Applicable for Mac users
Some of these ideas can be used in Mac... Give them a try and let us know which do & don't work.
*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!
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
Some great tips. Thank you.
Thank you Chandoo for grate video, super helpful.
Super helpful - I learned a lot - thank you so much.
I am impressed! Wow, thank you for this. The transpose for formulas blew my mind!
You're very welcome!
Great information!
Thank you!
Keep it up!
This is awesome. Paste using clipboard and using alt to change column positions are the 2 best learnings for me.
Great to hear!
I do graphing often and didn't know the first short cut . Sooooo good to know now ,Thanks Chandoo . 👍
This is insane!! Never knew most of these tricks. Thank you!
Chandoo, great tips as always!
Hi Chandoo. Great list of powerful and useful Copy / Paste tricks! Thanks for sharing :)) Thumbs up!!
Thanks Wayne.
Like before starting the video and drinking my morning chai....awesome tricks.
Great tips that are delivered very succinctly and concisely. Nice job!
Glad you enjoyed it!
Hi pretty
Great tips! Thank you!
format painter and transpose with formulas are going to gets lots of use. thank you.
MAMAMIA Totally learned new tricks you are GENIUS
Wow it's always pleasant to visit this channel. Dear Chandoo your vids have made me look pretty smart in front of senior managers 😅
Your tips and tricks are always immensely useful, thank you very much
Aww.. that is lovely. Thank you Thangavelu.
So much good knowledge!! Thankyou!
Awesome Chandoo.
I am you fan since you were sending the excel newsletter.
Thanks
It's my pleasure Swpanil to see you here as well. Thanks for your love and support.
Great tricks! Thank you 🙏
now that's called a brilliant suggestion from RUclips........and I put this channel into my subscription list....grt work chando🤗🤗
Thank you so much 😀
New tricks found in this video, Thanks Chandoo
Thank you, I am always thinking of other ways on how to copy the data without deleting the old data specially with formulas
Thanks. Very useful as usual.
Awesome. A couple of these I haven’t done before. Thanks.
Glad you like them!
There is so much that I dont know in this universe.. thanks Chandoo guru
Excellent Video - THANKS
Brilliant video. Can't imagine why some people disliked it.
Very useful video with good volume.. Thank you so much chandoo..
You're welcome 😊
The tricks are simple and just awesome - thank you
Glad you like them!
Great session, Thanks
Even the graphics and animations are amazing...Chandoo you are genius!!!
Thank you.
Great TIPS! Keep up the great work! Love it!!
You are welcome Asantewa...
Thank you for this. I was wanting to transpose a lot of data, but not EVERY row, just every 2nd-5th row and paste paste them into the columns. No video was telling me how to do this without getting an error message, and I was so frustrated. Thank you for showing me how to do it without getting error messages!
Hello Chandu,
Thanks for this superb video. What happens when we move data inside a table with Alt + drag ? Does is impact formulas?
They are very helpful tips, thank you Chandoo.
Glad you like them!
Thank you so much for everything, you never know *all* the shortcuts... BTW ALT+Drag thing works without ALT too.
Awesome ..
Learned few one totally new
The giggle paste.. lol.. love it....it's the Alternative Drop Down Menu
Very useful tips and I can't thank you enough. 🙏
My pleasure 😊
Damn, the #6 is really helpful man. Thanks a lot Chandoo
Big fan! It was great to talk to you a while back.
This kind of content deserves a lot of subscribers. 👏❤
Wow, thank you!
Some very useful and awesome tricks!!! Thanks boss!!!
Any time!
Brilliant as usual!! Thanks.
Thank you Chris
Great video Chandoo.
Glad you enjoyed it
Very useful thank you
Hey Chandoo u amaze me with so many such less known tricks.. hats off. Btw excel is my bread and butter of my work life.. I'll enjoy even more now on
Thanks Karthik. Excel is my Bread and Butter too.
Excellent stuff!
Very good, as usual. Loved the "Coffee - Paste"...1st laugh of the morning....
Glad you enjoyed it. Took me a few takes but had loads of fun making that bit.
Very useful!!
Great video. And great shaved! xD. Thanks as usual!
Hi bro, thanks for your tricks , very useful as always,
Double click format painter! Excellent. Great bunch of tips.
Glad you enjoyed it!
Just a small correction in 05:18 Moving data without copy: Use Shift Key also along with ALT Key...then only it will work
Nice! Thanks
Amazing as usual 👍
Thank you so much 😀
This is simply superb. Been working on excel for past 10 years and everyone calling me excel guru and yet I didn't any of these tricks except the last one.
Thank you. So glad I could surprise someone as experienced as you.
Thanks a lot for these useful tricks.
Most welcome!
Very helpful tricks, thanks!
Glad it was helpful!
Nice tips. And also we can just press F4 for copying formats through format painter. F4 pastes the last format action
Great one. F4 is one my favourite shortcuts in Excel. F4 is one my favourite shortcuts in Excel. 😆
Your videos are too good & very useful. I wish, I saw these videos atleast a year back😢
Thank you very much🙏🙏🙏🙏🙏
Excelente!!
Thank you, amigo.
Awesome 🙏
Super helpful video... Thanks so much
Glad it was helpful!
Thank you 👍
Yes, there were some surprises, You took the Excel learning to a whole new level. Plz do a video over Custom Tabs with "Commands Not in the Ribbon"
Thanks Umair... I will add this to my video topics and make a tutorial sometime soon.
Ctrl+Insert = Copy & Shift+Insert = Paste. Thank You.
Great tips. Thanks for sharing.
Brilliant!
That's really cool
Excellent :-) Thank you so much
Glad you liked it!
Clipboard trick was awesome👌👌
my fav too...
Mind blown! Thank you.
My pleasure!
Love it love love love it OMG.
❤❤❤
U r the best explainer
Thank you man , you saved me some much time !!!
⌚ = 💰
Amazing 👍
Format painter is my life but that double click trick?! This was all useful!!! Ty!🤩😍
it is awesome... isn't it..?
Thanks man. I learnt some good stuff today 👍
Glad to help
Great Chandoo garu, so many new tricks, Thank You So Much!!!
You're most welcome
Very helpful for beginners
I like it
Glad to hear that
Thanks for sharing.
You are welcome Sunil :)
Gracias!
Really awesome Coffee paste.
BTW I tried to add connection to slicer it is working no need to tweak. Also moving column with alt key is now working smoothly
Great 👍
Amazing ❤❤❤
Great content, extremely helpful 👌
Thanks Akhil ... :)
very insightful!!
Glad it was helpful!
Thanks. Those are very useful!!! : )
Glad you like them!
ouahou ouahou, thank you for those useful tips, we never stop learning
Thank you. Thank you