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.  🙂

Advertisement

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:

WordPress.com Logo

You are commenting using your WordPress.com 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.