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/s5gpec4moz4y2ems6dfbz/Paste-Special-Tricks.xlsx?rlkey=cv0sc7tkf82sjzzzvusdtcpsl&dl=1

☕ 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-course
✅ Free VBA course - https://trumpexcel.com/excel-vba-course/
✅ Free Power Query Course - https://trumpexcel.com/power-query-course/
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial #SumitBansal

Видео 15 'Awesome' Paste Special Tricks Every Excel User Should Know канала TrumpExcel