We've all been there. A user on Reddit lays out a simple, reasonable request: click a name in one column, and have every matching name across the entire sheet highlight and stay highlighted. The problem isn't that the concept is complex. The problem is that traditional spreadsheet tools treat each cell as an island, forcing users to become manual search-and-destroy operatives. This user is spending their time hunting for "John Doe" across columns, clicking and highlighting each instance by hand. That isn't data management. That is busywork dressed up as productivity.
This request reveals a fundamental gap in how we think about spreadsheets. The user isn't asking for a macro or a script. They are asking for a behavior: a persistent, visual connection between related data points. They want the sheet to understand that a name in Column A is the same entity as that name in Column D, and to reflect that relationship visually without requiring them to rebuild the logic every time. The fact that this feels like a missing feature, not a luxury, tells us something important. The tools we use have trained us to accept isolation. We adapt to the tool's limitations instead of asking the tool to adapt to our workflows.
This is where an AI-native approach changes the conversation. Instead of asking you to write conditional formatting rules or VBA scripts, a smarter spreadsheet can interpret intent. When you click a cell, the system can recognize the pattern, "this is a name, and I should find every instance of it across columns", and execute that action instantly. The highlight sticks because the association is persistent. You are no longer managing cells; you are managing relationships. For this user tracking sports players, that means one click to see every offensive and defensive position a player appears in. For anyone else, it means freeing up the mental energy currently spent on manual cross-referencing.
Our take is straightforward: a spreadsheet should do the tedious work so you can do the thinking. This user's request is not a niche edge case. It is the core of what most people need, a tool that links data without demanding they become programmers. The solution exists when we stop asking users to work harder and start building tools that work smarter. Stop hunting for matches. Start clicking.