Excellent! Many I know, but also many I have never come into contact with. Will definitely be using many of these in the future! Something I noticed with copy and paste as linked image is that it does not work with data formatted as a table, then it is not selectable. I got around it by choosing "Convert to range", copy and paste as linked image and then format the original data again as a table and the linked image then becomes a table too!
Thank you Sumit for your so handy tutorial. And I wanna add some tricks maybe they will be so useful for your lecture: 1- If we do double clicks CRTL+C when we are working in excel workbook, it will open clipboard and we can use this copied values or functions whenever we want to use. Also, you can find this property if you open clipboard pane and select property section which is located at the left bottom side of the pane. 2- If you want to copy unhidden rows or columns, select the whole range and copy and then click ALT+SHFT+; then you'll find that just visible cells will be copied and you can paste them whichever you want places.
Very Nice Video made by you Sir, Really cleared most of the doubts and would also help to get faster in excel. You teach very nicely keeping all options open for user help them . Thank you very much
Thank you Sumit! Paste Operations is new to me, so too Paste as Linked Picture the 'Camera Tool'. The latter seems like magic and can be so useful!! Your video also helped me understand the structure and power of the Clipboard. Copying Charts with Formats was new to me too!
Thank you Sumit. I am already using Alt+Ctrl+V and all the options with special paste options. However, I have learnt paste from Clipboard, Paste using enter, Alt+E+S for special paste dialogue box. Thanks again.
In my routine I make copy whole workbook means including all worksheets inside without formula. I first make a copy of whole workbook with new name then individually all worksheets, I select all data and special paste as value at same cells. Is there any shortcut to make whole workbook copy without formula?
@trumpexcel, Kindly make a video on how to unify and clean a range of inconsistent Date formats of both UK and American format, where the Day and month of each cells differs. Thank you so the tutorials you put out also.
Excellent! Many I know, but also many I have never come into contact with. Will definitely be using many of these in the future!
Something I noticed with copy and paste as linked image is that it does not work with data formatted as a table, then it is not selectable.
I got around it by choosing "Convert to range", copy and paste as linked image and then format the original data again as a table and the linked image then becomes a table too!
Thank you, Sumit, for this elaborate discussion on Copy + paste issues in excel.
Thank you Sumit for your so handy tutorial. And I wanna add some tricks maybe they will be so useful for your lecture:
1- If we do double clicks CRTL+C when we are working in excel workbook, it will open clipboard and we can use this copied values or functions whenever we want to use. Also, you can find this property if you open clipboard pane and select property section which is located at the left bottom side of the pane.
2- If you want to copy unhidden rows or columns, select the whole range and copy and then click ALT+SHFT+; then you'll find that just visible cells will be copied and you can paste them whichever you want places.
Mind blowing. very well made. Thanks
Excellent! Thank you!
Very Nice Video made by you Sir, Really cleared most of the doubts and would also help to get faster in excel. You teach very nicely keeping all options open for user help them . Thank you very much
Superb man. God bless u 😊
Thanks sumith
Fabulous video- learned lots of copy and paste hacks I didn't know before. Thank you!
Glad you found it helpful 🙂
Very useful! You learn something every day; or in this video, I learned about 23 things! Thank you :)
Thanks for the video it was all very useful. Windows + V is a great shortcut that I didn't know existed, thanks
Superb tutorial, Sumit.
Thank you for sharing all these wonders.
Definitely a huge value addition to my knowledge of excel. Thank you.
Amazing Tutorial
Thank you Sumit! Paste Operations is new to me, so too Paste as Linked Picture the 'Camera Tool'. The latter seems like magic and can be so useful!!
Your video also helped me understand the structure and power of the Clipboard.
Copying Charts with Formats was new to me too!
Awesome video ❤, have put all of the tricks in one video! The trick to increment sheet nos was something new for me. Thanks Summit 🙏
bhai....mere ko tou 1st trick he ni pata thi...hats offff...man..keep it up
Thank you Sumit. I am already using Alt+Ctrl+V and all the options with special paste options. However, I have learnt paste from Clipboard, Paste using enter, Alt+E+S for special paste dialogue box. Thanks again.
Thanks for this. It helps clarigy the different styles of C/P, Thanks for sharing!
Very informative Video. Thank you Summit
Great video. I learnt a couple of new tricks. Thanks appreciate your tips
Thanks for kind effort.
Control Shift V I have started using after watching your earlier vedios. Thank you so much
I also use it all the time now. Very handy and works in most applications
Very useful tricks. Thank you again for your genius work.
Amazing tricks kudos to your efforts Sumit
Thank you Sumit for informative video !!!
Awesome !!
Very useful, thank you.
Thank you Sumit , great tutorial
Great transfer of knowledge, specially copy as link, thank you
Extremely useful
Bravo
Many of tricks I never seen before.
Keep it up
Thanks for the tutorial
Very useful,I learned lots from this video ❤️❤️❤️
Thank you sir
u are just wao.man................plz make more on dashboard...solving projects more and momre
Thanks Sumit, I didn't even know about ~90% of the functions.
Gracias Sumit. Fue muy útil: copiar los "Links" y "Clipboard
Thank you Nanba very useful
Thank you. ❤
Thanks wiggle is new for me
Thanks sir ❤
More useful content
HI sumit
Can u upload more video for power query in your playlist
In my routine I make copy whole workbook means including all worksheets inside without formula.
I first make a copy of whole workbook with new name then individually all worksheets, I select all data and special paste as value at same cells.
Is there any shortcut to make whole workbook copy without formula?
Dynamic picture pasting is new to me
Can you tell how to add space in between first and last name where both of them are written together in a cell? WITHOUT THE USE OF VBA
I know very well
@trumpexcel, Kindly make a video on how to unify and clean a range of inconsistent Date formats of both UK and American format, where the Day and month of each cells differs.
Thank you so the tutorials you put out also.
Please make more video on PQ and M code
Hello , how about the WPS office? Can teach me pls ?
I don't know if you realize how important and valuable you are here in the U.S at Amazon!
I am happy and grateful to know my work is helpful. Thank you so much for the kind words 😊
How can we copy data till the cell in column before the cureent column with keyboard
😊😊😊
😢 sir please one vedio in topic workbook how to share in server ☹️
@trumpexcel nothing new😂
Excellent! Thank you!