The Copy-Paste function is so essential to everyday that ctrl-c and ctrl-v has become an automatic reflex. This function is used in almost every software. However, there is a lot more to the copy/paste function in Excel than we know of or have been using. In this video I will show you these methods for copy/paste that you wish you knew years ago!
We will cover the following Paste Options:
• Simple Paste
• Paste Values
• Formulas
• Transpose
• Formatting
• Paste Link
• Comments
• Validation
• All using Source theme
• All Except Borders
• Column widths
• Formulas and number formats
• Values and number formats
• All merging conditional formats
Operations
=========
• None
• Add
• Multiply
• Subtract
• Divide
Additional Paste Options
====================
• Skip blanks
• Picture
• Linked Picture