You think you know Copy and Paste in #Excel?

11 Excel Copy and Paste Tips and Tricks you should know

Perhaps Ctrl+C and Ctrl+V are the pair of shortcuts you use on a daily basis.  And probably you learned that on the first day your learned Excel.  Nonetheless, do you think you know Copy and Paste well?

In this post, I’d like to share 11 practical tips and tricks about Copy and Paste in forms of short videos.  Check them out!

Copy and Paste Visible cells only in Excel


Paste with column widths preserved in Excel


Multiply a value to a range of data in Excel


Convert text date to numeric date using Copy and Paste in Excel


And seven more…

Transform (Transpose) Column into Row or vice versa in Excel


Tell Excel to Skip Blank in Copy and Paste


Paste Pivot Table as Value with format preserved in Excel


Copy Once Paste Many – Even the copied values got changed… Interesting behavior of Excel


Take an Excel Selfie with Linked Picture


Copy Chart Formats to other Charts in Excel


Copy Worksheet in Excel


Did you know something new today?  What’s your favorite copy and paste trick?  Or do you have any other awesome copy and paste tricks you want to share?  Please leave your comments below.  🙂


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.