There's a quiet frustration that builds when you're mid-formula, fingers moving with intent, and your Mac decides to yank you into another spreadsheet entirely. That's exactly what's happening to this user, and it's not a minor hiccup, it's a daily disruption that erodes trust in the tool you're supposed to be commanding. The issue isn't that they're doing something wrong. It's that the software's default behavior is fighting them, and when that happens 95% of the time, the problem isn't the user, it's the design.
Here's what's actually going on: when you press Ctrl/Cmd+Shift+Arrow in Excel for Mac, the system isn't always interpreting that as a range selection. Instead, macOS has its own window management shortcuts that can intercept those keystrokes, especially when multiple Excel files are open. The result? You think you're selecting data, but the OS thinks you're switching apps or moving windows. It's a classic case of two systems colliding, and the user is caught in the middle. The practical takeaway is straightforward: this isn't a mystery or a personal failing. It's a known quirk of how macOS and Excel for Mac interact, and it demands a deliberate workaround, whether that's remapping the shortcut in System Settings, using a third-party tool like Karabiner, or simply learning to use Fn+Command+Arrow as a fallback.
What makes this worth talking about isn't the shortcut itself. It's what the shortcut represents. Spreadsheets are supposed to be the most direct path from thought to output. When the tooling gets in the way of that, even for a split second, it breaks your flow and makes you question whether the tool is actually on your side. This user is doing everything right, they're trying to be efficient, they're trying to move fast, and the machine keeps slapping their hand away. That's not a user problem. That's a design gap, and it's one that becomes painfully obvious the moment you try to do real work across multiple files.
So here's our plain advice: don't accept the 95% failure rate as normal. Test your shortcuts in a controlled way, check your keyboard settings for conflicting commands, and if you're still stuck, remap the keys so they do what you need them to do. The goal isn't to master some arcane workaround, it's to get back to the point where your spreadsheet responds to you, not the other way around. If that means spending ten minutes adjusting system preferences, do it. Because the alternative is living with a tool that fights you every time you try to move forward, and that's no way to work.