There's a particular kind of frustration that comes from working inside a spreadsheet you didn't build. You're not asking for much, just a quick highlight of a column's range, but the tool seems to have its own ideas about what you meant. That's exactly the situation one Reddit user described this week: clicking and dragging to select a single column in a filtered sheet, only to have Excel grab a broader range instead. The video they shared shows the problem clearly, and the question they ask is the right one: is this a setting, or is it just how filtered data behaves?
The short answer is that this isn't a bug you can toggle off, and it's not a sign that you're doing something wrong. When a sheet is filtered, Excel is still tracking the hidden rows beneath the surface. Your click-drag might look like a simple column selection, but the program is interpreting it as a request to include those invisible cells too. It's one of those quirks that makes perfect sense once you understand the underlying logic, but it's rarely explained clearly. That gap between what we see and what the software sees is exactly where tools like Excel start to feel less like helpers and more like obstacles. It's also why we've written before about how Excel not filtering unique values can trip people up in similar ways, when the visible data doesn't match the full dataset underneath.
What's worth appreciating here is that this isn't a deep technical failure. It's a matter of learning the rules of engagement. Once you know that filtered sheets require a different selection method, the fix is straightforward: use the keyboard shortcut to select visible cells only, or adjust your selection approach to account for the hidden rows. It's the kind of knowledge that feels small until you're the one staring at a highlighted block you never asked for, wondering if you're missing something obvious. In that sense, this question is really about the broader challenge of working with data that has its own hidden structure, a theme that also shows up in how we approach Power Query help spitting data from a column into multiple new column, where the goal is often to reshape messy inputs into something more predictable.
Our take is simple: don't let this moment convince you that spreadsheets are working against you. They're just literal, and that literalism can feel like resistance when you're moving fast. The real lesson here is about patience with the tools we rely on, and the value of asking the question out loud when something feels off. The user who posted this did exactly what they should have done, and the answer they found will save them time on every filtered sheet they touch from now on. That's the practical takeaway worth quoting: "Understanding that hidden rows still count in your selection is the key to moving past this." The next time you're in a filtered view and the selection feels wrong, remember that the data isn't being stubborn, it's just waiting for you to speak its language.