@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

Deb Ashby | Cellmates 🇬🇧
Deb Ashby | Cellmates 🇬🇧
Open In TikTok:
Region: GB
Wednesday 21 October 2026 10:23:58 GMT
5387
219
15
7

Music

Download

Comments

ocultado_real
ocultado_real :
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
dennissaunders13
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
glennorris
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
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
navymont
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
HawksSJHawks :
Thanks, nice tip!
2026-10-21 13:04:45
1
muhammadad05
Muhammadad105 :
Easier way. Search and select then fit visible.
2026-10-21 17:39:38
0
markhobbs813
Mark Hobbs813 :
👍 Thank you 🙏
2026-10-21 23:38:48
0
msinghduk
msinghduk :
👏👏 Cheers
2026-10-22 01:40:09
0
To see more videos from user @cellmates_, please go to the Tikwm homepage.

Other Videos


About