15 'Awesome' Paste Special Tricks Every Excel User Should Know скачать в хорошем качестве

15 'Awesome' Paste Special Tricks Every Excel User Should Know

Paste Special in Excel can be a game-changer when it comes to copy-pasting in Excel. In this video, I will show you everything you need to know about this feature. While most people carry on with regular copy-paste, understanding how Paste Special works can really save you a lot of time and make you look like an Excel genius. 00:00 Intro 00:27 Opening Paste Special - Shortcuts 01:49 Paste as Values 03:46 Only Paste Formatting 04:37 Paste Formulas 06:38 Copy Paste Column Width 07:44 Copy Paste Comments and Notes 08:36 Copy Paste Data Validation 09:24 Paste and Keep Source Formatting 10:44 Paste Everything Except Borders 11:12 Merge Conditional Formatting 12:51 Paste Special Operations (Add, Multiply, Subtract, Divide) 16:24 Transpose and Paste 17:44 Paste and Slip Blanks 18:50 Paste Links 19:41 Paste as Linked Picture 21:56 Paste Special in Charts ➡️ Download File: https://www.dropbox.com/scl/fi/s5gpec... ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB ✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c... ✅ Free VBA course - https://trumpexcel.com/excel-vba-course/ ✅ Free Power Query Course - https://trumpexcel.com/power-query-co... ✅ Best Excel Books: https://trumpexcel.com/best-excel-books/ Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc... #Excel #ExcelTips #ExcelTutorial #SumitBansal