@cellmates_: 🚨 Trying to paste data into a filtered list in Excel? 👀 Ever tried pasting multiple values into a filtered list, only to discover Excel doesn’t paste them where you want? 😩 Here’s a clever workaround using Sort! 💡 In this quick tutorial, I’ll show you how to temporarily bring your filtered rows together, paste your data in one go, and then restore your original row order! ✅ No complicated formulas. No VBA. Just a simple Excel trick that saves time and frustration! Save this one for later! 💚 #ExcelTips #MicrosoftExcel #ExcelTutorial #ExcelTricks #LearnExcel
Bit more complicated, but I'd mix an xlookup with if, depending on the numbers of them. If there's a new price, use that, otherwise use the existing price
2026-10-21 10:44:01
1
Dennis Saunders :
Sort by name and number low to high.Then paste the sale prices and finally sort by item number.
2026-10-21 22:35:28
0
G No🇦🇺 :
Not tried but can you just do alt : to select only vible cells and then paste?
2026-10-26 10:54:25
0
I MacHunt 🇮🇪🍀😉☘️🍻🍺🤒🤧 :
That copy and paste glitch is one of my biggest bugbears!! Surely there must be some way to paste into filtered cells 😬😬
2026-10-21 21:16:59
1
navy :
In the lower table I’d have the product name next to the new price and use a lookup in column C to find the new price
2026-10-21 13:07:06
0
HawksSJHawks :
Thanks, nice tip!
2026-10-21 13:04:45
1
Muhammadad105 :
Easier way. Search and select then fit visible.
2026-10-21 17:39:38
0
Mark Hobbs813 :
👍 Thank you 🙏
2026-10-21 23:38:48
0
msinghduk :
👏👏 Cheers
2026-10-22 01:40:09
0
To see more videos from user @cellmates_, please go to the Tikwm
homepage.